whenever, we require to initiate reports, these tables data will be removed, and the data's from voucher-details will be accumulated and totaled by ledger-name and will be stored in these tables. In otherwise, Ledger-names wise, the data's will be summed and if ledger-name belongs to balance sheet then it will be inserted in balance-sheet table and if the report-type of ledger-name belongs to profit and loss then it will be inserted in profit-loss table.
Further, credits total will be placed in liability 1 income and all debit totals will be stored against asset 1 expenditure.
CREATE TABLE "BALANCE_SHEET" ( "RECORD_ID" NUMBER,
"LEDGER_NAME" VARCHAR2(200), "LIABILITY" NUMBER(16,2), "ASSET" NUMBER(16,2),
CONSTRAINT "BALANCE_SHEET_PK" PRIMARY KEY
("RECORD_ID") ENABLE
)
CREATE TABLE "PROFIT_LOSS"