--- ABS-23430
-----------------------   BACKORDERWOL   -----------------------------
ALTER TABLE BACKORDERWOL MODIFY (WORKORDERLINE_ID NOT NULL);

ALTER TABLE BACKORDERWOL DROP COLUMN STOCKTYPE CASCADE CONSTRAINTS;


-----------------------   BACKORDERWOLE   ----------------------------	
ALTER TABLE BACKORDERWOLE MODIFY (WORKORDERLINEEMBLEM_ID NOT NULL);

ALTER TABLE BACKORDERWOLE DROP COLUMN STOCKTYPE CASCADE CONSTRAINTS;


-----------------------   BACKORDEREXECUTIONWOL   --------------------
ALTER TABLE BACKORDEREXECUTIONWOL ADD (AGGSUPPLIERPRODUCTSIZE_ID NUMBER NULL);

CREATE INDEX XIF4BACKORDEREXECUTIONWOL ON BACKORDEREXECUTIONWOL (AGGSUPPLIERPRODUCTSIZE_ID);

ALTER TABLE BACKORDEREXECUTIONWOL ADD CONSTRAINT BACKORDEREXECUTIONWOL_AGGSUP FOREIGN KEY(AGGSUPPLIERPRODUCTSIZE_ID)
REFERENCES AGGSUPPLIERPRODUCTSIZE (AGGSUPPLIERPRODUCTSIZE_ID) ON DELETE SET NULL;


-----------------------   BACKORDEREXECUTIONWOLE   --------------------
ALTER TABLE BACKORDEREXECUTIONWOLE ADD (AGGSUPPLIERPRODUCTSIZE_ID NUMBER NULL);

CREATE INDEX XIF4BACKORDEREXECUTIONWOLE ON BACKORDEREXECUTIONWOLE (AGGSUPPLIERPRODUCTSIZE_ID);

ALTER TABLE BACKORDEREXECUTIONWOLE ADD CONSTRAINT BACKORDEREXECUTIONWOLE_AGGSUP FOREIGN KEY(AGGSUPPLIERPRODUCTSIZE_ID) 
REFERENCES AGGSUPPLIERPRODUCTSIZE (AGGSUPPLIERPRODUCTSIZE_ID) ON DELETE SET NULL;