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;