-- i-test 88 for order 509905

ALTER TABLE PRODUCT ADD ( DELIVERFROMONPICKLISTRSC_MO NUMBER DEFAULT 1 NOT NULL
				CONSTRAINT DelPickListMO_valid
                                          CHECK (DELIVERFROMONPICKLISTRSC_MO IN (0, 1)) );

ALTER TABLE PRODUCT ADD ( DELIVERFROMONPICKLISTRSC_SN NUMBER DEFAULT 1 NOT NULL
				CONSTRAINT DelPickListSN_valid 
                                          CHECK (DELIVERFROMONPICKLISTRSC_SN IN (0, 1)) );

COMMENT ON COLUMN PRODUCT.DELIVERFROMONPICKLISTRSC_MO IS '0 - Active stock
1 - Passive stock';

COMMENT ON COLUMN PRODUCT.DELIVERFROMONPICKLISTRSC_SN IS '0 - Active stock
1 - Passive stock';

