Identifier consistency
| Property | Value |
|---|---|
| A technical identifier, unique in a certain context. Technical key | IDENTIFIER_CONSISTENCY
|
| 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 | This category encompasses data quality rules that verify the consistency of identifiers that have defined relationships or dependencies. Some identifiers are constructed from or must align with other identifiers. For example, the French SIREN number is part of the French VAT number, and these must be consistent with each other. Similarly, a company's local registration number might be embedded in its tax identifier. These rules check that when multiple related identifiers exist for the same entity, they maintain their expected mathematical or structural relationships. Inconsistencies can indicate data corruption, manual entry errors, or mismatched records. This validation is essential for data integrity in the Consistency dimension, ensuring that interdependent identifiers remain aligned and coherent across business partner records. |
| Hierachical parent concept of a concept. Parent | Consistency |
Data quality rules
CDQ manages 17 data quality rules in this category.
| Data quality rule | The country a linked concept is active or generally relevant for. Country scope | Informal and comprehensive human-readable definition of a concept. Description | Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality
|
Rule release status<br/>The release status in terms of development progress or maturity of a data quality rule.<br/>IDEA: Initial rule definition that documents a business requirement but is not yet active in services.<br/>PLANNED: Rule is specified and scheduled for implementation, but not yet active in services.<br/>DRAFT: Rule concept is being prepared or refined but is not yet finalized for implementation or execution.<br/>HYPERCARE: Rule is newly released and under increased observation to ensure stable behaviour and correct results.<br/>RELEASED: Rule has passed verification and is actively executed in productive CDQ services.<br/>DEACTIVATED: Rule is temporarily removed from the active rule set because it needs correction or clarification before re release.<br/>BLOCKED: Rule cannot be released because something it depends on is missing, for example a data source or a clarification.<br/>ARCHIVED: Rule is permanently retired and no longer maintained or intended for future activation. Rule release status
|
|---|---|---|---|---|
Inconsistency between BIC FI and EU VAT ID FI (Finland)CONSISTENCY
|
FI (Finland) | The Finnish business identity code and the Finnish European VAT number carry the same value: the digits of the VAT number are identical to the business identity code. This rule reports an inconsistency whenever the eight digits following the FI prefix of the VAT number differ from the eight digits of the business identity code. The business identity code is usually written in the form 1234567-8, the rule ignores the dash as well as the FI prefix of the VAT number. | WARNING
|
RELEASED(2020-12-28)
|
Inconsistency between Business Number and GST number (Canada)CONSISTENCY
|
CA (Canada) | The Canadian business number consists of nine digits, and the Canadian GST number is built from it: nine digits that are exactly the business number, followed by the letters RT, which mark the value as a GST number, followed by a four-digit suffix such as 0001 or 0002. An entity can hold more than one GST number, for example when it runs two separate businesses, in which case the first carries the suffix 0001, the second 0002 and so on.
This rule checks that both a GST number and a business number are present and that the first nine digits of the GST number are identical to the business number. If they are not, either the GST number or the business number is wrong. |
ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between Business Number and HST number (Canada)CONSISTENCY
|
CA (Canada) | The Canadian HST number is built from the business number: nine digits that are exactly the business number, followed by the program identifier RT and a four-digit reference number such as 0001 or 0002.
This rule checks that both an HST number and a business number are present and that the first nine digits of the HST number are identical to the business number. If they are not, either the HST number or the business number is wrong. |
ERROR
|
HYPERCARE
|
Inconsistency between CIF ES and EU VAT ID ES (Spain)CONSISTENCY
|
ES (Spain) | The Spanish CIF and the Spanish European VAT number carry the same value, the VAT number being the prefix ES followed by the CIF. This rule reports an inconsistency whenever the last eight digits of the VAT number are not identical to the CIF. | ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between DIC number and EU VAT SK (Slovakia)CONSISTENCY
|
SK (the Slovak Republic) | The Slovak European value added tax identifier consists of the prefix SK followed by ten digits, which are the Slovak DIC number. This rule checks that the DIC number matches those ten digits of the VAT identifier, any difference results in a rule violation. | ERROR
|
RELEASED(2021-07-01)
|
Inconsistency between DNI number and CUIL number (Argentina)CONSISTENCY
|
AR (Argentina) | The Argentine CUIL number consists of a two-digit prefix, the eight-digit DNI of its holder and a check digit, the DNI being padded with leading zeros where it has fewer than eight digits. This rule reports an inconsistency when a business partner carries both numbers and digits three to ten of the CUIL are not identical to the DNI, disregarding any whitespaces, dots and hyphens. | ERROR
|
HYPERCARE
|
Inconsistency between Enterprise number and European value added tax identifier (Belgium)CONSISTENCY
|
BE (Belgium) | The Belgian European VAT number is the Enterprise number prefixed by BE. This rule checks that the Belgian Enterprise number matches the ten digits of the VAT identifier, and any difference results in a rule violation. Whether the resulting VAT number actually exists still has to be confirmed via VIES, and not every company requires a VAT number. | ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between Fiscal Registration Code and EU VAT ID RO (Romania)CONSISTENCY
|
RO (Romania) | The Romanian European value added tax identifier consists of the prefix RO followed by nine digits, which are the Romanian Fiscal Registration Code, and a checksum digit. This rule checks that the Fiscal Registration Code matches those nine digits of the VAT identifier. If the Fiscal Registration Code is shorter than nine digits, or the VAT identifier shorter than ten, leading zeros are assumed. Any difference results in a rule violation. | ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between NIP number and European value added tax identifier (Poland)CONSISTENCY
|
PL (Poland) | The Polish NIP number is the Polish European VAT number without its PL prefix. This rule checks that the ten digits following the PL prefix are identical to the NIP number, and any difference results in a rule violation. | ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between OIB number and EU VAT HR (Croatia)CONSISTENCY
|
HR (Croatia) | The Croatian European value added tax identifier consists of the prefix HR followed by eleven digits, which are the OIB number, also known as the personal identification number. This rule checks that the OIB number matches those eleven digits of the VAT number, any difference results in a rule violation. | ERROR
|
RELEASED(2024-09-18)
|
Inconsistency between PAN and GST number (India)CONSISTENCY
|
IN (India) | The Indian Permanent Account Number (PAN) is the tax identification number of the country and is ten characters long. The Indian GST number is built around it: a state code, then exactly the ten characters of the PAN, then a digit giving the number of entities registered under the same PAN, then the letter Z by default, and finally a checksum character that can be a digit or a letter.
This rule checks that both a PAN and an Indian GST number are present and that the ten characters inside the GST number are identical to the PAN. If they are not, either the PAN or the GST number is wrong. |
ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between RSIN and European value added tax identifier (The Netherlands)CONSISTENCY
|
NL (Netherlands) | The nine digits following the NL prefix of the Dutch European value added tax identifier are the RSIN. This rule checks that those nine digits are identical to the RSIN of the business partner, and any difference results in a rule violation. | ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between SIREN and EU VAT ID (France)CONSISTENCY
|
FR (France) | The SIREN number is the French company register identifier and consists of nine digits. The French VAT number is built from it as the prefix FR, two calculated digits and then exactly the nine digits of the SIREN.
This rule checks that both a SIREN number and a French European VAT number are present and that the last nine digits of the VAT number are identical to the SIREN. If they are not, either the SIREN or the VAT identifier is wrong. |
ERROR
|
RELEASED(2020-12-28)
|
Inconsistency between SIREN and SIRET number (France)CONSISTENCY
|
FR (France) | The French SIRET number consists of fourteen digits whose first nine are the SIREN number. This rule checks that the SIREN number matches the first nine digits of the SIRET, and any difference results in a rule violation. | ERROR
|
RELEASED(2020-01-01)
|
Inconsistency between Tax ID and Personal ID number (Thailand)CONSISTENCY
|
TH (Thailand) | The Thai tax identification number consists of ten digits. Where it is meant to be the same as the personal identification number it has thirteen digits and matches that number in full. This rule checks that the tax identification number and the personal identification number agree, any difference results in a rule violation. | ERROR
|
RELEASED(2024-09-18)
|
Inconsistency of legal form and identifier (NIF number (ES))CONSISTENCY
|
ES (Spain) | The first letter of the Spanish NIF number indicates the legal form of the entity it represents. This rule compares the legal form given for the business partner, for example as part of the business partner name, with the legal form implied by that first letter and reports any inconsistency between the two. | INFO
|
RELEASED(2024-04-16)
|
Inconsistency of legal form and identifier (Tax number (TR))CONSISTENCY
|
TR (Turkey) | The first digit of the Turkish tax number indicates the legal form of the entity it represents. This rule compares the legal form given for the business partner, for example as part of the business partner name, with the legal form implied by that first digit and reports any inconsistency. | INFO
|
RELEASED(2024-04-16)
|