Accounting
Purpose
The purpose of the accouting package is to aggregate Invoice Detail Lines based on Period, Invoice and General Ledger Code for all invoices within a timeframe. It also updates all aggregated GL lines and sets a invoice close date on the invoices which does not have a date set already.
The timeframe is per default the detail lines created in the previous month.
The table ACCOUNTING_MATRIX will contain invoiced data on a monthly basis, meaning any usage/fees that has been charged to an invoice with a month. An invoice covering usage charged across several month will have a row per month per GL code.
Tables
ACCOUNTING_MATRIX
The output if the package is stored in the table ACCOUNTING_MATRIX.
The table contains the following information:
Column |
Description |
|---|---|
PERIOD |
The period covered. Format is YYYYMM. |
GL_CODE |
The GL code representing the type of usage. GL Code is configured on Charge Item level. |
INVOICE_ID |
Link to the invoice containing the usage. |
TOTAL_EXCL_VAT |
The value of the aggregated usage excluding VAT. |
TOTAL_VAT |
The VAT value of the aggregated usage. |
TOTAL_NO_VAT |
Value of usage not containing VAT. |
SUM_TIME |
Number of seconds (in case of especially voice usage) |
NBR_OF_ROWS |
Number of usage lines included in the aggregated data |
INVOICE_CLOSE_PERIOD |
Date when the invoice was closed. |
INVOICE_DETAIL_LINE, CHARGE_ITEM
Tables which is used for the aggregated data.
Configuration
A DBA Scheduler Job is configured to run on a daily basis.
BEGIN accounting.month_end; END;