Unbilled Report

After each billrun in PayEx Billing we create a UnbilledReport. The report contains products and fees not yet invoiced at end-costumer level. 

Name convention

When the report is ordered two files will be generated.

BRPT001_<CompanyNumber>_<DateTime>_0[Unbilled_<Term>_<BatchId>].DAT

BRPT002_<CompanyNumber>_<DateTime>_0[Unbilled_<Term>_<BatchId>].DAT

Names ComponentDescription
CompanyNumberThe company number in PayEx ledger system
DateTimeDate created in format YYYYMMDDHHMMSS
Term

From witch argument the report is created by, Possible values:

NRP = Non recurrent products, products from PR01-file

*U = Usage, traffic or events from CDR:s

*UoNRP = Usage and non recurrent products aggregated

*Is not used without agreement

BatchIdThe identification number from the creation of the InvoiceJournal creation process ID

For example: 

BRPT001_9999_20190308093539_0[Unbilled_NRP_1234567].DAT
BRPT002_9999_20190308093539_0[Unbilled_NRP_1234567].DAT

The file is semicolon-separated.

Change log

VersionDateDescriptionCreated by
1.02020-09-20

First version.

Tomas Kristoffersson


General information and explanation of records

After billing PayEx Billing are finished the reports BRPT001 and BRPT002 are created, the reports contains companies unbilled products and fees that are sent for billing, but for some reason not been invoiced. 

The BRPT001 report is semicolon separated for updating database or import to excel.

The BRPT002 report is in text -format, easy to read and printable, the report are divided in sections based on the size of amount for each customer. 

Both reports present the total amount for not invoiced products and other fees on each customer number.

Record description

For a detailed presentation of each possible record: Record description

Created by David Persson on 2021/01/29 09:26