Name convention
BRPT045_<CompanyNr>_<DateTime>_0[DeletedProducts_<BatchId>].DAT
Name | Description |
CompanyNr | The company number in PayEx ledger system |
DateTime | Date created in format YYYYMMDDHHMMSS |
DeletedProducts | Report type |
BatchId | Billing processId |
Examples of report files.
BRPT045_9999_20190109145554_0[DeletedProducts__631233].DAT
Change log
Version | Date | Description | Created by |
---|---|---|---|
1.0 | 2019-01-09 | Created document | Jacob de Boer |
General information and explanation of records
Removal of uncharged non recurring products (ETC) can be done by using an RETC01 file.
The BRPT045 report describes which ETC products what has been deleted with the RETC01 file.
Format description
The file is semicolon separated and starts with a header record and ends with a trailer record.
The format field is written so that numerical values are written as N and alphanumerical values are written as X. ”n” represents the maximum number of numbers/characters or in some instances the required number pf numbers/characters. Decimal separator is represented by a dot ”.”. Some of the s are not required, but are they present other field will also be required. Required field as marked with a ”Req.” in the Type column Header record ”H and Trailer record ”T” must be present in the file.
Record description
H - Header record
Field name | Field no. | Format | Type | Description |
Record type | 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 |
Created date | 4 | N(6) | Req. | YYYY-MM-DD – Same date as in filename |
Created time | 5 | N(4) | Req. | HH:MM:SS – Time when the file was created |
I1 - Delete Information record summarized
Field name | Field no. | Format | Type | Description |
Record type | 1 | I1 | Req. | Information regarding delete criteria |
CustomerNo | 2 | X(15) | Req. | Customer Number |
SubscriberNo | 3 | X(34) | Req. | Subscriber Number |
ProductGroup | 4 | N(5) | Req. | Product group from Billing System |
Quantity | 5 | N(5) | Req. | Number of removed products |
TotalAmount | 6 | N(7).N(2) | Req. | Total amount |
D1 - Delete record summarized
Field name | Field no. | Format | Type | Description |
Record type | 1 | D1 | Req. | Information regarding delete criteria |
CustomerNo | 2 | X(15) | Req. | Customer Number |
SubscriberNo | 3 | X(34) | Subscriber Number | |
ProductGroup | 4 | N(5) | Product group from Billing System | |
Quantity | 5 | N(5) | Req. | Number of removed products |
TotalAmount | 6 | N(7).N(2) | Req. | Total amount |
I2 - Delete Information record detailed
Field name | Field no. | Format | Type | Description |
Record type | 1 | I2 | Req. | Information regarding delete criteria |
CustomerNo | 2 | X(15) | Req. | Customer Number |
SubscriberNo | 3 | X(34) | Req. | Subscriber Number |
ProductGroup | 4 | N(5) | Req. | Product group |
Description | 5 | X | Req. | Description |
Quantity | 6 | N(5) | Req. | Number of removed products |
Amount | 7 | N(7).N(2) | Req. | Amount |
D2 - Delete record detailed
Field name | Field no. | Format | Type | Description |
Record type | 1 | D2 | Req. | Information regarding delete criteria |
CustomerNo | 2 | X(15) | Req. | Customer Number |
SubscriberNo | 3 | X(34) | Subscriber Number | |
ProductGroup | 4 | N(5) | Product group | |
Description | 5 | X | Req. | Description |
Quantity | 6 | N(5) | Req. | Number of removed products |
Amount | 7 | N(7).N(2) | Req. | Amount |
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
H;9999;TestCompany;2019-01-09;14:56:55
I1;CustomerNo;SubscriberNo;ProductGroup;Quantity;TotalAmount
D1;K10;;161;1;39.00
I2;CustomerNo;SubscriberNo;ProductGroup;Description;Quantity;Amount
D2;K11;0498202000;161;Bredband 181001-181130;1;139.00
T;6