--ABS-78226/ABS-78543

---------------- REASONCODE ----------------

ALTER TABLE REASONCODE DROP CONSTRAINT YN_VALIDATIONFIELD466;

ALTER TABLE REASONCODE DROP COLUMN BYPASSCUSTOMERINSURANCE;

ALTER TABLE REASONCODE ADD (BYPASSINSURANCEONRA VARCHAR2(1) DEFAULT 'N' NOT NULL
                            CONSTRAINT YN_VALIDATIONFIELD466 CHECK(BYPASSINSURANCEONRA IN('Y','N')));
COMMENT ON COLUMN REASONCODE.BYPASSINSURANCEONRA 
IS 'Used for bill damage on the RA to still charge the customer for damage even if insurance is in place';