After every billrun in PayEx Billing the system create the report InvoiceJournalBilling. The report contains the Invoice numbers created during the billing together with other information regarding the created invoices.
InvoiceJournalBilling
Below diagram shows the structure of InvoiceJournalBilling in current version
Encoding
The file must use UTF-8 encoding.
Name convention
InvoiceJournalBilling<CompanyNumber>_<DateTime>_<SeqNr>[BathId].xml
| Names Component | Description |
|---|---|
| CompanyNumber | The company number in our ledger system |
| DateTime | Date created, Should be in the format ISO 8601 format, YYYYMMDDhhmmss |
| SerialNumber | Should follow an uninterupted number series, 00001, and so on. |
| BatchId | The identification number from the creation of the InvoiceJournal creation process ID If billrun is based on credits made in billing web GUI, the file name for invoice journal will contain “CreateCreditInvoice_<BatchId>” within the brackets |
General information and explanation of records
During every bill run in the PayEx Billing System an Invoice journal will be created. The invoice journal contains all invoice numbers together with information regarding the created invoices. File can be used for import into different accounting systems.
CompanyNo
The identity of your accounts receivable at PayEx
String value max 6 characters restricted to "[0-9]"
CompanyName
Your registered company name at PayEx
String value max 40 characters according to "xs:string"
Date
The creation date for the InvoiceJournal. This is the date a billrun has been completed in the PayEx Billing System.
Date format YYYY-MM-DD
CustomerName
The journal presents the customer name for which an invoice has been created..
CustomerName comes from the KUB-file, K-record, field 3
CustomerNo
The journal presents the customer number for which an invoice has been created.
CustomerNo comes from the KUB-file, K-record, field 2
RegNo
Social Security Number (SSN) or Corporate Identity Number
RegNo comes from the KUB-file, K-record, field 4
RegNoCountrycode
Country code according to ISO3166 will be presented here
RegNoCountrycode comes from the KUB-file, K-record, field 7
InvoiceNo
The unique invoice number will be presented here.
String value max 15 signs restricted to "[A-Za-z0-9\-]"
SubBillId
The internal identification number from the PayEx billing system will be presented here.
String value max 25 characters restricted to "[0-9]"
Reseller
The reseller will be presented here
Reseller comes from the KUB-file, C1-record, field 6
InvoiceDate
The invoice date for respective invoice will be presented here.
Date format YYYY-MM-DD
DueDate
The due date for the mentioned invoice will be presented here.
Date format YYYY-MM-DD
TotalAmount
Total invoiced amount including VAT
Decimal value according to "xs:decimal"
Rounding
The amount to make the invoice amount without decimals
Decimal value according to "xs:decimal"
CurrencyCode
Currency code according to ISO4217 for respective invoice will be presented here.
Vatinfo
VAT info for each invoice
VatRate
VAT rates for each VAT sum on the invoice will be presented here.
Amount
Total Amount for each VAT rate on the invoice will be presented here.
Decimal value according to "xs:decimal"
VatAmount
VAT amount for each VAT rate on the invoice will be presented here.
Decimal value according to "xs:decimal"
Download current XML schema file
| Fileversion | Version | Releasedate | Comment |
|---|---|---|---|
| 2.0 | 2019 |
Change Log
April, 2019
Initial version (latest documented version)