-- ABS-83275

-------------------- ERP_I_AR_BALANCES ------------------

ALTER TABLE ERP_I_AR_BALANCES ADD ("120DAYSPLUS" NUMBER DEFAULT 0 NOT NULL);

COMMENT ON COLUMN ERP_I_AR_BALANCES.CURRENT_BALANCE
IS 'Billing balance due_date = 0 days';
COMMENT ON COLUMN ERP_I_AR_BALANCES."30DAYS"
IS 'Billing balance 0 < due_date <= 30';
COMMENT ON COLUMN ERP_I_AR_BALANCES."60DAYS"
IS 'Billing balance 30 < due_date <= 60';
COMMENT ON COLUMN ERP_I_AR_BALANCES."90DAYS"
IS 'Billing balance 60 < due_date <= 90';
COMMENT ON COLUMN ERP_I_AR_BALANCES."120DAYS"
IS 'Billing balance 90 < due_date <= 120';
COMMENT ON COLUMN ERP_I_AR_BALANCES."120DAYSPLUS"
IS 'Billing balance due_date > 120';

ALTER TABLE ERP_I_AR_BALANCES MODIFY COD NUMBER DEFAULT NULL;
ALTER TABLE ERP_I_AR_BALANCES MODIFY LASTINVOICEDATE NULL;