Changes for page PR01 Response files .CSV
Last modified by Anders Göthberg on 2023/06/08 14:31
From empty
To version 32.1
edited by Anders Göthberg
on 2021/04/15 14:58
on 2021/04/15 14:58
Change comment: There is no comment for this version
Summary
-
Page properties (6 modified, 0 added, 0 removed)
-
Attachments (0 modified, 4 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,0 +1,1 @@ 1 +Record description - Parent
-
... ... @@ -1,0 +1,1 @@ 1 +developer:Main.Invoicing.billing.technical-reference.Product File.3 PR01.WebHome - Author
-
... ... @@ -1,1 +1,1 @@ 1 - XWiki.XWikiGuest1 +xwiki:XWiki.ang - Default language
-
... ... @@ -1,0 +1,1 @@ 1 +en - Tags
-
... ... @@ -1,0 +1,1 @@ 1 +px-custom-page-content - Content
-
... ... @@ -1,0 +1,306 @@ 1 += Records = 2 + 3 +== H - Header == 4 + 5 +(% border="1" %) 6 +|=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description** 7 +|Transaction type|1|H|Req|Header record 8 +|Firm number|2|N(5)|Req|The firm number you receive from PayEx 9 +|Firm name|3|X(40)|Req|Your firm name 10 +|Created date|4|N(6)|Req|YYMMDD – the same date as in the filename. 11 +|Created time|5|N(4)|Req|HHMM – the time of creation. 12 + 13 +Example on the records appearance. 14 + 15 +**H;1234;Firm;180919;1220** 16 + 17 +== M - Metadata record == 18 + 19 +(% border="1" %) 20 +|=**Field name**|=**Filed no.**|=**Format**|=**Type**|=**Description** 21 +|Transaction type|1|M|Req|Metadata record 22 +|Type of billing|2|N(2)|Req|0 = ordinary invoicing (default). 1 – n = test invoicing. Support for test invoicing and the different codes to be used are set up in cooperation with PayEx. 23 +|//Reserved//|//3//| | |//Reserved for future use// 24 + 25 +Example on the records appearance 26 + 27 +**M;0;** 28 + 29 +== P - Product record == 30 + 31 +(% border="1" %) 32 +|=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description** 33 +|Transaction type|1|P| |Product record. 34 +|Customer number|2|X(15)|Req|Customer number 35 +|Product text|3|X(73)|Req|Product text, see Definitions and terms 36 +|Quantity|4|N(5)|Req|Number of products 37 +|Unit|5|N(7),N(2-6)|Req|Price for one product, can have 2 to 6 decimals. 38 +|VAT rate|6|N(7),N(2)|Req|VAT rate 39 +|Product_group_Id|7|N(5)|Req|According to agreement with PayEx. 40 +|Identification_No|8|N(10)| |Id used to group statistics. Required when service Revenue Accounting is active, maximum value 2^^31^^ 41 +|Product_Id|9|N(10)| |Id for the product, maximum value 2^^31^^ 42 + 43 +Example on the records appearance. 44 + 45 +**P;12345;Football1;5;23,50;25,00;2;;** 46 + 47 +**P;12345;Football2;5;23,50;25,00;2;1;12365487** 48 + 49 +== K - Customer number Information record == 50 + 51 +**~*~***Is not used without agreement 52 + 53 +(% border="1" %) 54 +|=**Field name**|=**Field no.**|=**Format**|=**Type**|=**Description** 55 +|Transaction type|1|K| |Product record. 56 +|Customer number|2|X(15)|Req|Customer number 57 +|Product text|3|X|Req|Product text, see Definitions and terms 58 +|Product_group_Id|4|N(5)|Req|According to agreement with PayEx.* 59 +|Group_No|5|N(3)| |Is empty if nothing else is agreed. 60 + 61 +Example on the records appearance: 62 + 63 +**K;000087;Installation: the Villa;9;** 64 + 65 +*Product_group_id is set according to agreement for CustnoInformation record. 66 + 67 +== I - A -number Information record == 68 + 69 +**~*~***Is not used without agreement 70 + 71 +(% border="1" %) 72 +|=**Field name**|=**Field no**|=**Format**|=**Type**|=**Description** 73 +|Transaction type|1|I| |Product record. 74 +|Customer number|2|X(15)|Req|Customer number 75 +|A-number|3|X(34)|Req|A-number 76 +|Product text|4|X|Req|Product text, see Definitions and terms 77 +|Product_group_Id|5|N(5)|Req|According to agreement with PayEx.* 78 +|Group_No|6|N(3)| |Is left blank if nothing else is agreed. 79 + 80 +Example on the records appearance: 81 + 82 +**I;000087;0702402377;Installation: The house;9;** 83 + 84 +~* Product_group_id is set according to agreement for A -no Information record. 85 + 86 +== A - A -number product record == 87 + 88 +(% border="1" %) 89 +|=**Field name**|=**Field no**|=**Format**|=**Type**|=**Description** 90 +|Transaction type|1|A| |Product record. 91 +|Customer number|2|X(15)|Req|Customer no. 92 +|A-number|3|X(34)|Req|A-Number 93 +|Product text|4|X|Req|Product text, see Definitions and terms 94 +|Quantity|5|N(5)|Req|Number of products 95 +|Unit|6|N(7),N(2-6)|Req|Price for one product, can have 2 to 6 decimals. 96 +|VAT rate|7|N(7),N(2)|Req|VAT rate 97 +|Product_group_Id|8|N(5)|Req|According to agreement with PayEx. 98 +|Identification_No|9|N(10)| |Id used to group statistics. Required when service Revenue Accounting is active, maximum value 2^^31^^ 99 +|Product_Id|10|N(10)| |Id for the product, maximum value 2^^31^^ 100 + 101 +Example on the records appearance: 102 + 103 +**A;12345;4788743;Installation fee1;5;150,00;25,00;1;2;** 104 + 105 +**A;12345;4788743;Installation fee3;5;150,00;25,00;1;2;123456** 106 + 107 +== Q - Date product record == 108 + 109 +**~*~***Is not used without agreement 110 + 111 +(% border="1" %) 112 +|=**Field name**|=**Field no**|=**Format**|=**Type**|=**Description** 113 +|Transaction type|1|Q| |Product record. 114 +|Customer number|2|X(15)|Req|Customer number 115 +|Product text|3|X|Req|Product text, see Definitions and terms 116 +|Quantity|4|N(5)|Req|Number of products 117 +|Unit|5|N(7),N(2-6)|Req|Price for one product, can have 2 to 6 decimals. 118 +|VAT rate|6|N(7),N(2)|Req|VAT rate 119 +|Product_group_Id|7|N(5)|Req|According to agreement with PayEx. 120 +|From-date|8|N(8)|Req|YYYYMMDD – Date from when the product is active 121 +|To-date|9|N(8)|Req|YYYYMMDD – Date from when the product no longer is active 122 +|Identification_No|10|N(10)| |Id used to group statistics. Required when service Revenue Accounting is active, maximum value 2^^31^^ 123 +|Product_Id|11|N(10)| |Id for the product, maximum value 2^^31^^ 124 +|Product property 1|12|N(1)| |Property for product (0-9) ex. for grouping on invoice layout 125 +|Product property 2|13|N(1)| |Property for product (0-9) 126 +|Product property 3|14|N(1)| |Property for product (0-9) 127 + 128 +Note! When service Revenue Accounting is active, the dates must be within revenue month. It is only allowed to use from- and to-date within a calendar month. Use of “Product property” field is set up in agreement with PayEx 129 + 130 +Example on the records appearance: 131 + 132 +**Q;12345;Football1;5;23,50;25,00;2;20180101;20181001;1;;;;** 133 + 134 +**Q;12345;Football2;5;23,50;25,00;2;20180101;20181001;1;1234567;1;2;8** 135 + 136 +== B - Date A -number product record == 137 + 138 +**~*~***Is not used without agreement 139 + 140 +(% border="1" %) 141 +|=**Field name**|=**Field no**|=**Format**|=**Type**|=**Description** 142 +|Transaction type|1|B| |Product record. 143 +|Customer number|2|X(15)|Req|Customer number 144 +|A-Number|3|X(34)|Req|A-Number 145 +|Product text|4|X|Req|Product text, see Definitions and terms 146 +|Quantity|5|N(5)|Req|Number of products 147 +|Unit|6|N(7),N(2-6)|Req|Price for one product, can have 2 to 6 decimals. 148 +|VAT rate|7|N(7),N(2)|Req|VAT rate 149 +|Product_group_Id|8|N(5)|Req|According to agreement with PayEx. 150 +|From-date|9|N(8)|Req|YYYYMMDD – Date from when the product is active 151 +|To-date|10|N(8)|Req|YYYYMMDD – Date from when the product no longer is active 152 +|Identification_No|11|N(10)| |Id used to group statistics. Required when service Revenue Accounting is active, maximum value 2^^31^^ 153 +|Product_Id|12|N(10)| |Id for the product, maximum value 2^^31^^ 154 +|Product property 1|13|N(1)| |Property for product (0-9) ex. for grouping on invoice layout 155 +|Product property 2|14|N(1)| |Property for product (0-9) 156 +|Product property 3|15|N(1)| |Property for product (0-9) 157 + 158 +Note! When service Revenue Accounting is active, the dates must be within revenue month. It is only allowed to use from- and to-date within a calendar month. Use of “Product property” field is set up in agreement with PayEx 159 + 160 +Example on the records appearance: 161 + 162 +**B;12345;4788743;Installationfee1;5;150,00;25,00;1;20180101;20181001;2;;;;** 163 + 164 +**B;12345;4788743;Installationfee2;5;150,00;25,00;1;20180101;20181001;2;123456;1;2;8** 165 + 166 + 167 +== S - Trailer record == 168 + 169 +(% border="1" %) 170 +|=**Field name**|=**Field no**|=**Format**|=**Type**|=**Description** 171 +|Transaction type|1|S|Req|Trailer record. 172 +|Number of records.|2|N(8)|Req|Number of records, main record and end record included. 173 + 174 +Example on the records appearance: 175 + 176 +**S;10** 177 + 178 +== Example on appearance == 179 + 180 +**H;99999;TestFirm;180919;1002** 181 + 182 +**M;0;** 183 + 184 +**P;sp000012;Dressing gown; 3;350,00;25,00;3;;** 185 + 186 +**P;sp000012;Mug; 3;50,00;25,00;3;;134567** 187 + 188 +**P;sp000302;Dressing gown; 1;350,00;25,00;3;214;** 189 + 190 +**I;000087;0702402377;Installation: House;9;** 191 + 192 +**I;000087;0702402377;Calculated year consumption: 24795 kWh;9;** 193 + 194 +**I;000087;0702402377;Calculated meter reading: 000731: 28671;9;** 195 + 196 +**A;000087;0702402377;Electricity june;992;0,129;25,00;6;147;** 197 + 198 +**A;000087;0702402377;Energy tax june;992;0,162;25,00;6;;123456** 199 + 200 +**Q;12345Football;5;23,50;25,00;2;20180101;20181001;1;1;2;8** 201 + 202 +**B;12345;4788743;Installfee;5;150,00;25,00;1;20180101;20181001;212;125478;1;2;8** 203 + 204 +**S;12** 205 + 206 + 207 += Definitions and terms = 208 + 209 +Header record and Trailer record exists only once. Records of the type P, A, I, Q, K and B can exist a multiply of times for a single customer number. 210 + 211 +The maximum length of the product text is depending on which type of invoice layout is used, and is therefore agreed with PayEx. 212 + 213 +There are also some limitations regarding which characters can be used in the product text. See below “Characters that can not be used in product text field”. 214 + 215 +== Characters that not can be used in product text field. == 216 + 217 +(% border="1" %) 218 +|=**Character**|=**ASCII**|=**Function** 219 +| |0|NUL 220 +| |1|SOH 221 +| |2|STX 222 +| |3|ETX 223 +| |4|EOT 224 +| |5|ENQ 225 +| |6|ACK 226 +| |7|BEL 227 +| |8|BS 228 +| |9|TAB 229 +| |10|LF 230 +| |11|VT 231 +| |12|FF 232 +| |13|CR 233 +| |14|SO 234 +| |15|SI 235 +| |16|DLE 236 +| |17|DC1 237 +| |18|DC2 238 +| |19|DC3 239 +| |20|DC4 240 +| |21|NAK 241 +| |22|SYN 242 +| |23|ETB 243 +| |24|CAN 244 +| |25|EM 245 +| |26|SUB 246 +| |27|ESC 247 +| |28|FS 248 +| |29|GS 249 +| |30|RS 250 +| |31|US 251 +|;|59|Semicolon 252 +|~||124|Vertical line 253 +|~~|126|Tilde 254 +| |127|DEL 255 +|–|150|Simple dash 256 + 257 +== Characters that not can be used in A-number field. == 258 + 259 +(% border="1" %) 260 +|=**Character**|=**ASCII**|=**Function** 261 +| |0|NUL 262 +| |1|SOH 263 +| |2|STX 264 +| |3|ETX 265 +| |4|EOT 266 +| |5|ENQ 267 +| |6|ACK 268 +| |7|BEL 269 +| |8|BS 270 +| |9|TAB 271 +| |10|LF 272 +| |11|VT 273 +| |12|FF 274 +| |13|CR 275 +| |14|SO 276 +| |15|SI 277 +| |16|DLE 278 +| |17|DC1 279 +| |18|DC2 280 +| |19|DC3 281 +| |20|DC4 282 +| |21|NAK 283 +| |22|SYN 284 +| |23|ETB 285 +| |24|CAN 286 +| |25|EM 287 +| |26|SUB 288 +| |27|ESC 289 +| |28|FS 290 +| |29|GS 291 +| |30|RS 292 +| |31|US 293 +| |32|Space 294 +|$|36|Dollarsign 295 +|*|42|Asterisk 296 +|;|59|Semicolon 297 +|<|60|Less then 298 +|^|94|Caret 299 +|`|96|Acute accent 300 +|~||124|Vertical line 301 +|~~|126|Tilde 302 +| |127|DEL 303 +|–|150|Simple dash 304 +|¤|164|General currency symbol 305 + 306 +
- PR01_ProductFile_InformationAndRecordDescription (1).docx
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +xwiki:XWiki.ang - Size
-
... ... @@ -1,0 +1,1 @@ 1 +0 bytes - Content
- PR01_ProductFile_InformationAndRecordDescription (1)_html_1cfc5836.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +xwiki:XWiki.ang - Size
-
... ... @@ -1,0 +1,1 @@ 1 +0 bytes - Content
- PR01_ProductFile_InformationAndRecordDescription (1)_html_m334f24f4.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +xwiki:XWiki.ang - Size
-
... ... @@ -1,0 +1,1 @@ 1 +0 bytes - Content
- PR01_ProductFile_InformationAndRecordDescription (1)_html_m3df7deb2.png
-
- Author
-
... ... @@ -1,0 +1,1 @@ 1 +xwiki:XWiki.ang - Size
-
... ... @@ -1,0 +1,1 @@ 1 +0 bytes - Content