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