-- ABS-99215/ ABS-103537

COMMENT ON COLUMN INVOICELINETYPE.TYPE
  IS '01= Rent 02= Delivery (wash) 03= Soil Weight 04= Clean Weight 05= Sales 06= Repair 07= Replacement charge 08= Automatic Replacement (non-garm) 09= Loss charge 10= Remaining value charge 11= Overuse charge 12= Prep / Emblem charge 13= Finance charge 14= Cash Delay line 15= Miscellaneous Invoice line 16= Special Charge 17= Minimum invoice amount 18= Tax 19= Emblem Rent 20= Locker Rent 21= Locker service 22= Lease 23= Stock Charge 24= Lost Customer Residual Value Charge 25= Lost Revenue Charge 26= Residential wash 27= Residential labels 28= Service costs 29= Capped Excess Amounts 30= Client rent 31= Budget 32= Down Payment 33= Statement fee 34 = Custom Garment Charge 35 = Service (only for module UNIQUEITEMSERVICE)';

ALTER TABLE INVOICELINETYPE DROP CONSTRAINT TYPE_valid;

ALTER TABLE INVOICELINETYPE
  ADD CONSTRAINT CHK_INVLINETYPE_TYPE CHECK (TYPE BETWEEN 1 AND 35); 