Record description

Records

H - Header record

Field nameField no.FormatTypeDescription
Recordtype1HReq.Header record.
FirmNumber2N(4)Req.The firm number you receive from PayEx.
FirmName3X(40)Req.Your firm name
Creationdate4N(6)Req.YYYY-MM-DD – Date when generated
Creationtime5N(4)Req.HH:MM:SS – Time when generated

I - Headline record

Field nameField no.FormatTypeDescription
Record type1IReq.Record type
Customer No2X(1-15)Req.Customer number
Customer Name3X(1-72)Req.Customer name
Subscribernumber4X(1-15) Subscriber number
Productgroup5N(5) Productgroup
Sum6N(7),N(2-6)Req.Total amount

D - Data Record

Field nameField no.FormatTypeDescription
Record type1DReq.Record type
Customer No2X(1-15)Req.Customer number
Customer Name3X(1-72)Req.Customer name
Subscribernumber4X(1-15) Subscriber number
Productgroup5N(5) Productgroup
Sum6N(7),N(2-6)Req.Total amount

T - Trailer record

Field nameField no.FormatTypeDescription
Record type1TReq.Trailer record
Number of records2NReq.Total number of records inclusive header and trailer record.

Examples BRPT001

BRPT001 (Customer level only)

H;9999;Firm Name;2019-04-04;09:35:34
I;Customer;Name;Amount
D;100001;Customer name;2346.23
D;100002;Customer name;2829.10
D;100003;Customer name;3226.65
D;100004;Customer name;3249.89
T;6

BRPT001 (Customer and product group code level)

H;9999;Firm Name;2019-04-04;09:35:34
I;Customer;Name;Group;Amount
D;100001;Customer name1;ProductGroupCode1;2346.23
D;100001;Customer name1;ProductGroupCode2;2829.10
D;100002;Customer name2;ProductGroupCode1;3226.65
D;100002;Customer name2;ProductGroupCode2;3249.89
T;6

Example BRPT001 (Customer and subscriber level)

H;9999;Firm Name;2019-04-04;09:35:34
I;Customer;Name;Subscriber;Amount
D;100001;Customer name1;Subscriber1;2346.23
D;100001;Customer name1;Subscriber2;2829.10
D;100002;Customer name2;Subscriber1;3226.65
D;100002;Customer name2;Subscriber2;3249.89
T;6

BRPT001 (Customer, subscriber and product group code level)

H;9999;Firm Name;2019-04-04;09:35:34
I;Customer;Name;Subscriber;Group;Amount
D;100001;Customer name1;Subscriber1;ProductGroupCode1;2346.23
D;100001;Customer name1;Subscriber1;ProductGroupCode2;2829.10
D;100001;Customer name1;Subscriber2;ProductGroupCode1;3226.65
D;100001;Customer name1;Subscriber2;ProductGroupCode2;3249.89
T;6

Format description BRPT002

BRPT002 report is in text -format, easy to read and printable, the report are divided in sections based on the size of amount for each customer.

Header record information

Contains information about batch ID, the terms the report has been processed with, date and time, period of usage and billingcycle.

Example Header

BRPT001_InformationAndRecordDescription (1)_html_76ac4e82.png

Sections

1 First section contains customer that is missing in database with the comment DIDN´T EXIST IN DATABASE.
2 Customer with amount 0, when “Add customer with no unbilled products or traffic” is chosen.
3 Customers unbilled amount between 0 > to 50.
4 Customers unbilled amount between 50 > till 100.
5 Customers unbilled amount between 100 > till 150.
6 Customers unbilled amount between 150 > till 200.
7 Customers with unbilled amount < 200

The sort order in each section is on total amount, the section is summed at the end.

Example:

Interval >150 - 200
100001 Customer name 152.11 2019-01-29 - 2019-03-26 0
100002 Customer name 166.28 2019-02-26 - 2019-03-26 0
100003 Customer name 173.65 2018-12-28 - 2019-03-26 0
100004 Customer name 177.72 2019-01-29 - 2019-03-26 0
100005 Customer name 191.33 2018-03-03 - 2019-03-21 0
Number of customers 5 Amount 861.09

 

Created by David Persson on 2021/01/29 09:26