CIF_ES (ES - CIF number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/CIF ES
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key CIF_ES
The country a linked concept is active or generally relevant for. Country scope ES (Spain)
Language-specific name. Monolingual name Certificado de Identificación Fiscal (es), CIF number (en)
Language-specific short name. Monolingual short name ES - CIF number (en)
Informal and comprehensive human-readable definition of a concept. Description The Código de Identificación Fiscal (CIF) is the Spanish tax identification number of companies and other legal entities, issued by the Spanish tax agency. Its leading letter shows the legal form, for example A for a public limited company and B for a limited liability company, and the number is quoted on invoices, contracts and tax returns.
Category of business identifiers. Identifier category Tax Number

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
Regular expression/CIF ES/format Validates the format of the Spanish CIF number, the tax identification number of companies and other legal entities, whose leading letter shows the legal form of the entity. The pattern accepts one of the valid leading letters followed by seven digits and a final check digit or letter. IDENTIFIER_FORMAT
^(A|B|C|D|E|F|G|H|J|N|P|Q|R|S|U|V)(\d\s*\.*-*){7}(\d{1}|\w{1})$

Data quality rules

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
Identifier format inaccurate (CIF number (Spain))
REPRESENTATIONAL_CONSISTENCY
ES (Spain) The Spanish CIF number consists of a letter followed by eight digits, or of a letter followed by seven digits and a further letter. This rule checks whether the value is written exactly in that reference format and flags any whitespace, hyphen or dot it contains. INFO IDEA(2020-01-01)
Identifier format invalid (CIF number (Spain))
REPRESENTATIONAL_CONSISTENCY
ES (Spain) The Spanish Certificado de Identificación Fiscal (CIF) consists of nine alphanumeric characters, either a letter followed by eight digits or a letter followed by seven digits and one final letter.

The structure is one organisation type letter, two digits for the provincial code, five digits of sequential numbering and one control character. The organisation type letter states the type of organisation, for example A for a public limited company or B for a limited liability company. The provincial code identifies the Spanish province in which the headquarters of the organisation is located, for example 28 for Madrid or 58 for Barcelona. The five digits that follow are the sequential numbering within that province, and the final control character can be a letter or a digit.

The first letter has the following meanings: A for Sociedad Anónima, B for Sociedad de Responsabilidad Limitada, C for Sociedades Colectivas, D for Sociedades Comanditarias, E for Comunidades de Bienes, F for Sociedades Cooperativas, G for Asociaciones, H for Comunidades de propietarios en régimen de propiedad horizontal, J for Sociedades civiles con o sin personalidad jurídica, P for Corporaciones Locales, Q for Organismos Autónomos, R for Congregaciones e instituciones religiosas, S for Órganos de la administración del estado y de las Comunidades Autónomas, U for Uniones Temporales de Empresas and V for other types not covered by the remaining keys.

ERROR RELEASED(2020-01-01)
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)
Invalid checksum of CIF number (Spain)
ACCURACY
ES (Spain) This rule verifies the checksum letter of the Spanish CIF number.

First the seven digits of the identifier are added together to give sum A. Then each digit in an odd position is multiplied by two and the results are added, whereby a product with two digits is first reduced to a single digit by adding its digits, so a 6 becomes 6 times 2, which is 12, and then 1 plus 2, which is 3, while a 2 becomes 2 times 2, which is 4, this gives sum B. The two sums are added to give C. The last digit of C is subtracted from 10 and the result is the control code, so a C of 14 has a last digit of 4 and yields 10 minus 4, which is 6. If the last digit of C is zero, for example when C is 30, no subtraction is performed and the control code is 0.

ERROR RELEASED(2020-10-12)
Mandatory identifier not maintained (Spain)
COMPLETENESS
ES (Spain) A business partner in Spain should carry at least one of three identifiers: the Spanish European value added tax identifier, the CIF number or the NIF number. If none of the three is available, the record is invalid. ERROR RELEASED(2024-04-16)