От версии 15.1
отредактировано Andreas Benneck
на 2020/10/22 14:51
К версии 15.2
отредактировано Andreas Benneck
на 2020/10/22 14:52
Комментарий к изменению: К данной версии нет комментариев

Summary

Details

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