Name convention
BPXINVOICE_<CompanyNumber>_<DateTime>_<SEQNO>[<BatchId>].DAT
| Names Component | Description |
|---|---|
| CompanyNumber | The company number in PayEx ledger system |
| DateTime | Date created in format YYYYMMDDHHMMSS |
| SEQNO | Unbroken serial number sequence. |
| BatchId | Billing process Id |
For example: BPXINVOICE_9999_20210123121243_00123[123456].DAT
Change log
| Version | Date | Description | Created by |
|---|---|---|---|
| 1.1 | 2021-02-23 | Created document | Daniel Olsson |
| 1.2 | 2024-03-13 | Extended number of characters to 75 for field 6 (Detailifo) in T1-record | Jacob de Boer |
General information and explanation of records
BPXINVOICE01 files provide information about invoices from the PayEx billing system during billruns and reversed billruns.
Format description
All fields are separated with semicolons ”;”.
The format field is written in the way that numerical values are written as N and
alphanumerical characters are written as X. where ”n” is the maximum number of characters/digits or in certain cases number of characters that must exist.
Dot “.” is decimal separator on fields with amount. Some records are not obligatory but if they exist can some fields in the record be obligatory. Obligatory records are described with the abbreviation ” Req.” in the type column.
H - Header record
| Field name | Field no. | Format | Type | Description |
| Recordtype | 1 | H | Req. | Header record. |
| CompanyNumber | 2 | N(4) | Req. | You receive the company number from PayEx. |
| CompanyName | 3 | X(40) | Req. | Your company name |
| Creationdate | 4 | N(6) | Req. | YYMMDD |
| Creationtime | 5 | N(4) | Req. | HHMM |
T1 - Billed (Created in conjunction with the creation of the invoice basis)
Source system: BILLING
| Field name | Field no. | Format | Type | Description |
| Recordtype | 1 | T1 | Req. | Recordtype |
| SubBillId | 2 | X(20) | Req | InvoiceID-number at Payex |
| CustomerNo | 3 | X(15) | Req | CustomerNo |
| InvoiceNo | 4 | X(40) | Req | InvoiceNo |
| InvoiceDate | 5 | X(10) | Req | InvoiceDate YYYY-MM-DD |
| DistributionDate | 6 | X(10) | Req | DistributionDate YYYY-MM-DD |
| MinUsageDate | 7 | X(10) | MinUsageDate YYYY-MM-DD | |
| MaxUsageDate | 8 | X(10) | MaxUsageDate YYYY-MM-DD | |
| SubBillRunId | 9 | N(9) | Req | SubBillRunId |
T5 - Delete (Created in conjunction with the reversion of the billing.)
Source system: BILLING
Billing that has been reversed.
| Field name | Field no. | Format | Type | Description |
| Transactionstype | 1 | T5 | Req. | Transactiontype |
| SubBillRunId | 2 | N(9) | Req. | SubBillRunId |
S - Trailer record
| Field name | Field no. | Format | Type | Description |
| Recordtype | 1 | S | Req. | Trailer record |
| Number of records | 2 | N(9) | Req. | Total number of records including header and trailer |