--Order 20014316.40

ALTER TABLE WORKSTATION
	DROP CONSTRAINT YN_VALIDATION2114;


ALTER TABLE WORKSTATION
	ADD  CONSTRAINT YN_VALIDATION2114  CHECK (OUTSCANPOOLITEMS IN ('Y', 'N', 'B'))  NOT DEFERRABLE  INITIALLY IMMEDIATE  ENABLE  VALIDATE;

COMMENT ON COLUMN WORKSTATION.OUTSCANPOOLITEMS IS 'Y means pool items only 
B means both pool items and multiread garments 
';


ALTER TABLE MULTIREADSCANBATCHCONTENTS
	ADD (DELIVERYSCANTIMESTAMP DATE NULL);