Identifier consistency (rule category)
From CDQ Wiki
Public:Rule category/Identifier consistency
| Property | Value |
|---|---|
| The human-friendly name shown for this concept in the user interface, used instead of the technical name to improve readability and understanding. Display name | Identifier consistency |
| Informal and comprehensive human-readable definition of a concept. Description | Some identifiers are constructed based on other identifiers. For example the French SIREN number is part of the French VAT number. Data quality rules check that the values are consistent. |
| Dimensional categorization of a concept, e.g., a data quality dimension of a data quality rule. Dimension | Consistency |
| Hierachical parent concept of a concept. Parent | Consistency (rule category) |
Data quality rules
| Rule | Country | Description | Criticality |
|---|---|---|---|
| Inconsistency between BIC FI and EU VAT ID FI (Finland) | FI (Finland) | The Business identity code in Finland and the European VAT number in Finland share identical values. The numerical digits of the EU VAT are identical with the business identity code. There is an inconsistency when the 8 digits after the FI prefix of the EU VAT are different to the 8 digits of the business identity code (usually formatted like this "1234567-8", the dash and the EU VAT prefix "FI" are omitted by this rule) | WARNING |
| Inconsistency between Business Number and GST number (Canada) | CA (Canada) | The Canadian business number consists of 9 digits. The GST number in Canada is composed as follows: XXXXXXXXX RT YYYY whereby
| ERROR |
| Inconsistency between CIF ES and EU VAT ID ES (Spain) | ES (Spain) | The CIF and European VAT number for Spain share identical values. The EU VAT ID is composed by the prefix ES + the CIF. There is an inconsistency when:
| ERROR |
| Inconsistency between DIC number and EU VAT SK (Slovakia) | SK (the Slovak Republic) | European value added tax identifier (Slovakia) consists of prefix 'SK" and 10 digits which are equal to the DIC number (Slovakia). This rule checks if the DIC number is equal to the 10 digits in EU VAT SK identifier. Any difference results in a rule violation. | ERROR |
| Inconsistency between Enterprise number and European value added tax identifier (Belgium) | BE (Belgium) | The EU VAT equals the Enterprise number prefixed by BE. But it is to be checked whether the resulting VAT is really existing via VIES. Not all companies require a VAT. This rules check if the belgian Enterprise number is equal to the 10 digits of EU_VAT_ID_BE. Any difference result in a rule violation. | ERROR |
| Inconsistency between Fiscal Registration Code and EU VAT ID RO (Romania) | RO (Romania) | European value added tax identifier (Romania) consists of prefix "RO" and 9 digits which are equal to the Fiscal Registration Code (Romania) and a checksum digit. This rules check if the Fiscal Registration Code (Romania) is equal to the 9 digits in EU VAT RO identifier.
Note that if the length of theFiscal Registration Codes is less than 9 digits or European value added tax identifier (Romania) has less the 10 digits, leading zeros must be assumed. Any difference result in a rule violation. | ERROR |
| Inconsistency between NIP number and European value added tax identifier (Poland) | PL (Poland) | PL_NIP = EU_VAT_ID_PL number without prefix PL. This rules check if the 10 digits following the "PL" in EU_VAT_ID_PL are equal to NIP number. Any difference result in a rule violation. | ERROR |
| Inconsistency between OIB number and EU VAT HR (Croatia) | HR (Croatia) | The European value added tax identifier in Croatia consists of the prefix HR and 11 digits which are equal to the OIB number (also known as Personal Identification Number). This rule checks if the OIB number is equal to the 11 digits of the EU VAT number. Any difference results in a rule violation. | ERROR |
| Inconsistency between PAN and GST number (India) | IN (India) | The Permanent Account Number (PAN) in India is the Tax Identification number. It consists of 10 characters composed as follows: SSYYYYYYYYYYNZX whereby
| ERROR |
| Inconsistency between RSIN and European value added tax identifier (The Netherlands) | NL (Netherlands) | The 9 digits following the "NL"-prefix are the RSIN. This rules check if the 9 digits following the "NL" in EU_VAT_ID_BE are equal to RSIN. Any difference result in a rule violation. | ERROR |
| Inconsistency between SIREN and EU VAT ID (France) | FR (France) | The SIREN number is the French Company Register ID. It consists of 9 digits. The VAT number in France is composed as follows: FR XX YYYYYYYYY whereby
| ERROR |
| Inconsistency between SIREN and SIRET number (France) | FR (France) | SIRET number (France) consists of 14 digits where the first 9 digits are equal to the SIREN number. This rules check if the SIREN number is equal to the first 9 digits of the SIRET number. Any difference result in a rule violation. | ERROR |
| Inconsistency between Tax ID and Personal ID number (Thailand) | TH (Thailand) | TAX ID (Thailand) consists of 10 digits, but in case that TAX ID should be equal to Personal ID then it consists of 13 digits and all the digits are equal to the Personal number. This rules check if the TAX ID number is equal to the Personal ID number. Any difference result in a rule violation. | ERROR |
| Inconsistency of legal form and identifier (NIF number (ES)) | ES (Spain) | The first letter of the NIF number (Spain) in Spain indicates the legal formation of the represented entity. This rule checks for any inconsistencies between a given legal form (e.g. as provided in the business partner name) and the first letter of the given NIF number. | INFO |
| Inconsistency of legal form and identifier (Tax number (TR)) | TR (Turkey) | The first digit of the Tax number (Turkey) in Turkey indicates the legal formation of the represented entity. This rule checks for any inconsistencies between a given legal form (e.g. as provided in the business partner name) and the first digit of the given tax number. | INFO |