-- ABS-81281/ ABS-83245 
ALTER TABLE WEARERINVENTORY ADD (LOSSCHARGEMAXINVOICELINE_ID NUMBER NULL);

CREATE INDEX XIF10WEARERINVENTORY ON WEARERINVENTORY (LOSSCHARGEMAXINVOICELINE_ID ASC);

ALTER TABLE WEARERINVENTORY
  ADD CONSTRAINT FK_WEARERINV_LOSSCHMAXINVLINE FOREIGN KEY (LOSSCHARGEMAXINVOICELINE_ID)
  REFERENCES INVOICELINE (INVOICELINE_ID) ON DELETE SET NULL;