-- ABS-37429/ ABS-47524

---CUSTOMERBILLINGINFO table---
ALTER TABLE CUSTOMERBILLINGINFO MODIFY (MERGEPDF DEFAULT 'N');

UPDATE CUSTOMERBILLINGINFO CBI
   SET CBI.MERGEPDF = DECODE(CBI.SENDINVOICEBYEMAIL,
                             'Y',
                             CBI.ATTACHINVOICECOPIES,
                             'N');
COMMIT;