Main.Invoicing.billing.technical-reference.Billing Reports.InvoiceJournalBilling - InvoiceJournalBilling

Page of - last modified by Anders Göthberg on 2025/05/14 08:18

InvoiceJournalBilling

Anders Göthberg

2025/05/14 08:18

Table of Contents

InvoiceJournalBilling

Encoding

Name convention

General information and explanation of records

CompanyNo

CompanyName

Date

CustomerName

CustomerNo

RegNo

RegNoCountrycode

CustomerCategory

InvoiceNo

SubBillId

Reseller

InvoiceDate

DueDate

TotalAmount

Rounding

CurrencyCode

Vatinfo

Download current XML schema file

Change Log

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

CustomerCategory

Customer category for reporting from revenue accounting reports and accounting reports from ledger

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
InvoiceJournalBilling[2.0].xsd	2.0	2025-05-27	Updated with optional value "CustomerCategory" at customer level
InvoiceJournalBilling2.0].xsd	2.0	2019	Initial version

Change Log

May, 2025

InvoiceJournalBilling[2.0].xsd

April, 2019

InvoiceJournalBilling[2.0].xsd

Initial version (latest documented version)