From empty
To version 18.1
edited by Anders Göthberg
on 2022/03/10 10:46
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Error log (BERR010)
Parent
... ... @@ -1,0 +1,1 @@
1 +Main.Invoicing.billing.technical-reference.Costumer information.2 KUB xml.Example Error file KUB.WebHome
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.XWikiGuest
1 +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,169 @@
1 +(% id="HNameconvention" %)
2 += Name convention =
3 +
4 + BERR010_<CompanyNumber>_<DateTime>_0[ErrorlogKund_<BatchId>].DAT
5 +
6 +
7 +(% border="1" %)
8 +|=Names Component|=Description
9 +|CompanyNumber|The company number in PayEx ledger system
10 +|DateTime|Date created in format YYYYMMDDHHMMSS
11 +|ErrorlogKund|File description
12 +|BatchId|Billing process Id
13 +
14 +**For example: BERR010_12345_20220415093539_0[ErrorlogKund_1234567].DAT**
15 +
16 += Change log =
17 +
18 +(% border="1" %)
19 +|**Version**|**Date**|**Description**|**Created by**
20 +|1.0|22-02-22|Document created|Daniel Olsson
21 +
22 +(% id="HGeneralinformationandexplanationofrecords" %)
23 += General information and explanation of records =
24 +
25 +The error log presenting format and logical errors in KUB -files.
26 +
27 +
28 +(% id="HFormatdescription" %)
29 +== Format description ==
30 +
31 +All fields in the mentioned report are separated with semicolons ”;”. Sort order is sequence number. 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.
32 +
33 +Dot “.” is decimal separator on fields with amount. Some records are not obligatory but if they exist some fields in the record can be obligatory. Obligatory records are described with the abbreviation ” Req.” in the type column.
34 +
35 += Record description =
36 +
37 +== H - Header record ==
38 +
39 +(% border="1" %)
40 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
41 +|Record type|1|H|Req.|Record type
42 +|Firm number|2|N(5)|Req.|You receive the firm number from PayEx.
43 +|Firm name|3|X(40)|Req.|Your firm name.
44 +|Process Id|4|N(10)|Req.|Process Id from process
45 +|Created date|6|N(6)|Req.|YYMMDD – Same date as in the file name.
46 +|Created time|7|N(4)|Req.|HHMM – Time when the file was created.
47 +
48 +== I - Information record ==
49 +
50 +(% border="1" %)
51 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
52 +|Record type|1|I|Req.|Information record type
53 +|Code|2|N(15)|Req.|Information code
54 +|Description|3|X(1000)|Req.|Description of information code
55 +|Value|4|X(300)|Req.|Value
56 +
57 +== W - Warning record ==
58 +
59 +(% border="1" %)
60 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
61 +|Record type|1|W|Req.|Warning record type
62 +|Code|2|N(15)|Req.|Warning code
63 +|Line|3|N(15)| |Corresponding line number in file
64 +|Customer number|4|X(15)| |Customer number
65 +|Type|5|X(50)|Req.|Warning type (format/logic)
66 +|Description|6|X(1000)|Req.|Warning description
67 +
68 +== E - Error record ==
69 +
70 +(% border="1" %)
71 +|**Field name**|**Field no.**|**Format**|**Type**|**Description**
72 +|Record type|1|E|Req.|Error record type
73 +|Code|2|N(15)|Req.|Error code
74 +|Line|3|N(15)| |Corresponding line number in file
75 +|Customer number|4|X(15)| |Customer number
76 +|Type|5|X(50)|Req.|Error type (format/logic)
77 +|Description|6|X(1000)|Req.|Error description
78 +
79 +== S - Trailer record ==
80 +
81 +(% border="1" %)
82 +|**Field name**|**Field no**|**Format**|**Type**|**Description**
83 +|Record type|1|S|Req.|Record type
84 +|Total number of records|2|N(8)|Req.|Number of records, header record, description record and trailer record included.
85 +
86 +== ==
87 +
88 +== Example ==
89 +
90 +H;12345;Name;717971;220131;1247
91 +E;1001;36;cust001;Logic; Incorrect format aabbccddeeffgghhjjkkllmmnnooppqqrrssttuuvv, Exceeds max length[35] [Position 3]
92 +E;1241;44;cust002;Logic; Mandatory field[Address] on position 5 is missing!
93 +E;1241;55;cust003;Logic; Mandatory field[Name] on position 3 is missing!
94 +E;1241;66;cust004;Logic; Mandatory field[Name] on position 3 is missing!
95 +I;15313;Parameters;Name of processed file: KUB_12345_20220113161144_1.DAT
96 +S;7
97 +
98 +== Logic ==
99 +
100 +This error report is based on errors detected in PayEx billing system customer file process.
101 +If error occurs in PayEx billing system customer file process the customer will be rejected, not the entire file
102 +
103 +== Result codes ==
104 +
105 +=== Information codes ===
106 +
107 +(% border="1" %)
108 +|**Code**|**Category**|**Description**
109 +|15313|Parameters|KUB file name
110 +
111 +=== Warning codes ===
112 +
113 +Not used in this error log
114 +
115 +=== Error codes ===
116 +
117 +(% border="1" %)
118 +|**Code**|**Category**|**Description**
119 +|1001|Logic|Incorrect format
120 +|1019|Logic|CustomerNumber is missing
121 +|1024|Logic|Invalid RegistrationNumber
122 +|1025|Logic|CountryCode must be the same as where debtor is nationally registered
123 +|1026|Logic|Invalid ZipCode specified for CountryCode and AddressType
124 +|1027|Logic|Invalid ZipCode specified for CountryCode and AddressType
125 +|1238|Logic|Duplicate record
126 +|1240|Logic|Invalid record sequence
127 +|1241|Logic|Mandatory field is missing
128 +|2500|Logic|Product code not configured
129 +|2510|Logic|Product is not a valid because it is a credit product
130 +|2520|Logic|Start date for product in file is incorrect in relation to product start date
131 +|2540|Logic|Start date is set after end date
132 +|2560|Logic|Products with shared properties cannot overlap
133 +|2570|Logic|If CustomerStatus is Inactive, product needs an end date
134 +|3000|Logic|Date has to be within UsagePeriod
135 +|3040|Logic|Multiple pricelists overlap
136 +|3050|Logic|IMSI active in multiple, overlapping, periods
137 +|3060|Logic|CLICode active in multiple, overlapping, periods
138 +|3080|Logic|Missing alias subscription
139 +|3090|Logic|Unknown subscriber number
140 +|4000|Logic|CustomerNumber has already been processed in current file
141 +|4010|Logic|Reseller does not exist in DB
142 +|4020|Logic|Invalid CustomerCategoryCode
143 +|4030|Logic|Invalid BillingCycle
144 +|4040|Logic|Invalid PaymentType for country
145 +|4050|Logic|Invalid PaymentRule for country
146 +|4090|Logic|Invalid EmailAddress
147 +|4100|Logic|Invalid LanguageCode
148 +|4110|Logic|Invalid ProductGroupDiscountCode
149 +|4120|Logic|ProductGroupDiscountCode set in file, but ProductGroupDiscountRate is missing
150 +|4130|Logic|ProductGroupDiscountRate set in file, but ProductGroupDiscountCode is missing
151 +|4140|Logic|BuyerId missing: For InvoiceDistributionCode[52] BuyerId required
152 +|4150|Logic|SellerId missing: For InvoiceDistributionCode[52] SellerId required
153 +|4155|Logic|EdiInfo missing: For InvoiceDistributionCode[52] EdiInfo required
154 +|4160|Logic|Card missing! This field is mandatory for PaymentMethod [AK].
155 +|4170|Logic|PaymentMethod has to be AK, when Card is specified!
156 +|4180|Logic|Invalid DestinationCode
157 +|4190|Logic|Invalid UsageType
158 +|4200|Logic|UsageType is active in multiple, overlapping, periods
159 +|4210|Logic|SpecialPrice is active in multiple, overlapping, periods
160 +|4220|Logic|CustomerNumber has to many leading zeros
161 +|4230|Logic|CustomerNumber has already been inactivated!
162 +|4240|Logic|PaymentTerms is lower than the allowed limit
163 +|4250|Logic|IntercompanyCode does not exist in configuration.
164 +|6000|Logic|Customer has unbilled fee(s). Customer status cannot be set to Inactive
165 +
166 +=== ===
167 +
168 +
169 +
BERR010_InformationAndRecordDescription_Draft_220204.docx
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.ang
Size
... ... @@ -1,0 +1,1 @@
1 +0 bytes
Content
BERR010_InformationAndRecordDescription_Draft_220204_html_m334f24f4.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.ang
Size
... ... @@ -1,0 +1,1 @@
1 +0 bytes
Content