--Order 20011171.80 - correction: value 4 was missing from constraint


--------COSTPRICELIST----------
ALTER TABLE COSTPRICELIST DROP CONSTRAINT PriceType_valid1;

ALTER TABLE COSTPRICELIST
	ADD CONSTRAINT PriceType_valid1  CHECK (PRICETYPE IN (1, 2, 3, 4));

COMMENT ON COLUMN COSTPRICELIST.PRICETYPE IS '1 = Merchandise Cost
2 = Processing Cost
3 = Internal Calculation
4 = Standard Cost';