Changes for page KUB

Last modified by ang on 2024/03/28 10:31
From version 21.1
edited by ang
on 2020/10/26 12:44
To version 22.1
edited by ang
on 2020/10/26 15:13
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -23,13 +23,6 @@
23 23  KUB file is a customerfile in CSV, and it is used to submit end-user information to PayEx billing. The KUB-file also contains subscriptions och products for end-users. Processing the KUB-files can be done 24/7 and immediately deliver resonse files after processing the file.
24 24  
25 25  
26 -
27 -= Information and record description =
28 -
29 -== **Customer file Billing (KUB)** ==
30 -
31 -
32 -
33 33  == Name convention ==
34 34  
35 35  KUB_<CompanyNumber>_<DateTime>_<(% style="font-size:14px" %)SEQNO(%%)>.DAT
... ... @@ -50,6 +50,8 @@
50 50  * You cannot use the same serial number more than once. In case something goes wrong during CUSIN processing, **you need to supply a new serial number - the next number in the number series you are using - when transferring the rectified file to PayEx**.
51 51  
52 52  
46 +== Change log ==
47 +
53 53  |**Version**|**Date**|**Description**|**Created by**
54 54  |1.04|20-04-21|Corrected file name included seconds|Anders Göthberg
55 55  |1.03|20-01-24|(((
... ... @@ -64,26 +64,8 @@
64 64  |1.0|18-05-04|Created document|Anders Göthberg
65 65  
66 66  =
67 -(% style="color:inherit; font-family:inherit" %)Introduction(%%) =
62 +General information and explanation of records =
68 68  
69 -== File properties ==
70 -
71 -**File name:** FILETYPE_<OWNERCODE>_<DATETIME>_<SEQNO>.ext
72 -
73 -FILETYPECODE = File type, can be equated to format.
74 -
75 -OWNERCODE = Your company number at PayEx.
76 -
77 -DATETIME = YYYYMMDDHHMMSS
78 -
79 -SEQNO = Unbroken serial number sequence.
80 -
81 -**For example: **KUB_1234_20161201155511_1.DAT
82 -
83 -The file is semicolon-separated.
84 -
85 -== 2.2General information and explanation of records ==
86 -
87 87  Customerfile to billing (KUB) is used to submit end-user information to the PayEx Billing System. KUB contains the end customer's customer information together with all of the end customer's subscriptions and products to be processed in the PayEx Billing System.
88 88  
89 89  The PayEx Billing System processes and stores all correct customers. Incorrect customers will be returned in a detailed error file.
... ... @@ -93,17 +93,17 @@
93 93  
94 94  Processing KUB files can be done 24/7 and response files will be delivered immediately after processing KUB files.
95 95  
96 -=== 2.2.1Format ===
73 +=== Format ===
97 97  
98 98  In the format columns below, the numerical values are called N where “n” stands for the maximum number of characters, or in some cases the obligatory number of characters. Alphanumeric characters are written as X. The decimal separator for amounts will be a point “.”. Each record has a description about which character check will be made. Some records are not obligatory but if they do occur, some fields for the record may become obligatory. See the fixed telephony record “C2” for example, or mobile telephony record “MO”. Obligatory records are described with the abbreviation “Obl.” in the type column. All records marked with a star can only be used after contacting Payex.
99 99  
100 100  The customers different records have to be sent in the same order as the record description.
101 101  
102 -=== 2.2.2Implementation ===
79 +=== Implementation ===
103 103  
104 104  Implementation of KUB requires a complete file with all customers. Otherwise it is sufficient to only send updated customers.
105 105  
106 -=== 2.2.3GDPR (General Data Protection Regulation) ===
83 +=== GDPR (General Data Protection Regulation) ===
107 107  
108 108  Inactivating a customer can be done by using record C1, field 8 (CustomerStatus). Default is the value = 2 (Active). For inactive value 1 is used.
109 109  
... ... @@ -111,614 +111,8 @@
111 111  
112 112  As soon as a customer has been send with value 1 (Inactive) no information regarding this customer will be available in any report or api. A final removal of the customers information will be made after x days, where the recommendation is to use the default of 40 days. Within this period it´s possible to reactivate the customer again.This can be done by sending value Active in the customerstatus
113 113  
114 -= 3Records =
91 += Response files =
115 115  
116 -== 3.1 H - Header ==
117 -
118 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
119 -|Transaction type|1|H|Obl.|First record in the file|
120 -|Company number|2|N(5)|Obl.|Company number issued by PayEx. Equal with Owner code in file name|Number
121 -|Company name|3|X(1-40)|Obl.|Your company’s name.|[[PXString>>path:#_PXString]]
122 -|Date of creation|4|N(6)|Obl.|YYMMDD – The same date as in the file name.|[[Date>>path:#_Date]]
123 -|Time of creation|5|N(4)|Obl.|HHMM – Time when the file was created.|[[Time>>path:#_Time]]
124 -
125 -Example of the record appearance:
126 -
127 -**H;1234;Company;161213;1220**
128 -
129 -== 3.2K - Customer record ==
130 -
131 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
132 -|Transaction type|1|K|Obl.|Customer record. First record per customer.|
133 -|Customer number|2|X(1-15)|Obl.|Customer number. The customer number must be unique. If the customer has direct debit as payment method, the customer number format cannot start with more than 5 zeros.|[[Identifier>>path:#_Identifier]]
134 -|Name|3|X(1-72)|Obl.|The customer’s name.|[[PXNameAddressString>>path:#_PXNameAddressString]]
135 -|Registration number|4|N(6)-N(4)|*Obl|(((
136 -The customer’s **S**ocial **S**ecurity **N**umber /Corporate registration number
137 -
138 -Validation of the SSN will be completed if country code has been set in field 7.
139 -
140 -If field 7 is not used, validation will be done on the ledgers country code.
141 -
142 -*If mediadistibutioncode is set to value 52 in combination with E-invoice B2B
143 -)))|[[PXString>>path:#_PXString]]
144 -|Telno.|5|X(1-15)| |The customer’s contact telephone number.|[[PXString>>path:#_PXString]]
145 -|Language|6|X(2)| |The customer’s language on invoice. Contact PayEx for possibilities.|[[PXString>>path:#_PXString]]
146 -|Country code for Registration number|7|X(2)| |Country code for customer with a registration number that not is equal to the country code for the ledger. Used for validation of the registration number in each nordic country.|[[CountryCode>>path:#_CountryCode]]
147 -
148 -Example of the record appearance:
149 -
150 -**K;1234567;Jan Berg;121212-1212;08-1234567**
151 -
152 -== 3.3 A - Address record ==
153 -
154 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
155 -|Transaction type|1|A|Obl.|The address record follows the customer record (K).|
156 -|C/O address|2|X(1-35)| |“Care-of address”.|[[PXNameAddressString>>path:#_PXNameAddressString]]
157 -|Street address|3|X(1-35)| |The customer’s street address.|[[PXNameAddressString>>path:#_PXNameAddressString]]
158 -|ZIP code|4|X(4-9)|Obl.|(((
159 -The customer’s ZIP code.
160 -
161 -For a Zip code outside Sweden requires a country code according to ISO-1366 standard. E.g. NO-3445
162 -
163 -Nordic countries validation is done if it is a valid zip code
164 -)))|[[ZipCode>>path:#_ZipCode]]
165 -|Postal address|5|X(1-27)|Obl.|The customer’s postal address.|[[PXNameAddressString>>path:#_PXNameAddressString]]
166 -|E-mail address|6|X(6-60)|*Obl.|(((
167 -The customer’s e-mail address.
168 -
169 -*If “Media distribution” = 11 (C1 -record, field 9)
170 -
171 -or “ENoteDistributionMethod” = 81 (N record, field 2)
172 -)))|[[Email>>path:#_Email]]
173 -
174 -Example of the record appearance:
175 -
176 -**A;;Gatan 9;SE-12345;Svedala;test@test.se**
177 -
178 -== 3.4 MB - VAT-exemption record* ==
179 -
180 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
181 -|Transaction type|1|MB| |(((
182 -Billing method concerning tax regulations
183 -
184 -Max one per customer
185 -)))|
186 -|VAT type|2|N(1)| |Type of VAT reporting, 0 = normal, 1 = reverse tax liability, 2 = No VAT (inside EU), 3 = No VAT (outside EU)|[[PXVatExemptionCode>>path:#_PXVatExemptionCode]]
187 -|VAT number|3|X(7-14)|Obl.|Used for reverse tax liability (VATNO).|[[VatNumberType>>path:#_VatNumberType]]
188 -|Authorisation code|4|X(1-35)| |The authorisation code can be shown on the invoice as the approved VAT type.|[[PXString>>path:#_PXString]]
189 -
190 -Example of the record appearance:
191 -
192 -**MB;1;SE556677234501;**
193 -
194 -== 3.5E - Extra record ==
195 -
196 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
197 -|Transaction type|1|E| |Extra record. Max one per customer.|
198 -|Terms of payment|2|N(2)| |Number of days. For Sweden the minimum number of days is according Swedish law for now 7 days.|[[Interval:0-99>>path:#_Days]]
199 -|//Not used//|3| | | |
200 -|Payment Method|4|X(2)| |Only Payment Method PG or BG available for new customers|[[PaymentMethod>>path:#_PaymentMethod]]
201 -|//Not used//|5| | | |
202 -|//Not used//|6| | | |
203 -|Verified payment|7|N(1)| |(((
204 -Not direct debit = 0 (default), direct debit = 1.
205 -
206 -Contact PayEx for possibilities.
207 -)))|[[VerifiedPayment>>path:#_VerifiedPayment]]
208 -
209 -Example of the record appearance:
210 -
211 -**E;14;;BG;;;0**
212 -
213 -The extra record is used if some of its values deviate from the company’s default values. The company’s default values are stored in PayEx database.
214 -
215 -== 3.6AL - Alias record* ==
216 -
217 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
218 -|Transaction type|1|AL| |Alias record|
219 -|Alias Type|2|X(2)|Obl.|(((
220 -1 = Subscription number + Alias
221 -
222 -2 = Cost centre grouping, Alias replaces subscription no.
223 -
224 -3 = Alias replaces subscription Number, also applies for specification files
225 -)))|[[AliasType>>path:#_AliasType]]
226 -|Subscriber number|3|X(1-15)|Obl.|The customer’s subscription number from C2 -record, field 2 or MO -record, field 3|[[Identifier>>path:#_Identifier]]
227 -|Alias|4|X(1-40)|Obl.|For Alias Type = 3, empty is permitted|[[PXNameAddressString>>path:#_PXNameAddressString]]
228 -
229 -Examples of the record appearance:
230 -
231 -**AL;1;0812345678;Bengt Bengtsson**
232 -
233 -**AL;2;0887654321;Accounts Department**
234 -
235 -**AL;3;0707011000;Self service**
236 -
237 -Only one alias record (AL) is permitted per subscription number.
238 -
239 -== 3.7C1 - Billing record ==
240 -
241 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
242 -|Transaction type|1|C1|Obl.|Billing information. One record per customer.|
243 -|Billing cycle|2|N(1)| |(((
244 -Billing frequency determines how often the invoice is sent.
245 -
246 -1,2,3,6 = every 1,2,3,6 month
247 -
248 -8 = every 12 months
249 -
250 -9 = Stop, no invoice.
251 -
252 -If no value is entered, the company’s default value will be applied.
253 -)))|[[BillingCycle>>path:#_BillingCycle]]
254 -|Discount rate|3|N(2).N(2)| |Total discount on the invoice in percent, e.g. 23.00|[[DiscountRate>>path:#_DiscountRate]]
255 -|Bill type|4|N(1)|Obl.|(((
256 -Invoice type describes the level of detail on the invoice.
257 -
258 -1 = Invoice
259 -
260 -2 = Invoice and summary
261 -
262 -3 = Invoice and specification
263 -
264 -4 = Invoice, summary and specification
265 -)))|[[BillType>>path:#_BillType]]
266 -|Customer type|5|X(1)| |(((
267 -Customer type can be used to define different customer groups.
268 -
269 -F=Corporate legal entity
270 -
271 -I=Has active subscription
272 -
273 -O=Unspecified
274 -
275 -P=Private
276 -
277 -U=No active subscription
278 -)))|[[PXString>>path:#_PXString]]
279 -|Retailer number|6|X(1-35)| |Retailer number can be used to generate billing statistics.|[[PXString>>path:#_PXString]]
280 -|//Not used//|7| | | |
281 -|Customer status|8|X(2)| |(((
282 -1 = Inactive customer
283 -
284 -2 or empty (default) = Active customer.
285 -)))|[[CustomerStatus>>path:#_CustomerStatus]]
286 -|Media distribution|9|X(2)| |(((
287 -Electronic billing = code issued by PayEx.
288 -
289 -1 = Paper
290 -
291 -11 = E-mail
292 -
293 -52 = E-invoice B2B, = true : then [[EDI-post>>path:#_Electronic_invoice_distribution]] = Obl.
294 -
295 -74 = Archiving only. Ex: company with a customer portal and/or my pages
296 -
297 -94 = E-invoice private. Can only be updated by end customer through its bank
298 -)))|[[InvoiceDistributionCode>>path:#_InvoiceDistributionCode]]
299 -|//Not used//|10| | | |
300 -|Chain number|11|X(1-15)| |Connects customers on customer number level. Used for internal rating.|[[PXString>>path:#_PXString]]
301 -|//Not used//|12|X(1-50)| | |
302 -|Product group discount|13|X(2)|*Obl.|Code that relates to PayEx discount structure. Contact PayEx for possibilities|[[Interval:0-99>>path:#_Interval:0-99]]
303 -|Product group discount rate|14|N(2).N(2)|*Obl.|Discount rate for the product group discount in percent, e.g. 25.00.|[[DiscountRate>>path:#_DiscountRate]]
304 -|(((
305 -Inter Company
306 -
307 -Code
308 -)))|15|X(1-50)| |Company group code|[[PXString>>path:#_PXString]]
309 -|Departments|16|N(2)| |Enables statistics at department level.|[[Interval:0-99>>path:#_Days]]
310 -
311 -Example of the record appearance:
312 -
313 -**C1;;23.00;4;P;af-123;;2;11;;;;;;;**
314 -
315 -**C1;;23.00;4;P;af-123;;2;11;;;B123;;;666;**
316 -
317 -Billing frequency is only used when invoices are issued on a regular basis. If the queue limits are applicable, leave this field empty.
318 -
319 -*Obl. If one is used, the other is obligatory.
320 -
321 -== 3.8C2 - Fixed Telephone record* ==
322 -
323 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
324 -|Transaction type|1|C2| |(((
325 -Fixed telephone information at subscription level.
326 -
327 -Max one per subscriber number.
328 -)))|
329 -|Subscriber number|2|X(1-15)|Obl.|One of the customer’s active subscriber numbers.|[[Identifier>>path:#_String]]
330 -|CLI code|3|X(1-15)| |Possible other identifier.|[[Identifier>>path:#_String]]
331 -|Price list|4|X(1-10)| |Current pricelist for current subscriber number.|[[PXString>>path:#_PXString]]
332 -|//Not used//|5| | | |
333 -|Start date subscription|6|N(6)|Obl.|Date from when the subscription is active YYMMDD.|[[Date>>path:#_Date]]
334 -|End date subscription|7|N(6)| |Date when the subscription ends YYMMDD.|[[Date>>path:#_Date]]
335 -|First product|8|X(1-5)| |Code for the first product for current subscriber number.|[[Identifier>>path:#_String]]
336 -|Start date P1|9|N(6)|1)|Date from when product1 should be billed.|[[Date>>path:#_Date]]
337 -|End date P1|10|N(6)|2)|Date when product1 ends.|[[Date>>path:#_Date]]
338 -|Second product|11|X(1-5)| |Code for the second product for current subscriber number|[[Identifier>>path:#_String]]
339 -|Start date P2|12|N(6)|1)|Date from when product2 should be billed.|[[Date>>path:#_Date]]
340 -|End date P2|13|N(6)|2)|Date when product2 ends.|[[Date>>path:#_Date]]
341 -|Next product …| | | |Up to 35 products can be entered.|
342 -
343 -Examples of the record appearance:
344 -
345 -//C2 record with product without end date~://
346 -
347 -**C2;0812345678;;A1;;160212;;P1;160215;;P2;160210;**
348 -
349 -//C2 record with price list product~://
350 -
351 -**C2;0812345678;;;;160212;;P1;160215;;P2;160210;**
352 -
353 -//C2 record with end date for product~://
354 -
355 -**C2;0812345679;;A2;;150502;160205;P1;150215;160205;P2;150210;160205**
356 -
357 -1) If there are products, start date is obligatory.
358 -
359 -2) If the subscription has an end date, the products must also have an end date, no later than the subscriptions end date.
360 -
361 -Subscription details can occur for different customers if the subscription periods (controlled with start and end date, position 6 and 7) do not overlap.
362 -
363 -== 3.9MO - Mobile Telephone record* ==
364 -
365 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
366 -|Transaction type|1|MO| |Mobile telephone information about a subscription. Max one per IMSI number.|
367 -|IMSI number|2|N(1-15)|Obl|The subscription’s IMSI number, which identifies the subscription in the CDR files.|[[Identifier>>path:#_String]]
368 -|Subscriber number|3|X(1-15)|Obl|The customer’s mobile subscription number.|[[Identifier>>path:#_String]]
369 -|//Not used//|4| | | |
370 -|Start date subscription|5|N(6)|Obl|Date when the subscription starts. Format: YYMMDD.|[[Date>>path:#_Date]]
371 -|End date subscription|6|N(6)| |Date when the subscription ends. Format: YYMMDD.|[[Date>>path:#_Date]]
372 -|Price list|7|X(10)| |Current mobile price list for subscriber number in field 3.|[[PXString>>path:#_PXString]]
373 -|First product|8|X(1-5)| |Code for the first product for current subscriber number.|[[Identifier>>path:#_String]]
374 -|Start date P1|9|N(6)|1)|Date from when product1 should be billed.|[[Date>>path:#_Date]]
375 -|End date P1|10|N(6)|2)|Date when product1 ends.|[[Date>>path:#_Date]]
376 -|Second product|11|X(1-5)| |Code for the second product for current subscriber number.|[[Identifier>>path:#_String]]
377 -|Start date P2|12|N(6)|1)|Date from when product2 should be billed.|[[Date>>path:#_Date]]
378 -|End date P2|13|N(6)|2)|Date when product2 ends.|[[Date>>path:#_Date]]
379 -|Next product.| | | |Up to 35 products can be entered.|
380 -
381 -Examples of the record appearance:
382 -
383 -//MO record with product without end date~://
384 -
385 -**MO;12345678901235;070123123;;160201;;A1;P1;160215;;P2;160810;**
386 -
387 -//MO //record// with end date for product~://
388 -
389 -**MO;12345678901234;07092345678;;160501;;A1;P1;160215;;P2;160210;160831**
390 -
391 -//MO //record// without product~://
392 -
393 -**MO;12345678901234;07092345678;;160501;;A1**
394 -
395 -1) If there are products, a start date is obligatory.
396 -
397 -2) If the subscription has an end date, the products must also have an end date.
398 -
399 -== ==
400 -
401 -== 3.10C3 - Special price record* ==
402 -
403 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
404 -|Transaction type|1|C3| |Special price information at customer level.|
405 -|Destination code|2|X(1-15)|Obl.|Destination code must be found in the DP file.|[[DestinationCode>>path:#_DestinationCode]]
406 -|Special price|3|N(3).N(3)|Obl.|The special price for mentioned destination in field 2|[[SpecialPrice>>path:#_SpecialPrice]]
407 -|Start date|4|N(6)|Obl.|Date from when the special price will be valid.|[[Date>>path:#_Date]]
408 -|End date|5|N(6)| |Date until the special price will be valid.|[[Date>>path:#_Date]]
409 -
410 -Example of the record appearance:
411 -
412 -**C3;45;1.035;160601;**
413 -
414 -If the end date is empty, the price is considered to apply until further notice.
415 -
416 -The start date must be (earlier) than the end date.
417 -
418 -The same destination code can only occur once per customer.
419 -
420 -== 3.11C6 - Call type price record* ==
421 -
422 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
423 -|Transaction type|1|C6| |Call type price info at customer level.|
424 -|Call type|2|N(3)|Obl.|Relates to the call types which have been set up for the company|[[CallType>>path:#_CallType]]
425 -|Prices|3|N(4).N(3)|Obl.|Price for all calls belonging to call types mentioned in field 2.|[[Price>>path:#_Price]]
426 -|Start date|4|N(6)|Obl.|Date from when the price will applied|[[Date>>path:#_Date]]
427 -|End date|5|N(6)| |Date until the special price will be applied..|[[Date>>path:#_Date]]
428 -
429 -Example of the record appearance:
430 -
431 -**C6;19;10.000;160601;**
432 -
433 -If no date is given, the price will apply until further notice.
434 -
435 -The start date must be (earlier) than the end date.
436 -
437 -== 3.12C7 - Family and friends record* ==
438 -
439 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
440 -|Transaction type|1|C7| |Information about family and friends’ number.|
441 -|Subscriber number|2|X(1-15)|Obl.|The customer’s subscription number.|[[Identifier>>path:#_String]]
442 -|B number 1|3|X(1-15)|Obl.|Family and friends no 1.|[[PXNameAddressString>>path:#_PXNameAddressString]]
443 -|B number 2-10|4-12|X(1-15)| |Family and friends no 2-10.|[[PXNameAddressString>>path:#_PXNameAddressString]]
444 -
445 -Example of the record appearance:
446 -
447 -**C7;08123456;070112233;073112233**
448 -
449 -An MO record or C2 record must contain the subscriber number mentioned in field 2.
450 -
451 -== 3.13PR - Product record* ==
452 -
453 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
454 -|Transaction type|1|PR| |Information about recurring products at customer level. Max one record per customer.|
455 -|Product 1|2|X(1-5)|Obl.|Code for product 1.|[[Identifier>>path:#_String]]
456 -|Start date|3|N(6)|Obl.|Date from when the product will be valid.|[[Date>>path:#_Date]]
457 -|End date|4|N(6)| |Date when the product ends.|[[Date>>path:#_Date]]
458 -|Product 2|5|X(1-5)| |Code for product 2.|[[Identifier>>path:#_String]]
459 -|Start date|6|N(6)|**1)**|Date from when the product will be valid.|[[Date>>path:#_Date]]
460 -|End date|7|N(6)| |Date when the product ends.|[[Date>>path:#_Date]]
461 -|Product n| | | |up to a maximum of 35 products per customer.|
462 -
463 -Example of the record appearance:
464 -
465 -**PR;A39;160601;160815;A40;160615;**
466 -
467 -**1)** If there are products, the start date is obligatory.
468 -
469 -The start date must be (earlier) than the end date.
470 -
471 -No more separators are permitted after the position for the end date on the last product. See the example above.
472 -
473 -== 3.14B3 - Special discount record* ==
474 -
475 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
476 -|Transaction type|1|B3| |Special discount information at customer level. Max one per destination code and customer.|
477 -|Destination code|2|X(1-15)|Obl.|Destination code must be found in the DP file.|[[DestinationCode>>path:#_DestinationCode]]
478 -|Special discount|3|N(3).N(2)|Obl.|Discount in percent e.g. 23.00.|[[Discount>>path:#_Discount]]
479 -|Start date|4|N(6)|Obl.|Date from when the special discount will be valid.|[[Date>>path:#_Date]]
480 -|End date|5|N(6)| |Date until the special discount will be valid.|[[Date>>path:#_Date]]
481 -
482 -Example of the record appearance:
483 -
484 -**B3;45;23.00;160601;**
485 -
486 -If the end date is empty, the discount is considered to apply until further notice.
487 -
488 -The start date must be (earlier) than the end date.
489 -
490 -The discount can be calculated on minute price, or minute price plus the start fee for the given destination.
491 -
492 -== 3.15B4 - Call type discount record* ==
493 -
494 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
495 -|Transaction type|1|B4| |Call type discount information at customer level. Max one per call type and customer.|
496 -|Call type|2|N(3)|Obl.|Relates to the call types which have been set up for the company|[[CallType>>path:#_CallType]]
497 -|Discount|3|N(3).N(2)|Obl.|Discount in percent e.g. 23.29.|[[Discount>>path:#_Discount]]
498 -|Start date|4|N(6)|Obl.|Date from when the discount will be valid.|[[Date>>path:#_Date]]
499 -|End date|5|N(6)| |Date until the discount will be valid.|[[Date>>path:#_Date]]
500 -
501 -Examples of the record appearance:
502 -**B4;35;5.00;161004
503 -B4;40;15.00;161004;161101**
504 -
505 -Different discount rates are permitted for the same call types if the periods do not overlap.
506 -
507 -== 3.16N - Electronic-message record* ==
508 -
509 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
510 -|Transaction type|1|N| |E-message information at customer level. Max one per customer.|
511 -|Enote|2|N(2)| |Distribution method for message, code issued by PayEx.|[[ENoteDistributionCode>>path:#_ENoteDistributionCode]]
512 -|Choice of text|3|N(2)| |Default = 1|[[Interval:0-99>>path:#_Days]]
513 -
514 -Example of the record appearance:
515 -
516 -**N;81;1**
517 -
518 -== 3.17EDI - Electronic invoice distribution B2B* ==
519 -
520 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
521 -|Transaction type|1|EDI| |Electronic distribution details. Max one record per customer.|
522 -|Van|2|X(1-255)| |Name of VAN -Company|[[PXString>>path:#_PXString]]
523 -|InterChangeRecipient|3|X(1-13)| |General buyers GLN-number (EAN)|[[PXString>>path:#_PXString]]
524 -|SellerId|4|X(1-13)|Obl.|The Seller´s GLN -number (EAN)|[[PXString>>path:#_PXString]]
525 -|BuyerId|5|X(1-13)|Obl.|The Buyers GLN -number (EAN)|[[PXString>>path:#_PXString]]
526 -|InvoiceAddressee|6|X(1-255)| |Invoice Addressee|[[PXString>>path:#_PXString]]
527 -|InvoiceRecipient|7|X(1-255)| |Invoice Recipient|[[PXString>>path:#_PXString]]
528 -|DeliveryAddressee|8|X(1-255)| |Delivery Addressee|[[PXString>>path:#_PXString]]
529 -|DeliveryRecipient|9|X(1-255)| |Delivery Recipient|[[PXString>>path:#_PXString]]
530 -|InvoiceReference|10|X(1-255)| |Invoice Reference|[[PXString>>path:#_PXString]]
531 -|AgreementReference|11|X(1-255)| |Agreement Reference|[[PXString>>path:#_PXString]]
532 -|BuyerReference1|12|X(1-255)| |Buyer Reference 1|[[PXString>>path:#_PXString]]
533 -|BuyerReference2|13|X(1-255)| |Buyer Reference 2|[[PXString>>path:#_PXString]]
534 -
535 -Example of the record appearance:
536 -
537 -**EDI;INEXCHANGE;7369167123;73500042123;736556123;;Company Ltd;;;54550123;54550002;;**
538 -
539 -== 3.18SI – Subscription Information record ==
540 -
541 -Note: This record type should not be combined with AL record
542 -
543 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
544 -|Transaction type|1|SI| |Subscription Information record type|
545 -|Subscriber number|2|X(1-15)|Obl.|Subscription number/identifier|[[Identifier>>path:#_Identifier]]
546 -|Alias|3|X(1-100)|Obl.|Alias replaces subscriber number on invoice|[[PXNameAddressString>>path:#_PXNameAddressString]]
547 -|Current subscription/price plan description|4|X(1-100)| |To be used only for presentation on invoice|[[PXString>>path:#_PXString]]
548 -|Sort order|5|N(2)|Obl.|Sort order value, used for ordering subscriptions on the invoice if there are multiple subscriptions|[[Interval:0-99>>path:#_Days]]
549 -
550 -Only one record (SI) is permitted per subscription number.
551 -
552 -Examples of the record appearance:
553 -
554 -**SI;070123456;070-123456 - Bengt Bengtsson;Subscription ABC;1**
555 -
556 -**SI;070123457;070-123457 - Blenda Bengtsson;Subscription CDE;2**
557 -
558 -== 3.19S - Trailer ==
559 -
560 -|**Field name**|**Field no**|**Format**|**Type**|**Description**|**Character check**
561 -|Transaction type|1|S|Obl.|Final record. The last record in the file|
562 -|Number of records|2|N(1-15)|Obl.|The total of number of records in the file including the header and the trailer record.|Number
563 -|Number of customers|3|N(1-10)|Obl.|The total of number of customer records in the file.|Number
564 -
565 -Example of the record appearance:
566 -
567 -**S;13;3**
568 -
569 -= 4Explanations / other =
570 -
571 -== Examples of appearance ==
572 -
573 -H;1234;Company;161213;1220
574 -
575 -K;123456789;Nils Nilsson;121212-1212;08-12345678
576 -
577 -A;;Street 9;123 45;Svedala;test@test.se
578 -
579 -E;14;;PG;;
580 -
581 -C1;;23.59;4;;af-123;;;;;;;;
582 -
583 -C2;0812345678;;A1;--;--160212;;P1;160215;;P2;160210;
584 -
585 -C2;0812345679;;A2;;160102;160205;P1;160215;160805;P2;160210;160805
586 -
587 -MO;12345678901234;07092345678;;160501;;A1;P1;160215;;P2;160210;
588 -
589 -MO;12345678901235;070123123;;160201;;A2;P1;160215;;P2;160210;
590 -
591 -C3;4523;1.035;160601;
592 -
593 -C3;4599;1.035;160601;160801
594 -
595 -C6;19;1.035;160601;
596 -
597 -C7;08123456;070112233;073112233;
598 -
599 -PR;A39;160101;160215;A40;160115;
600 -
601 -B3;45;23.29;160601;
602 -
603 -B3;46;23.30;160801;
604 -
605 -B4;19;10.00;160801;
606 -
607 -EDI;INEXCHANGE;7369167123;73500042123;736556123;;Company Ltd;;;54550123;54550002;;
608 -
609 -SI;070123456;070-123456 - Bengt Bengtsson;Subscription ABC;1
610 -
611 -SI;070123457;070-123457 - Blenda Bengtsson;Subscription CDE;2
612 -
613 -S;21;1
614 -
615 -= 5Regular Expressions =
616 -
617 -== 5.1Identifier ==
618 -
619 -* [a-zA-Z0-9]*
620 -
621 -== 5.2PXString ==
622 -
623 -* [a-zA-Z0-9_:!&quot;#&lt;&gt;=?\[\]@{}´ %-/À-ÖØ-öø-ú]*
624 -
625 -== 5.3PXNameAddressString ==
626 -
627 -* [a-zA-Z0-9_:!&quot;#&lt;&gt;=?\[\]@{}´ %-/À-ÖØ-öø-úü]*
628 -
629 -== 5.4ZipCode ==
630 -
631 -* [A-Z0-9\-]+
632 -
633 -== 5.5Email ==
634 -
635 -* [^@]+@[^\.]+\..+
636 -** [[PXString>>path:#_PXString]]
637 -
638 -== 5.6VatNumberType ==
639 -
640 -* [A-Z]{2}.*
641 -
642 -== 5.7DestinationCode ==
643 -
644 -* ^[a-zA-Z0-9@$]*$
645 -
646 -== 5.8CountryCode ==
647 -
648 -* ISO-3166 standard
649 -
650 -= 6Enums and intervals =
651 -
652 -== 6.1PXVatExemptionCode ==
653 -
654 -”0”,”1”,”2”,”3”
655 -
656 -== 6.2Interval:0-99 ==
657 -
658 -”0” – ”99” (Number)
659 -
660 -== 6.3CallType ==
661 -
662 -”1” – ”999”
663 -
664 -== 6.4SpecialPrice ==
665 -
666 -“0.000 – 999.999”
667 -
668 -== 6.5Price ==
669 -
670 -“0.000 – 9999.999”
671 -
672 -== 6.6PaymentMethod ==
673 -
674 -“PG”, "BG", "BA”
675 -
676 -== 6.7VerifiedPayment ==
677 -
678 -”0”,”1”
679 -
680 -== 6.8AliasType ==
681 -
682 -”1”,”2”,”3”
683 -
684 -== 6.9CustomerStatus ==
685 -
686 -”1”,”2”
687 -
688 -== 6.10BillingCycle ==
689 -
690 -”1”,”2”,”3”,”6”,”8”,”9”
691 -
692 -== 6.11DiscountRate ==
693 -
694 -Range from ”0.01” to ”99.99” with two decimal
695 -
696 -== 6.12Discount ==
697 -
698 -Range from ”0.00” to ”100.00” with two decimal
699 -
700 -== 6.13BillType ==
701 -
702 -”1”,”2”,”3”,”4”
703 -
704 -== 6.14InvoiceDistributionCode ==
705 -
706 -”1”,”11”,”52”,”74”,”94”
707 -
708 -== 6.15Date ==
709 -
710 -Valid date in format “YYMMDD” between date “700101” and date “371231”
711 -
712 -== 6.16Time ==
713 -
714 -Valid time in format “HHMM”
715 -
716 -== 6.17ENoteDistributionCode ==
717 -
718 -”81”
719 -
720 -= 7Response files =
721 -
722 722  If the file contains format errors a general error file will be produced.
723 723  
724 724  If the file format is correct and the file contains correct and incorrect customers an error file with filename (BERR010..ErrorlogKund) and a receipt file (BRCP010..ReceiptCustomerfile) will be produced.
... ... @@ -725,7 +725,7 @@
725 725  
726 726  If the file format is correct and the file contains only correct customers no error file will be produced, only a receipt file will be produced.
727 727  
728 -== 7.1Error -file ==
99 +== Error -file ==
729 729  
730 730  Examples of an extract from an error-file:
731 731