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
An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description	Validates that related identifiers maintain logical consistency with each other.
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 15 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/>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/>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 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	RELEASED(2020-12-28)
Inconsistency between Business Number and GST number (Canada) CONSISTENCY	CA (Canada)	The Canadian business number consists of 9 digits. The GST number in Canada is composed as follows: XXXXXXXXX RT YYYY whereby X: is exactly the 9 digit business number RT indicates that we are dealing with a GST number Y: a four digit number (e.g. 0001, 0002). There could be more than exactly 1 GST number, e.g. when an entity has two separate businesses. Then the first business has the GST number with suffix 0001, and the second 0002, etc. This rule checks whether there is a GST number and a business number, and whether the first 9 digits of the GST number are identical to the 9 digits of the business number. If this is not the case then either the GST or the business number are considered invalid.	ERROR	RELEASED(2020-12-28)
Inconsistency between CIF ES and EU VAT ID ES (Spain) CONSISTENCY	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: the last 8 digits of the EU VAT ID are not identical with the CIF	ERROR	RELEASED(2020-12-28)
Inconsistency between DIC number and EU VAT SK (Slovakia) CONSISTENCY	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	RELEASED(2021-07-01)
Inconsistency between Enterprise number and European value added tax identifier (Belgium) CONSISTENCY	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	RELEASED(2020-12-28)
Inconsistency between Fiscal Registration Code and EU VAT ID RO (Romania) CONSISTENCY	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	RELEASED(2020-12-28)
Inconsistency between NIP number and European value added tax identifier (Poland) CONSISTENCY	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	RELEASED(2020-12-28)
Inconsistency between OIB number and EU VAT HR (Croatia) CONSISTENCY	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	RELEASED(2024-09-18)
Inconsistency between PAN and GST number (India) CONSISTENCY	IN (India)	The Permanent Account Number (PAN) in India is the Tax Identification number. It consists of 10 characters composed as follows: SSYYYYYYYYYYNZX whereby S: is the state code Y: is exactly the 10 digit PAN number N: is the number of entities registered with the same PAN number. Z: is the alphabet Z by default X: checksum digit (either number/ alphabet) This rule checks whether there are a PAN number and IN_GST available and whether the 10 digits in the GST number are identical to the 10 digits of the PAN number. If this is not the case then either the PAN or GST number are considered invalid.	ERROR	RELEASED(2020-12-28)
Inconsistency between RSIN and European value added tax identifier (The Netherlands) CONSISTENCY	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	RELEASED(2020-12-28)
Inconsistency between SIREN and EU VAT ID (France) CONSISTENCY	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 Y: is exactly the 9 digit SIREN number X: two calculated digits (logic unclear) FR: the EU VAT prefix This rule checks whether there is a SIREN number and EU_VAT_ID_FR available, and whether the last 9 digits of the VAT number are identical to the 9 digits of the SIREN number. If this is not the case then either the SIREN or VAT ID are considered invalid.	ERROR	RELEASED(2020-12-28)
Inconsistency between SIREN and SIRET number (France) CONSISTENCY	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	RELEASED(2020-01-01)
Inconsistency between Tax ID and Personal ID number (Thailand) CONSISTENCY	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	RELEASED(2024-09-18)
Inconsistency of legal form and identifier (NIF number (ES)) CONSISTENCY	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	RELEASED(2024-04-16)
Inconsistency of legal form and identifier (Tax number (TR)) CONSISTENCY	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	RELEASED(2024-04-16)