Last modified by ang on 2024/03/27 13:59
Hide last authors
ang 9.1 1 = Name convention =
2
ang 11.1 3 When the report is ordered two files will be generated.
ang 9.1 4
ang 30.1 5 **BRPT001_<CompanyNumber>_<DateTime>_0[Unbilled_<Term>_<BatchId>].DAT
6 BRPT002_<CompanyNumber>_<DateTime>_0[Unbilled_<Term>_<BatchId>].DAT**
ang 9.1 7
ang 11.1 8
ang 9.1 9 (% border="1" %)
10 |=(% style="width: 371px;" %)Names Component|=(% style="width: 1121px;" %)Description
11 |(% style="width:371px" %)CompanyNumber|(% style="width:1121px" %)The company number in PayEx ledger system
12 |(% style="width:371px" %)DateTime|(% style="width:1121px" %)Date created in format YYYYMMDDHHMMSS
ang 15.1 13 |(% style="width:371px" %)Term|(% style="width:1121px" %)(((
ang 17.1 14 From witch argument the report is created by, Possible values:
ang 15.1 15
ang 17.1 16 NRP = Non recurrent products, products from PR01-file
17
ang 18.1 18 *U = Usage, traffic or events from CDR:s
ang 17.1 19
ang 18.1 20 *UoNRP = Usage and non recurrent products aggregated
ang 17.1 21
ang 19.1 22 //*Is not used without agreement//
ang 15.1 23 )))
ang 13.1 24 |(% style="width:371px" %)BatchId|(% style="width:1121px" %)The identification number from the creation of the InvoiceJournal creation process ID
ang 9.1 25
ang 30.1 26 Examples of report files:
ang 9.1 27
ang 30.1 28 **BRPT001_9999_20190308093539_0[Unbilled_NRP_1234567].DAT
29 BRPT002_9999_20190308093539_0[Unbilled_NRP_1234567].DAT**
ang 13.1 30
ang 9.1 31 The file is semicolon-separated.
32
33 (% id="HWhattoavoid" %)
34 == Change log ==
35
36 (% border="1" %)
ang 24.1 37 |=**Version**|=(% style="width: 167px;" %)**Date**|=(% style="width: 660px;" %)**Description**|=(% style="width: 328px;" %)**Created by**
38 |1.0|(% style="width:167px" %)2020-09-20|(% style="width:660px" %)(((
ang 11.1 39 (% lang="EN-US" style="font-family:~"Garamond~",serif; font-size:12pt" %)First version.
40 )))|(% style="width:328px" %)Tomas Kristoffersson
ang 9.1 41
42 =
43 General information and explanation of records =
44
ang 10.1 45 After billing PayEx Billing are finished the reports BRPT001 and BRPT002 are created, the reports contains companies unbilled products and fees that are sent for billing, but for some reason not been invoiced.
ang 9.1 46
ang 25.1 47 The BRPT001 report is semicolon separated for updating database or import to excel.
ang 9.1 48
ang 25.1 49 The 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.
ang 9.1 50
ang 20.1 51 Both reports present the total amount for not invoiced products and other fees on each customer number.
ang 9.1 52
ang 42.1 53 == ==
ang 28.1 54
ang 32.1 55 (% id="HFormatdescription" %)
56 == Format description ==
ang 28.1 57
ang 32.1 58 === BRPT001 ===
ang 28.1 59
ang 32.1 60 All fields in the mentioned reports are separated with semicolons ”;”. The format field is written in the way that numerical values are written as N and alphanumerical characters are written as X. where ”n” is the maximum number of characters/digits or in certain cases number of characters that must exist.
61
62 Dot “.” is decimal separator on fields with amount. Some records are not obligatory but if they exist can some fields in the record be obligatory. Obligatory records are described with the abbreviation ” Req.” in the type column.
63
64 === BRPT002 ===
65
66 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.
67
ang 42.1 68 = Record Description =
69
ang 28.1 70 == H - Header record ==
71
72 (% border="1" %)
73 |=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description**
74 |Recordtype|1|H|Req.|Header record.
75 |FirmNumber|2|N(4)|Req.|The firm number you receive from PayEx.
76 |FirmName|3|X(40)|Req.|Your firm name
77 |Creationdate|4|N(6)|Req.|YYYY-MM-DD – Date when generated
78 |Creationtime|5|N(4)|Req.|HH:MM:SS – Time when generated
79
80 == I - Headline record ==
81
82 (% border="1" %)
83 |=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description**
84 |Record type|1|I|Req.|Record type
85 |Customer No|2|X(1-15)|Req.|Customer number
86 |Customer Name|3|X(1-72)|Req.|Customer name
87 |Subscribernumber|4|X(1-15)| |Subscriber number
88 |Productgroup|5|N(5)| |Productgroup
89 |Sum|6|N(7),N(2-6)|Req.|Total amount
90
91 == D - Data Record ==
92
93 (% border="1" %)
94 |=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description**
95 |Record type|1|D|Req.|Record type
96 |Customer No|2|X(1-15)|Req.|Customer number
97 |Customer Name|3|X(1-72)|Req.|Customer name
98 |Subscribernumber|4|X(1-15)| |Subscriber number
99 |Productgroup|5|N(5)| |Productgroup
100 |Sum|6|N(7),N(2-6)|Req.|Total amount
101
102 == T - Trailer record ==
103
104 (% border="1" %)
105 |=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description**
106 |Record type|1|T|Req.|Trailer record
107 |Number of records|2|N|Req.|Total number of records inclusive header and trailer record.
108
ang 42.1 109 == ==
ang 28.1 110
111 = Examples BRPT001 =
112
113 == BRPT001 (Customer level only) ==
114
115 H;9999;Firm Name;2019-04-04;09:35:34
116 I;Customer;Name;Amount
117 D;100001;Customer name;2346.23
118 D;100002;Customer name;2829.10
119 D;100003;Customer name;3226.65
120 D;100004;Customer name;3249.89
121 T;6
122
123
124 == BRPT001 (Customer and product group code level) ==
125
126 H;9999;Firm Name;2019-04-04;09:35:34
127 I;Customer;Name;Group;Amount
128 D;100001;Customer name1;ProductGroupCode1;2346.23
129 D;100001;Customer name1;ProductGroupCode2;2829.10
130 D;100002;Customer name2;ProductGroupCode1;3226.65
131 D;100002;Customer name2;ProductGroupCode2;3249.89
132 T;6
133
ang 39.1 134 == BRPT001 (Customer, subscriber and product group code level) ==
ang 28.1 135
136 H;9999;Firm Name;2019-04-04;09:35:34
137 I;Customer;Name;Subscriber;Group;Amount
138 D;100001;Customer name1;Subscriber1;ProductGroupCode1;2346.23
139 D;100001;Customer name1;Subscriber1;ProductGroupCode2;2829.10
140 D;100001;Customer name1;Subscriber2;ProductGroupCode1;3226.65
141 D;100001;Customer name1;Subscriber2;ProductGroupCode2;3249.89
142 T;6
143
ang 34.1 144 = Examples BRPT002 =
ang 28.1 145
146 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.
147
148
149 == Header record information ==
150
151 Contains information about batch ID, the terms the report has been processed with, date and time, period of usage and billingcycle.
152
ang 29.1 153 (% class="wikigeneratedid" id="H6.2ExampleHeader" %)
ang 28.1 154 **Example Header**
155
ang 38.1 156 [[image:Main.Invoicing.billing.technical-reference.Billing Reports.QueuepostReport.Record description.WebHome@BRPT001_InformationAndRecordDescription (1)_html_76ac4e82.png||height="183" width="576"]]
ang 28.1 157
158 == Sections ==
159
160 1 First section contains customer that is missing in database with the comment DIDN´T EXIST IN DATABASE.
161 2 Customer with amount 0, when “Add customer with no unbilled products or traffic” is chosen.
162 3 Customers unbilled amount between 0 > to 50.
163 4 Customers unbilled amount between 50 > till 100.
164 5 Customers unbilled amount between 100 > till 150.
165 6 Customers unbilled amount between 150 > till 200.
166 7 Customers with unbilled amount < 200
167
168 The sort order in each section is on total amount, the section is summed at the end.
169
170
171 Example:
172
173 **Interval >150 - 200**
174 **100001 Customer name 152.11 2019-01-29 - 2019-03-26 0**
175 **100002 Customer name 166.28 2019-02-26 - 2019-03-26 0**
176 **100003 Customer name 173.65 2018-12-28 - 2019-03-26 0**
177 **100004 Customer name 177.72 2019-01-29 - 2019-03-26 0**
178 **100005 Customer name 191.33 2018-03-03 - 2019-03-21 0**
179 **Number of customers 5 Amount 861.09**
180
181