Name convention
BRPT024_<CompanyNumber>_<DateTime>_0[<Info>_NRP_<BatchId>].DAT
Name | Description |
CompanyNumber | The company number in PayEx ledger system |
DateTime | Date created in format YYYYMMDDHHMMSS |
Info | ”Billed” or “Unbilled” |
BatchId | Billing processId |
Two examples of report files:
BRPT024_99999_20190111123000_0[Unbilled_NRP_123456].DAT
BRPT024_99999_20190111123000_0[Billed_NRP_123456].DAT
Change log
Version | Date | Description | Created by |
---|
1.0 | 2019-09-30 | | Tomas Kristoffersson |
The BRPT024-report contains information about non-recurring products send in by a Product file. The report is based on either billed or unbilled products and can be ordered for a specified billrun (BatchId) or a specified billmonth.
The report contains two different records:
- D1 product information which includes subscriber number and products on subscriber level,
- D2 product information on customer level.
Record description
Field name | Field no. | Format | Type | Description |
Record type | 1 | H | Req. | Header record. |
Company Number | 2 | N(5) | Req. | The company number you receive from PayEx. |
Company Name | 3 | X(40) | Req. | Your company name |
Billing cycle | 4 | X(10) | | YYYY-MM-DD – Billing cycle |
BatchID | 5 | N(10) | | BatchID |
Creation date | 6 | N(6) | Req. | YYMMDD – Date when generated |
Creation time | 7 | N(4) | Req. | HHM – Time when generated |
I1 - Headline record
Field name | Field no. | Format | Type | Description |
Record type | 1 | I1 | Req. | Information record |
CustomerId | 2 | CustomerId | Req. | Customer number |
SubscriberId | 3 | SubscriberId | Req. | The customer subscription number |
Description | 4 | Description | Req. | Text from productfile |
Quantity | 5 | Quantity | Req. | The number of products of the product. |
Amount | 6 | Amount | Req. | The total amount for the product |
VAT rate | 7 | VAT rate | Req. | VAT rate |
ProductGroupId | 8 | ProductGroupId | Req. | Produc tGroup Id |
StartPeriod | 9 | StartPeriod | Req. | Start Period |
EndPeriod | 10 | EndPeriod | Req. | End Period |
CompanyId | 11 | CompanyId | Req. | CompanyId 1 – 99999 if sent in productfile |
ProductId | 12 | ProduktId | Req. | (unique) product id if sent in productfile |
D1 - Data Record
Field name | Field no. | Format | Type | Description |
Record type | 1 | D1 | Req. | Data record |
CustomerId | 2 | X(15) | Req. | Customer number |
SubscriberId | 3 | X(34) | Req. | The customer subscription number |
Description | 4 | X(74) | Req. | Text from productfile |
Quantity | 5 | N(5) | Req. | The number of products of the product. |
Amount | 6 | N(7).N(2-3) | Req. | The total amount for the product |
VAT rate | 7 | N(2),N(2) | Req. | VAT rate |
ProductGroupId | 8 | N(5) | | Product Group Id |
StartPeriod | 9 | YYYY-MM-DD | | Start Period |
EndPeriod | 10 | YYYY-MM-DD | | End Period |
CompanyId | 11 | N(5) | | A description of the Id-number |
ProductId | 12 | N(10) | | (unique) product id if sent in productfile |
I2 - Headline record
Field name | Field no. | Format | Type | Description |
Record type | 1 | I2 | Req. | Information record |
CustomerId | 2 | CustomerId | Req. | Customer number |
Description | 3 | Description | Req. | Text from productfile |
Quantity | 4 | Quantity | Req. | The number of products of the product |
Amount | 5 | Amount | Req. | The total amount for the product |
VAT rate | 6 | VAT rate | Req. | VAT rate |
ProductGroupId | 7 | ProductGroupId | Req. | Product Group Id |
StartPeriod | 8 | StartPeriod | Req. | Start Period |
EndPeriod | 9 | EndPeriod | Req. | End Period |
CompanyId | 10 | CompanyId | Req. | CompanyId 1 – 99999 if sent in productfile |
ProductId | 11 | ProduktId | Req. | (unique) product id if sent in productfile |
D2 - Data Record
Field name | Field no. | Format | Type | Description |
Record type | 1 | D2 | Req. | Data record |
CustomerId | 2 | X(15) | Req. | Customer number. |
Description | 3 | X(74) | Req. | Text from productfile |
Quantity | 4 | N(5) | Req. | The number of products of the product. |
Amount | 5 | N(7).N(2-3) | Req. | The total amount for the product. |
VAT rate | 6 | N(2),N(2) | Req. | VAT rate |
ProductGroupId | 7 | N(5) | | Product Group Id |
StartPeriod | 8 | YYYY-MM-DD | | Start Period |
EndPeriod | 9 | YYYY-MM-DD | | End Period |
CompanyId | 10 | N(5) | | A description of the Id-number . |
ProductId | 11 | N(10) | | (unique) product id if sent in productfile |
T - Trailer record
Field name | Field no. | Format | Type | Description |
Record type | 1 | T | Req. | Trailer record |
Number of records | 2 | N(8) | Req. | Total number of records inclusive header and trailer record. |
Example BRPT024
H;99999;Company name;;;191010;1538
I1;CustomerId;SubscriberId;Description;Quantity;Amount;VAT rate;ProductGroupId;StartPeriod;EndPeriod;CompanyId;ProductId
D1;123456;Bredband;Rabatt 180601-180630;1;-30.00;25.00;140;2019-09-01;2019-09-30;43;
I2;CustomerId;Description;Quantity;Amount;VAT rate;ProductGroupId;StartPeriod;EndPeriod;CompanyId;ProductId
D2;123456;Nummerpresentation;1;15.00;25.00;136;2019-09-01;2019-09-30;591;1012028281
T;6