Name convention
BRPT057_<CompanyNr>_<DateTime>_0[CreditInvoiceReportProductGroupPeriod__<BatchId>].DAT
Name | Description |
CompanyNr | The company number in PayEx ledger system |
DateTime | Date created in format YYYYMMDDHHMMSS |
CreditInvoiceReportProductGroupPeriod | Report type |
BatchId | Billing processId |
Examples of report files.
BRPT057_99999_20240301081544_0[CreditInvoiceReportProductGroupPeriod__2732732].DAT
Change log
Version | Date | Description | Created by |
---|---|---|---|
1.0 | 2024-03-26 | In production | Anders Göthberg |
General information and explanation of records
The BRPT057 report presents all credit invoices including all product groups per created credit invoice created in the PayEx Credit Invoice GUI during a certain period. In order to be able to create a credit invoice, it is assumed that a debit invoice is used as a basis. All credit invoices have been approved before creation.
This report will be created every month and presents all products summarized on product group level per invoice.
Format description
All fields in the mentioned reports 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.
Record description
H - Header record
Field name | Field no. | Format | Type | Description |
Record type | 1 | H | Req. | Record type |
Company number | 2 | N(5) | Req. | You receive the company number from PayEx. |
Company name | 3 | X(40) | Req. | Your company name. |
Period start | 4 | N(10) | Req. | YYYY-MM-DD – credit invoice information from date |
Period end | 5 | N(10) | Req. | YYYY-MM-DD – credit invoice information until date |
Created date | 6 | N(10) | Req. | YYYY-MM-DD – Same date as in the file name. |
Example on the records appearance.
H;99999;CompanyName;2019-08-01;2019-08-31;2019-09-01
H1 - Description information credit invoice record
Field name | Field no. | Format | Type | Description |
Record type | 1 | H1 | Req. | Record type |
CreditInvoiceNo | 2 | CreditInvoiceNo | Req. | |
CreditAmount | 3 | CreditAmount | Req. | |
CustomerNo | 4 | CustomerNo | Req. | |
DebitInvoiceNo | 5 | DebitInvoiceNo | Req. | |
CapitalAmount | 6 | CapitalAmount | Req. | |
ApprovalSign | 7 | ApprovalSign | Req. | |
BillingApprovalDate | 8 | BillingApprovalDate | Req. | |
ProductGroupCreditSign | 9 | ProductGroupCreditSign | Req. | |
ReasonCode | 10 | ReasonCode | Req. | |
ProductGroupCreditInsertDate | 11 | ProductGroupCreditInsertDate | Req. | |
ProductGroup | 12 | ProductGroup | Req. | |
ProductGroupPeriod | 13 | ProductGroupPeriod | Req. |
Example on the records appearance.
H1;CreditInvoiceNo;CreditAmount;CustomerNo;DebitInvoiceNo;CapitalAmount;ApprovalSign;BillingApprovalDate;ProductGroupCreditSign;ReasonCode;
ProductGroupCreditInsertDate;ProductGroup;ProductGroupPeriod
D2 - Description credit invoice record
Field name | Field no. | Format | Type | Description |
Record type | 1 | D2 | Req. | Record type |
CreditInvoiceNo | 2 | N(15) | Req. | Invoice number for the created credit invoice |
CreditAmount | 3 | N(7),N(2-6) | Req. | CreditAmount |
CustomerNo | 4 | X(1-15) | Req. | CustomerNo |
DebitInvoiceNo | 5 | N(15) | Req. | DebitInvoiceNo on which the credit invoice is based on |
CapitalAmount | 6 | N(7),N(2-6) | Req. | Amount |
ApprovalSign | 7 | X(50) | Req. | Signature of person who approved the credit invoice* |
BillingApprovalDate | 8 | N(10) | Req. | YYYY-MM-DD |
ProductGroupCreditSign | 9 | X(50) | Req. | Signature(s) of person who initiated the product |
ReasonCode | 10 | X(10) | Req. | ReasonCode** |
ProductGroupCreditInsertDate | 11 | Datetime | Req. | YYYY-MM-DD hh:mm:ss |
ProductGroup | 12 | X(250) | Req. | Summarized products per product group |
ProductGroupPeriod | 13 | N(6) | Req. | Period/Month for the product group (YYYYMM) |
Examples on the records appearance.
D2;900100;-499.000;1000025004;4010258225;499.000;2817772;2024-02-14;AutoGenerator;11;2024-02-14 08:48:44;Abonnemang - Mobilt bredband;202404
D2;900200;-229.000;10001701006;4010258228;129.000;2817772;2024-02-14;AutoGenerator;11;2024-02-14 08:43:53;Abonnemang - Mobil;202404
D2;900200;50.000;10001701006;4010258228;129.000;2817772;2024-02-14;AutoGenerator;11;2024-02-14 08:43:53;Abonnemang - Mobil;202404
D2;900200;50.000;10001701006;4010258228;129.000;2817772;2024-02-14;AutoGenerator;11;2024-02-14 08:43:53;Abonnemang - Mobil;202404
*for automated approval a batchId (N7) will be presented
** Reason codes are configurated on company level and a list with codes are described in the company’s parameter document
S - Trailer record
Field name | Field no | Format | Type | Description |
Record type | 1 | S | Req. | Record type |
Example on the records appearance.
S