-- ABS-94348
COMMENT ON COLUMN ERP_I_CONTRACTPRICE.CATEGORY
  IS '1 = Service Costs LOG 
2 = Insurance - Weekly fee per piece 
3 = Restocking Fee 
4 = Stock Charge 
5 = Locker 
6 = General Prep Charge 
7 = Surcharge Price 
8 = Label Price 
9 = CashDelayCharge 
10 = Exchange Charge';
ALTER TABLE ERP_I_CONTRACTPRICE
  DROP CONSTRAINT CHK_ERP_I_CONTRACTPRICE_V2;
ALTER TABLE ERP_I_CONTRACTPRICE
  ADD CONSTRAINT CHK_ERP_I_CONTRACTPRICE_V2
  CHECK (CATEGORY IN (1,2,3,4,5,6,7,8,9,10));

ALTER TABLE ERP_I_CONTRACTCOMPONENT ADD (CHARGEEXCHANGECHARGE VARCHAR2(1) NULL
  CONSTRAINT ERP_I_CONTRCOMP_GRMEXCHANGER CHECK (CHARGEEXCHANGECHARGE IN ('Y', 'N')));
COMMENT ON COLUMN ERP_I_CONTRACTCOMPONENT.CHARGEEXCHANGECHARGE
  IS 'Only used for module GARMENTEXCHANGECHARGE';
  
ALTER TABLE ERP_I_CUSTOMER ADD(EXCHANGECHARGE_PRICE NUMBER(15,6) NULL, 
                               EXCHANGECHARGE_STARTDATE DATE NULL);