Name convention
BRPT028_<CompanyNumber>_<DateTime>_0[<Info>_<BatchId>].DAT
| Name | Description |
| CompanyNumber | The company number in PayEx ledger system |
| DateTime | Date created in format YYYYMMDDHHMMSS |
| Info | Billed_RP |
| BatchId | Billing processId |
Examples of report file:
BRPT028_99999_20190111123000_0[Billed_RP_195628].DAT
Change log
| Version | Date | Description | Created by |
|---|---|---|---|
| 1.0 | 2019-09-30 | Created document | Tomas Kristoffersson |
General information and explanation of records
The BRPT028-report contains information about recurring products send in on customer level or subscription level in Customer file or API. The report is based on billed products and can be ordered for a specified billrun (BatchId) or a specified billmonth.
Record description
H - Header record
| Field name | Field no. | Format | Type | Description |
| Recordtype | 1 | H | Req. | Record type. |
| CompanyNumber | 2 | X(15) | Req. | You receive the company number from PayEx. |
| Company Name | 3 | X(40) | Req. | Your company name |
| Created date | 4 | X(6) | Req. | YYMMDD – Same date as in the file name. |
| Created time | 5 | X(4) | Req. | HHMM |
Example:
H;1234;CompanyName;200411;1633
I - Description record
| Field name | Field no. | Format | Type | Description |
| Type of transaction | 1 | I | Req. | Description record |
| CustomerId | 2 | CustomerId | Req. | CustomerId |
| SubscriberId | 3 | SubscriberId | Req. | SubscriberId |
| ProductCode | 4 | ProductCode | Req. | ProductCode |
| End date | 5 | End date | Req. | End date |
| Billed until | 6 | Billed until | Req. | Billed until |
| Billmonth | 7 | Billmonth | Req. | Billmonth |
Example:
I;CustomerId;SubscriberId;Productcode;End date;Billed until;Billmonth
D - Transaction record
| Field name | Field no. | Format | Type | Description |
| Type of transaction | 1 | D | Req. | Transaction record recurring products. |
| CustomerId | 2 | X(16) | Req. | Customer number. |
| SubscriberId | 3 | X(34) | The customer subsription number (a-number). | |
| ProductCode | 4 | X(5) | Req. | The productCode |
| End date | 5 | YYYY-MM-DD | End date for product. | |
| Billed until | 6 | YYYY-MM-DD | Req. | Product billed until. |
| Billmonth | 7 | YYYY-MM | Obl. | Last billmonth for the product. |
Example:
D;10000;;P01;;2007-10-31;2007-10
T - Trailer record
| Field name | Field no. | Format | Type | Description |
| Recordtype | 1 | T | Obl. | Trailer record |
| Number of records | 2 | N(8) | Obl. | Total number of records including header and trailer |
Example:
T;10
Example of Billed Recurring Products
H;9999;Company2;210511;1200
I;CustomerId;SubscriberId;ProductCode;End date;Billed until;Billmonth
D;10063;;InvoiceFee1;;2021-06-30;2021-06
D;10092;;InvoiceFee1;;2021-06-30;2021-06
D;10120;;InvoiceFee1;;2021-06-30;2021-06
D;10217;;InvoiceFee1;;2021-06-30;2021-06