-- ABS-77806
--ADD COLUMN FISCALYEAR
ALTER TABLE SQ_DAILY_AR_U ADD (FISCALYEAR NUMBER(4) NOT NULL);
-- DROP COLUMNS FROM ERP_O_LEDGERAMOUNTS
ALTER TABLE ERP_O_LEDGERAMOUNTS DROP COLUMN BUSINESSUNITDESC;
ALTER TABLE ERP_O_LEDGERAMOUNTS DROP COLUMN TURNOVERGROUPDESC;
--RENAME COLUMN ERP_O_LEDGERAMOUNTS
ALTER TABLE ERP_O_LEDGERAMOUNTS RENAME COLUMN MONTHENDDATE TO ARTRANSACTIONDATE;
--ADD COLUMN ERP_O_LEDGERAMOUNTS
ALTER TABLE ERP_O_LEDGERAMOUNTS ADD (FISCALYEAR NUMBER(4) NOT NULL);