--20011270.60


ALTER TABLE DELIVERYVARIATIONS
	ADD (STOCKCOUNTQTY NUMBER  DEFAULT 0 NOT NULL,
	     NORMSTOCKLEVEL NUMBER  DEFAULT 0 NOT NULL,
	     STOCKCOUNTDATE DATE NULL);



ALTER TABLE PACKINGNOTELINE
	ADD (STOCKCOUNTQTY NUMBER  DEFAULT 0 NOT NULL,
	     NORMSTOCKLEVEL NUMBER  DEFAULT 0 NOT NULL,
	     PREVDELIVEREDQTY NUMBER  DEFAULT 0 NOT NULL,
	     PREVSTANDARDQTY NUMBER  DEFAULT 0 NOT NULL);

ALTER TRIGGER CUSTOMER_CHECK_CONTRACT_USAGE DISABLE;

ALTER TABLE CUSTOMER
	ADD (LINENORDERINGMETHOD NUMBER  DEFAULT 0 NOT NULL CONSTRAINT LinenOrderMeth_valid CHECK (LINENORDERINGMETHOD IN (0, 1)));

ALTER TRIGGER CUSTOMER_CHECK_CONTRACT_USAGE ENABLE;  

COMMENT ON COLUMN DELIVERYVARIATIONS.STOCKCOUNTQTY IS 'Only used for Linen Delivery Stabilizer';

COMMENT ON COLUMN DELIVERYVARIATIONS.NORMSTOCKLEVEL IS 'Only used for Linen Delivery Stabilizer';

COMMENT ON COLUMN DELIVERYVARIATIONS.STOCKCOUNTDATE IS 'Only used for Linen Delivery Stabilizer';



COMMENT ON COLUMN PACKINGNOTELINE.PREVDELIVEREDQTY IS 'Only used for Linen Delivery Stabilizer';

COMMENT ON COLUMN PACKINGNOTELINE.PREVSTANDARDQTY IS 'Only used for Linen Delivery Stabilizer';



COMMENT ON COLUMN CUSTOMER.LINENORDERINGMETHOD IS '0 = Standard
1 = Linen Delivery Stabilizer
Option 1 is only available for module LINENDELIVERYSTABILIZER';




