-- ABS-67952 / ABS-74539

------------------ CUSTOMERBILLINGINFO ------------------
ALTER TABLE CUSTOMERBILLINGINFO ADD (CCWEBPAYMENTSURCHARGE NUMBER(6,2) DEFAULT 0.00 NOT NULL 
                                    CONSTRAINT CCWEBPAYMENTSURCHARGE_VALID1 CHECK (CCWEBPAYMENTSURCHARGE BETWEEN 0.00 AND 9999.99));

COMMENT ON COLUMN CUSTOMERBILLINGINFO.CCWEBPAYMENTSURCHARGE
  IS 'Surcharge for credit card payment via the web portal.';
  
------------------ PLANTCREDITCARDEBC ------------------  
ALTER TABLE PLANTCREDITCARDEBC ADD (MINPAYMENTAMOUNT NUMBER(6,2) DEFAULT 0.00 
                                   CONSTRAINT MINPAYMENTAMOUNT_VALID1 CHECK (MINPAYMENTAMOUNT >= 0));

------------------ WEBPORTALPAYMENTSESSION ------------------                                   
ALTER TABLE WEBPORTALPAYMENTSESSION ADD (PAYMENTSURCHARGE NUMBER NOT NULL);

------------------ WEBPORTALPAYMENTSESSLINE ------------------
ALTER TABLE WEBPORTALPAYMENTSESSLINE ADD (PAYMENTDISCOUNTAMOUNT NUMBER DEFAULT 0 NOT NULL);
