Wiki source code of Unbilled Report (BRPT001,BRPT002)
Last modified by Anders Göthberg on 2024/03/27 13:59
1 | = Name convention = |
2 | |
3 | When the report is ordered two files will be generated. |
4 | |
5 | **BRPT001_<CompanyNumber>_<DateTime>_0[Unbilled_<Term>_<BatchId>].DAT |
6 | BRPT002_<CompanyNumber>_<DateTime>_0[Unbilled_<Term>_<BatchId>].DAT** |
7 | |
8 | |
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 |
13 | |(% style="width:371px" %)Term|(% style="width:1121px" %)((( |
14 | From witch argument the report is created by, Possible values: |
15 | |
16 | NRP = Non recurrent products, products from PR01-file |
17 | |
18 | *U = Usage, traffic or events from CDR:s |
19 | |
20 | *UoNRP = Usage and non recurrent products aggregated |
21 | |
22 | //*Is not used without agreement// |
23 | ))) |
24 | |(% style="width:371px" %)BatchId|(% style="width:1121px" %)The identification number from the creation of the InvoiceJournal creation process ID |
25 | |
26 | Examples of report files: |
27 | |
28 | **BRPT001_9999_20190308093539_0[Unbilled_NRP_1234567].DAT |
29 | BRPT002_9999_20190308093539_0[Unbilled_NRP_1234567].DAT** |
30 | |
31 | The file is semicolon-separated. |
32 | |
33 | (% id="HWhattoavoid" %) |
34 | == Change log == |
35 | |
36 | (% border="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" %)((( |
39 | (% lang="EN-US" style="font-family:~"Garamond~",serif; font-size:12pt" %)First version. |
40 | )))|(% style="width:328px" %)Tomas Kristoffersson |
41 | |
42 | = |
43 | General information and explanation of records = |
44 | |
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. |
46 | |
47 | The BRPT001 report is semicolon separated for updating database or import to excel. |
48 | |
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. |
50 | |
51 | Both reports present the total amount for not invoiced products and other fees on each customer number. |
52 | |
53 | == == |
54 | |
55 | (% id="HFormatdescription" %) |
56 | == Format description == |
57 | |
58 | === BRPT001 === |
59 | |
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 | |
68 | = Record Description = |
69 | |
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 | |
109 | == == |
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 | |
134 | == BRPT001 (Customer, subscriber and product group code level) == |
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 | |
144 | = Examples BRPT002 = |
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 | |
153 | (% class="wikigeneratedid" id="H6.2ExampleHeader" %) |
154 | **Example Header** |
155 | |
156 | [[image:Main.Invoicing.billing.technical-reference.Billing Reports.QueuepostReport.Record description.WebHome@BRPT001_InformationAndRecordDescription (1)_html_76ac4e82.png||height="183" width="576"]] |
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 |