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