--Order 20011061.50

ALTER TABLE CUSTOMERRESIDENTIALSETTINGS
	ADD (PRINTCLIENTDELIVERYNOTE NUMBER  DEFAULT 1 NOT NULL CONSTRAINT PrintClientDeliveryNote_valid1 CHECK (PRINTCLIENTDELIVERYNOTE IN (0, 1, 2, 3, 4, 5)));



COMMENT ON COLUMN CUSTOMERRESIDENTIALSETTINGS.PRINTCLIENTDELIVERYNOTE IS '0 = Manual
1 = Outscan / sort, Upon closing batch
2 = Soil receiving, upon change of batch
3 = Soil receiving, upon change of client
4 = Outscan / sort, upon change of client
5 = Both soil receiving and outscan / sort, upon change of client.';


