-- ABS-44609/ ABS-44637

CREATE INDEX XIF15CLIENTDELIVERYNOTE ON CLIENTDELIVERYNOTE (BATCH_ID ASC);

CREATE INDEX XIF3COSTCENTERSPECIALCHARGE ON COSTCENTERSPECIALCHARGE (CUSTOMER_ID ASC);

CREATE INDEX XIF4COSTCENTERSPECIALCHARGE ON COSTCENTERSPECIALCHARGE (SPECIALCHARGE_ID ASC);

CREATE INDEX XIF1CREDITCARDTRANSREFUND ON CREDITCARDTRANSACTIONREFUND (ARTRANSACTION_ID ASC);

CREATE INDEX XIF2CREDITCARDTRANSREFUND ON CREDITCARDTRANSACTIONREFUND (CREDITCARDTRANSACTION_ID ASC);

CREATE INDEX XIF2CUSTOMERBILLINGINFO ON CUSTOMERBILLINGINFO (COLLECTIONRESPONSIBLE_ID ASC);

CREATE INDEX XIF1CUSTOMERSERVICECOSTSPRICE ON CUSTOMERSERVICECOSTSPRICE (CUSTOMER_ID ASC);

CREATE INDEX XIF1FOLDINGPROGRAMDEFINITION ON FOLDINGPROGRAMDEFINITION (PLANT_ID ASC);

CREATE INDEX XIF1FORMPRINTCONFIGURATION ON FORMPRINTCONFIGURATION (PRINTER_ID ASC);

CREATE INDEX XIF11GARMENTSALESHISTORY ON GARMENTSALESHISTORY (REASONCODE_ID ASC);

CREATE INDEX XIF3MOBILEDEVICE ON MOBILEDEVICE (BUSINESSUNIT_ID ASC);

CREATE INDEX XIF1PACKINGNOTETAX ON PACKINGNOTETAX (PACKINGNOTE_ID ASC);

CREATE INDEX XIF2PHASEOUTWEARERINVENTORY ON PHASEOUTWEARERINVENTORY (PRODUCTCONVERSIONSIZE_ID ASC);

CREATE INDEX XIF2PRODUCT ON PRODUCT (DEFAULTMOUNTINGGRADE_ID ASC);

CREATE INDEX XIF3PRODUCT ON PRODUCT (DEFAULTSALESGRADE_ID ASC);

CREATE INDEX XIF4PRODUCT ON PRODUCT (MRPCODE_ID ASC);

CREATE INDEX XIF3PRODUCTCONVERSION ON PRODUCTCONVERSION (DESTINATIONPRODUCT_ID ASC);

CREATE INDEX XIF18PURCHASEORDERHEADER ON PURCHASEORDERHEADER (SUPLYINGSTOCKROOM_ID ASC);

CREATE INDEX XIF5RESIDUALVALUELOSTCUSTOMER ON RESIDUALVALUELOSTCUSTOMER (UNIQUEITEM_LINK_ID ASC);

CREATE INDEX XIF1RESVALSCHPERPLPCREASONCODE ON RESVALSCHPERPLPCREASONCODE (RESIDUALVALUESCHEME_ID ASC);

CREATE INDEX XIF1SORTINGDEFINITION ON SORTINGDEFINITION (PLANT_ID ASC);

CREATE INDEX XIF2SORTINGDEFINITION ON SORTINGDEFINITION (CUSTOMER_ID ASC);

CREATE INDEX XIF1UHFBUNDLE ON UHFBUNDLE (SIZEDEFINITION_LINK_ID ASC);

CREATE INDEX XIF3UHFBUNDLE ON UHFBUNDLE (PRODUCT_LINK_ID ASC);

CREATE INDEX XIF18UNIQUEITEM ON UNIQUEITEM (SUBSTITUTEWORKORDERLINE_ID ASC);

CREATE INDEX XIF2WCPCSPECIALCHARGE ON WCPCSPECIALCHARGE (SPECIALCHARGE_ID ASC);

CREATE INDEX XIF1WEARERBUDGETTRANSACTION ON WEARERBUDGETTRANSACTION (WEAREREMPLOYMENT_ID ASC);

CREATE INDEX XIF1WORKSTATIONUHFREADER ON WORKSTATIONUHFREADER (UHFREADERCONFIGURATION_ID ASC);

CREATE INDEX XIF2WORKSTATIONUHFREADER ON WORKSTATIONUHFREADER (WORKSTATION_ID ASC);
