--20010821.110
-- downgraded modifications; original script is: Script_08.03.02.08

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
';
