-- ABS-75638/ABS-78187

---------------- CONTRACTCOMPONENTGRMSETTINGS----------------
ALTER TABLE CONTRACTCOMPONENTGRMSETTINGS DROP COLUMN CHARGEREPAIRS;

ALTER TABLE CONTRACTCOMPONENTGRMSETTINGS DROP COLUMN CHARGEREPAIRCOG;

ALTER TABLE CONTRACTCOMPONENTGRMSETTINGS DROP COLUMN VARIABLESERVICES;

ALTER TABLE CONTRACTCOMPONENTGRMSETTINGS DROP COLUMN CHARGERESIDUALVALUE;

ALTER TABLE CONTRACTCOMPONENTGRMSETTINGS DROP COLUMN CHARGELOSSCHARGE;

---------------- CONTRACTCOMPONENTGRMCHARGES----------------
ALTER TABLE CONTRACTCOMPONENTGRMCHARGES ADD (CHARGEREPAIRS NUMBER NULL
                                             CONSTRAINT CHARGEREPAIRS_VALID2 CHECK (CHARGEREPAIRS IN (0,1,2)),
                                             CHARGEREPAIRCOG NUMBER NULL
                                             CONSTRAINT CHARGEREPAIRCOG_VALID1 CHECK (CHARGEREPAIRCOG IN (0,1,2)),
                                             VARIABLESERVICES NUMBER NULL 
                                             CONSTRAINT VARIABLESERVICES_VALID1 CHECK (VARIABLESERVICES IN (0,1,2)),
                                             CHARGERESIDUALVALUE VARCHAR2(1) NULL
                                             CONSTRAINT YN_VALIDATIONFIELD469 CHECK (CHARGERESIDUALVALUE IN ('Y','N')),
                                             CHARGELOSSCHARGE VARCHAR2(1) NULL
                                             CONSTRAINT YN_VALIDATIONFIELD468 CHECK (CHARGELOSSCHARGE IN ('Y','N')));

