--20010821.110
/*
commented this script because it was requested to be downgraded starting with 80203 release; 
created new script that contains modifications for order 20010821: Script_08.02.03.65

ALTER TABLE LOCATIONTYPE
	ADD (USEFORPURCHREQCALCULATION NUMBER  DEFAULT 1 NOT NULL CONSTRAINT UseForPOCalcu_valid CHECK (USEFORPURCHREQCALCULATION IN (0, 1)));



ALTER TABLE LOCATIONTYPEPERSTOCKROOM
	ADD (USEFORPURCHREQCALCULATION NUMBER  DEFAULT 1 NOT NULL CONSTRAINT UseForPOCalcu_valid1 CHECK (USEFORPURCHREQCALCULATION IN (0, 1)));



COMMENT ON COLUMN LOCATIONTYPE.USEFORPURCHREQCALCULATION IS '0 = Do not use locations of this type
1 = Do use location of this type
';



COMMENT ON COLUMN LOCATIONTYPEPERSTOCKROOM.USEFORPURCHREQCALCULATION IS '0 = Do not use locations of this type
1 = Do use location of this type
';
*/