Oracle SQL, PLSQL, APEX How To's by Dr. S. Raghunathan - HTML preview

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"