Changes for page Error log (BERR010)
Last modified by Anders Göthberg on 2023/11/14 11:10
From empty
To version 18.1
edited by Anders Göthberg
on 2022/03/10 10:46
on 2022/03/10 10:46
Change comment: There is no comment for this version
Summary
-
Page properties (6 modified, 0 added, 0 removed)
-
Attachments (0 modified, 2 added, 0 removed)
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.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,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