-- ABS-64259 / ABS-73482
--- CONTRACTPRICELIST ---
ALTER TABLE CONTRACTPRICELIST DROP CONSTRAINT PRICETYPE_VALID1_1;

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

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

--- GENERALPRICELIST ---
COMMENT ON COLUMN GENERALPRICELIST.PRICETYPE IS '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';

ALTER TABLE GENERALPRICELIST ADD CONSTRAINT PRICETYPE_VALID4 CHECK (PRICETYPE IN (1,2,3,4,5,6,7,8,9,10,11,12));