-- ABS-85840 / ABS-92756
ALTER TABLE PACKINGNOTE ADD (EXTERNALPACKINGSTATUS NUMBER DEFAULT 0 NOT NULL CONSTRAINT CHK_PN_EXTERNALPACKINGSTATUS CHECK (EXTERNALPACKINGSTATUS IN (0,1,2)));

COMMENT ON COLUMN PACKINGNOTE.EXTERNALPACKINGSTATUS 
IS '0 = Not applicable/Packing not started
1 = Packing started
2 = Packing completed';
