--ABS-121611
ALTER TABLE CUSTOMERSPECIALCHARGE ADD (FIRSTINVOICEDATE DATE DEFAULT TO_DATE('31122099','DDMMYYYY') NOT NULL);
CREATE INDEX XIE1CUSTOMERSPECIALCHARGE ON CUSTOMERSPECIALCHARGE (FIRSTINVOICEDATE);

ALTER TABLE WEARERINVENTORY ADD (FIRSTINVOICEDATE DATE DEFAULT TO_DATE('31122099','DDMMYYYY') NOT NULL);
CREATE INDEX XIE6WEARERINVENTORY ON WEARERINVENTORY (FIRSTINVOICEDATE);