-- ABS-47292/ ABS-114625

COMMENT ON COLUMN CONTRACTPRICELIST.PRICETYPE
  IS '0 = Undefined / inherited 1 = Wash 2 = Rent 3 = Replacement 4 = Sales 5 = Weight 6 = Repair 7 = Emblem 8 = Emblem Template 9 = Garment Insurance 10 = Special Charge 11 = Wearer Function Special Type 12 = Special Size Charge 13 = Container Rent';

ALTER TABLE CONTRACTPRICELIST
  DROP CONSTRAINT PRICETYPE_VALID1_1;

ALTER TABLE CONTRACTPRICELIST
  ADD CONSTRAINT CHK_CONTRACTPRICELIST_PRICETYPE
  CHECK (PRICETYPE IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13));
