Release note/20201228
| Release date Date and time when a concept, e.g. a data quality rule, is released, i.e. when the status changes to <code>RELEASED</code>. | 28-12-2020 |
|---|---|
| Feature Affected feature(s) | Data Mirror |
| Idea portal Ideas that have been introduced with the release | no idea entry directly linked with this release note |
Extended tax and business identifier checks
The data quality checks have been extended by additional x data quality rules. This allows for checking a much broader scope of countries that were not considered in earlier releases. In detail, mainly additional rules for checking identifier formats and identifier checkdigits are now available. See more details in the full release note.
New data quality rules released
| Description | Criticality | Country | |
|---|---|---|---|
| Identifier checkdigit invalid (GST number (India)) | This rule checks the check digit of the Goods and Services Tax number (GST) in India. The first fourteen digits of the GST are the GST number (India).
calculate a hash of each digit of GST number. Steps for calculation of hash are mentioned below: a) Obtain corresponding code [C] for each alphanumeric digit of GST number. The codes for each alphanumeric characters are as following:
b) Multiply “code” with a number called Multiplier [M], which will be 1 for odd digits and 2 or even digits of GST Number. c) So on multiplication of “code” with “multiplier” [ C x M ] we get a number called Product [P]. d) Divide “product” with 36 [ P ÷ 36]. This division yields us a Quotient [Q] & a Remainder ['R]. e) Add “quotient” and “remainder” [ Q + R ] to get Hash of that digit of GST number. Repeat the above steps for each digit of GST number, and obtain corresponding hash. After that, derive the checksum digit with below-mentioned steps: For these 14 digits the check digit is calculated, in the following way:
| ERROR | IN (Indien, India, Inde, Bhārat, 印度) |
| Identifier checkdigit invalid (NIP number (Poland)) | This rule describes the algorithm for checksum digit (the last 10th digit) for NIP number (Poland) using the following logic:
1) multiply the fist 9 digits of the NIP by the corresponding wages: 6, 5, 7, 2, 3, 4, 5, 6, 7; 2) sum up the result of the multiplication from step one; 3) calculate modulo 11. | ERROR | PL (Polen, Poland, Pologne, Polska, 波兰) |
| Identifier checkdigit invalid (NIT number (Colombia)) | This rule checks the checkdigit of NIT number (Colombia). | ERROR | CO (Kolumbien, Colombia, Colombia, Colombie, 哥伦比亚) |
| Identifier checkdigit invalid (REGON (Poland)) | This rule describes the algorithm for checksum digit (the last digit) for REGON identifier. Logic for 9-digits identifier:
1) multiply each of the first 8 digits by the gidit-wages: 8 9 2 3 4 5 6 7 ; 2) sum up the numbers received in step 1; 3) apply modulo 11. the rest is equal to the schecksum digit. For the 14-digits REGON identifier the logic is the same, but the wages for the first 13 digits are different: 2 4 8 5 0 9 7 3 6 1 2 4 8. | ERROR | PL (Polen, Poland, Pologne, Polska, 波兰) |
| Identifier checkdigit invalid (RUC number (Paraguay)) | This rule checks the checkdigit of RUC number (Paraguay). | ERROR | PY (Paraguay, Paraguay, Paraguay, Paraguay, Paraguay, 巴拉圭) |
| Identifier checkdigit invalid (RUC number (Peru)) | This rule checks the checkdigit of RUC number in Peru
[C1,C2, C3, C4, C5, C6, C7, C8, C9, C10] - Every single digit in 10 digit input number has its corresponding weight: [5, 4, 3, 2, 7, 6, 5, 4, 3, 2] 1. Multiply every element from input number by corresponding weight: - C1 * 5 - C2 * 4 - C3 * 3 - C4 * 2 - C5 * 7 - C6 * 6 - C7 * 5 - C8 * 4 - C9 * 3 - C10 * 2 2. Sum up all of results (sumproduct) 3. The reminder of the modulo 11 4. Subtract restults from 11 5. Checkdigit = the reminder of modulo 10 | ERROR | PE (Perú, Peru, Peru, Perú, Pérou, Perú, 秘鲁) |
| Identifier checkdigit invalid (RUT number (Chile)) | This rule checks the checkdigit of RUT number (Chile). | ERROR | CL (Chile, Chile, Chile, Chili, 智利) |
| Identifier checkdigit invalid (RUT number (Uruguay)) | This rule checks the checkdigit of RUT number (Uruguay). | ERROR | UY (Uruguay, Uruguay, Uruguay, Uruguay, 乌拉圭) |
| Identifier checkdigit invalid (Tax Identification Number (Serbia)) | 9 digits (ex. 123456788) of which the first 8 are the actual ID number, and the last digit is a checksum digit, calculated according to ISO 7064, MOD 11-10 | ERROR | RS (Serbien, Serbia, Serbie, Srbija, 塞尔维亚) |
| Identifier checkdigit invalid (Tax identification number (South Africa)) | This rule describes the algorithm for checksum digit (the last digit) for Tax identification number (South Africa). Logic for 10-digits identifier:
The last character is a check digit, calculated by applying the following algorithm:
Digit 10: Check digit
| ERROR | ZA (Suid-Afrika, Südafrika, South Africa, Afrique du Sud, Ningizimu Afrika, Afrika-Borwa, Afrika-Borwa, Afrika-Dzonga, Afrika Tshipembe, Mzantsi Afrika, 南非, Ningizimu Afrika) |
