--Order 20015003

---WORKSTATION table---

ALTER TABLE WORKSTATION
	ADD (CLOSEBATCH NUMBER  DEFAULT 0 NOT NULL);

ALTER TABLE WORKSTATION
	ADD (PRINTSORTLIST NUMBER  DEFAULT 1 NOT NULL);

ALTER TABLE WORKSTATION
	ADD (PRINTCLIENTDELIVERYNOTE NUMBER  DEFAULT 1 NOT NULL);

ALTER TABLE WORKSTATION
	ADD (PRINTCOMPILEDDELLIST NUMBER  DEFAULT 1 NOT NULL);

ALTER TABLE WORKSTATION
	ADD (PRINTCUSTOMERSTICKER NUMBER  DEFAULT 0 NOT NULL);

COMMENT ON COLUMN WORKSTATION.CLOSEBATCH IS '0 = Allow close batch
1 = Not allow close batch 
';

COMMENT ON COLUMN WORKSTATION.PRINTSORTLIST IS '0 = Not visible
1 = Visible, default Yes
2 = Visible, default No
';

COMMENT ON COLUMN WORKSTATION.PRINTCLIENTDELIVERYNOTE IS '0 = Not visible
1 = Visible, default Yes
2 = Visible, default No
';

COMMENT ON COLUMN WORKSTATION.PRINTCOMPILEDDELLIST IS '0 = Not visible
1 = Visible, default Yes
2 = Visible, default No
';

COMMENT ON COLUMN WORKSTATION.PRINTCUSTOMERSTICKER IS '0 = Not visible
1 = Visible, default Yes
2 = Visible, default No
';

---CLIENTDELIVERYNOTE table---

ALTER TABLE CLIENTDELIVERYNOTE
	ADD (EMPTIED NUMBER(2)  DEFAULT 0 NOT NULL CONSTRAINT Emptied_valid1_1 CHECK (EMPTIED BETWEEN 0 AND 99));

COMMENT ON COLUMN CLIENTDELIVERYNOTE.EMPTIED IS 'Only used for Pater Noster.';

---CLIENTDELNOTELINESCAN table---

ALTER TABLE CLIENTDELNOTELINESCAN
	ADD (BOXLOAD NUMBER(2)  DEFAULT 0 NOT NULL CONSTRAINT BoxLoad_valid1_1 CHECK (BOXLOAD BETWEEN 0 AND 99));

COMMENT ON COLUMN CLIENTDELNOTELINESCAN.BOXLOAD IS 'Used for Pater Noster, to specify to which load the scan belongs.';