...
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 ACCOUTINGtable 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
ACCOUTINGACCOUNTING_MATRIX
The output if the package is placed in this tablestored 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
...