Wiki source code of Receipt Split (BRCP050)

Last modified by Anders Göthberg on 2024/01/04 15:41
Show last authors
1 = Name convention =
2
3 BRCP050_<CompanyNumber>_<DateTime>_<SEQNO>[ReceiptInvoiceOrder_<BatchId>].DAT
4
5
6 (% border="1" %)
7 |=(% style="width: 371px;" %)Names Component|=(% style="width: 1121px;" %)Description
8 |(% style="width:371px" %)CompanyNumber|(% style="width:1121px" %)The company number in PayEx ledger system
9 |(% style="width:371px" %)DateTime|(% style="width:1121px" %)Date created in format YYYYMMDDHHMMSS
10 |(% style="width:371px" %)SEQNO|(% style="width:1121px" %)Always = 0 in this report
11 |(% style="width:371px" %)ReceiptInvoiceOrder|(% style="width:1121px" %)File description
12 |(% style="width:371px" %)BatchId|(% style="width:1121px" %)The identification number from the creation of the FB01 creation process ID
13
14 **For example: BRCP050_99999_20191128093539_0[ReceiptInvoiceOrder_1234567].DAT**
15
16 The file is semicolon-separated.
17
18 == ==
19
20 == Change log ==
21
22 (% border="1" %)
23 |=**Version**|=(% style="width: 166px;" %)**Date**|=(% style="width: 879px;" %)**Description**|=(% style="width: 328px;" %)**Created by**
24 |1.0|(% style="width:166px" %)2020-11-03|(% style="width:879px" %)(((
25 (% style="margin:0cm 0cm 8pt" %)
26 (% style="font-family:Calibri,sans-serif; font-size:11pt; line-height:107%" %)Document created
27 )))|(% style="width:328px" %)Jacob de Boer
28 |2.0|(% style="width:166px" %)2023-09-01|(% style="width:879px" %)New record description due to new internal invoice order split process. Removing internal PFB file which is replaced by a more dynamic database storage model. |(% style="width:328px" %)Jakob Flodman
29
30 =
31 General information and explanation of records =
32
33 The BRCP050-file is used to report about the FB-file split process.
34
35 This file split process is used to split FB-files into split parts stored in database to be used as a base in the billing invoice process.
36
37 The split process will divide the original FB file into smaller parts depending on the number of customer numbers. The number of customer numbers has been agreed with PayEx.
38
39
40 Each split part receives an unique sequence number for identification together with the split run unique processid
41
42 For example:
43 FB file name: **FB01_99999_230609105400_1.DAT**
44
45 **Results in: **
46 Part 1 :**FB01_99999_230609105400_1.DAT**:3456789
47 Part 2 :**FB01_99999_230609105400_1.DAT**:3456789
48 Part 3 :**FB01_99999_230609105400_1.DAT**:3456789
49 Part 4 :**FB01_99999_230609105400_1.DAT**:3456789
50
51
52 The BRCP050-file is showing an overview about the split of the FB-file into parts, for example:
53
54 [[image:1686806955232-200.png||height="205" width="538"]]
55
56
57 = Record description =
58
59 == H - Header record ==
60
61 Required record
62
63 (% border="1" %)
64 |**Field name**|**Field no.**|**Format**|**Type**|**Description**
65 |Record type|1|H|Req.|Header record
66 |Firm number|2|N(5)|Req.|You receive the firm number from PayEx.
67 |Firm name|3|X(40)|Req.|Your firm name.
68 |Runtime process id|4|N(10)| |Internal process identification number
69 |Created date|5|N(6)|Req.|YYMMDD – Same date as in the file name.
70 |Created time|6|N(4)|Req.|HHMM – Time when the file was created.
71
72 Example on the records appearance.
73
74 H;99999;Firmname;00123;191201;1300
75
76
77 (% id="HI-Informationrecord" %)
78 == I - Information record ==
79
80 Required record
81
82 (% border="1" %)
83 |**Field name**|**Field no.**|**Format**|**Type**|**Description**
84 |Record type|1|I|Req.|Information record type
85 |Code|2|N(15)|Req.|Information code
86 |Description|3|X(1000)|Req.|Description of information code
87 |Value|4|X(300)|Req.|(((
88 Value
89 )))
90
91 (% class="wikigeneratedid" id="H" %)
92 Example on the records appearance.
93
94 (% class="wikigeneratedid" %)
95 I;15291;Name of processed file;FB01_99999_20191128093539_113.DAT
96 I;15328;Total number of orderrows processed;170000
97 I;15329;Total number of orderrows approved;169999
98
99 (% id="HI-Informationrecord" %)
100 == W - Warning record ==
101
102 Required record
103
104 (% border="1" %)
105 |**Field name**|**Field no.**|**Format**|**Type**|**Description**
106 |Record type|1|W|Req.|Warning record type
107 |Code|2|N(15)|Req.|Warning code
108 |Description|3|X(1000)|Req.|Description of warning code
109 |Value|4|X(300)|Req.|(((
110 Value
111 )))
112
113 (% class="wikigeneratedid" id="H" %)
114 Example on the records appearance.
115
116 (% class="wikigeneratedid" %)
117 W;15331;Number of rejected orderrows to responsefile;1
118
119 == F - File Split record ==
120
121 Required record
122
123 (% border="1" %)
124 |**Field name**|**Field no.**|**Format**|**Type**|**Description**
125 |Record type|1|F|Req.|Record type
126 |Code|2|N(15)|Req.|Information code
127 |Original file name|3|X(120)|Req.|The name of the original FB file
128 |Split part description|4|X(120)|Req.|Split part sequence descriptiontext
129 |Number of Customers|5|N(7)|Req.|Number of customers for each part
130 |Split part sequence number|6|N(2)|Req.|Split part sequence number
131
132 Example on the records appearance.
133
134 F;15330;Number of orderrows for part[1];100000;1
135 F;15330;Number of orderrows for part[2];70000;2
136
137
138 == S - Trailer record ==
139
140 Required record
141
142 (% border="1" %)
143 |**Field name**|**Field no**|**Format**|**Type**|**Description**
144 |Record type|1|S|Req.|Trailer record
145 |Total number of records|2|N(8)|Req.|Number of records, header record and trailer record included.
146
147 Example on the records appearance.
148
149 S;4
150
151
152
153