InvoiceJournalBilling

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

1608104825892-843.png

Encoding

The file must use UTF-8 encoding


Name convention

InvoiceJournalBilling<CompanyNumber>_<DateTime>_<SeqNr>[BathId].xml

Names ComponentDescription
CompanyNumberThe company number in our ledger system
DateTimeDate 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

FileversionVersionReleasedateComment
InvoiceJournalBilling2.0].xsd2.02019 

Change Log

April, 2019

InvoiceJournalBilling[2.0].xsd

 Initial version (latest documented version)

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