--- ABS-23430
-----------------------------   BACKORDEREXECUTIONWOL   -------------------------------
ALTER TABLE BACKORDEREXECUTIONWOL ADD (BILLTOCOMPANY NUMBER DEFAULT 0 NOT NULL
					CONSTRAINT BILLTOCOMPANY_VALID1_1 CHECK (BILLTOCOMPANY BETWEEN 0 AND 1));

COMMENT ON COLUMN BACKORDEREXECUTIONWOL.BILLTOCOMPANY IS '0 = Ordering Stockroom
1 = Ship-to Stockroom';

-----------------------------   BACKORDEREXECUTIONWOLE   -------------------------------
ALTER TABLE BACKORDEREXECUTIONWOLE ADD (BILLTOCOMPANY NUMBER DEFAULT 0 NOT NULL
					CONSTRAINT BILLTOCOMPANY_VALID1_2 CHECK (BILLTOCOMPANY BETWEEN 0 AND 1));

COMMENT ON COLUMN BACKORDEREXECUTIONWOLE.BILLTOCOMPANY IS '0 = Ordering Stockroom
1 = Ship-to Stockroom';

-----------------------------   BACKORDERALLOCATIONWOL   -------------------------------
ALTER TABLE BACKORDERALLOCATIONWOL ADD (SEQUENCENUMBER NUMBER NOT NULL);

COMMENT ON COLUMN BACKORDERALLOCATIONWOL.SEQUENCENUMBER IS 'Sequence number to indicate the order in which backorder allocations have been made for a backorder execution. When reducing allocations, the sequence should be processed in reversed order.';

CREATE UNIQUE INDEX XAK2BACKORDERALLOCATIONWOL ON BACKORDERALLOCATIONWOL (BACKORDEREXECUTIONWOL_ID ASC, SEQUENCENUMBER ASC);

-----------------------------   BACKORDERALLOCATIONWOLE   -------------------------------
ALTER TABLE BACKORDERALLOCATIONWOLE ADD (SEQUENCENUMBER NUMBER NOT NULL);

COMMENT ON COLUMN BACKORDERALLOCATIONWOLE.SEQUENCENUMBER IS 'Sequence number to indicate the order in which backorder allocations have been made for a backorder execution. When reducing allocations, the sequence should be processed in reversed order.';

CREATE UNIQUE INDEX XAK2BACKORDERALLOCATIONWOLE ON BACKORDERALLOCATIONWOLE (BACKORDEREXECUTIONWOLE_ID ASC, SEQUENCENUMBER ASC);