Name convention
BRPT054_<CompanyNumber>_<DateTime>_0[TotalCustomernumberList]DAT
| Names Component | Description |
|---|---|
| CompanyNumber | The company number in PayEx ledger system |
| DateTime | Date created in format YYYYMMDDHHMMSS |
| TotalCustomernumberList | File description. |
For example: BRPT054_9999_20190308093539_0[TotalCustomernumberList].DAT
Change log
| Version | Date | Description | Created by |
|---|---|---|---|
| 1.0 | 2020-01-30 | Created document | Jacob de Boer |
General information and explanation of records
BRPT054, TotalCustomerNumberList
This report presents all customer numbers stored in the PayEx Billing system at a certain time. Each customer will be presented with an insert date and if available an update date.
File format
This report is separated by semi column. Sort order is customer number.
Record description
H - Header record
| Field name | Field no. | Format | Type | Description |
| Recordtype | 1 | H | Req. | Header record. |
| CompanyNumber | 2 | N(4) | Req. | The company number you receive from PayEx. |
| CompanyName | 3 | X(40) | Req. | Your company name |
| Creationdate | 4 | N(6) | Req. | YYYY-MM-DD – Date when generated |
| Creationtime | 5 | N(4) | Req. | HH:MM:SS – Time when generated |
I - Headline record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | I | Req. | Record type |
| CustomerNumber | 2 | CustomerNumber | Req. | Customer number |
| InsertDate | 3 | InsertDate | Req. | Insert date |
| UpdateDate | 4 | UpdateDate | Req. | Update date |
D - Data Record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | D | Req. | Record type |
| Customer number | 2 | X(1-15) | Req. | Customer number |
| Insert date | 3 | N(6) | Req. | YYYY-MM-DD – Date when customer is inserted |
| Update date | 4 | N(6) | YYYY-MM-DD – Date when customer is updated |
T - Trailer record
| Field name | Field no. | Format | Type | Description |
| Record type | 1 | T | Req. | Trailer record |
| Number of records | 2 | N | Req. | Total number of records inclusive header and trailer record. |
Example BRPT054
H;99999;Test Company;2020-01-30;09:46:45
I;CustomerNumber;InsertDate;UpdateDate
D;100001;2019-03-18;2019-04-25
D; 100002;2019-03-18;2019-03-29
D; 100003;2019-03-18;2019-03-19
D; 100004;2019-03-18;
T;7