-- ABS-90312 / ABS-99169 

------------- CLIENTDELNOTELINESCAN ----------
ALTER TABLE CLIENTDELNOTELINESCAN ADD (DELIVERYEXCEPTION NUMBER DEFAULT 0 NOT NULL 
																			 CONSTRAINT CHK_CLDELNOTELINESCAN_DELEXCEP CHECK (DELIVERYEXCEPTION IN (0,1,2,3,4))); 
COMMENT ON COLUMN CLIENTDELNOTELINESCAN.DELIVERYEXCEPTION
IS '0 = Regular delivery
1 = Item in Rewash
2 = Item out Rewash
3 = Item in Repair
4 = Item out repair';