ES_NIF (ES - Tax Identification Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/ES NIF
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key ES_NIF
The country a linked concept is active or generally relevant for. Country scope ES (Spain)
Language-specific name. Monolingual name Documento Nacional de Identidad (es), Número de Identificación Fiscal (es), Tax Identification Number (en)
Language-specific short name. Monolingual short name ES - Tax Identification Number (en)
Informal and comprehensive human-readable definition of a concept. Description The Número de Identificación Fiscal (NIF) is the Spanish tax identification number that everyone with tax obligations must hold. For Spanish nationals it is the number of their national identity document with a check letter, while legal entities carry the corresponding company form, and it must be quoted in all dealings of a tax nature.
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

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/ES NIF/format Validates the format of the Spanish NIF, the tax identification number of natural persons and legal entities, which for Spanish citizens is their national identity number followed by a check letter. The pattern accepts a leading letter or digit, seven digits and a final check digit or letter. IDENTIFIER_FORMAT
^((A|B|C|D|E|F|G|H|J|K|L|M|N|P|Q|R|S|U|V|W|X|Y|Z)|(\d{1}))(\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 (NIF number (Spain))
REPRESENTATIONAL_CONSISTENCY
ES (Spain) The Spanish NIF number consists of eight digits and one checksum letter. This rule checks whether the value is written exactly in its reference format, and any deviation such as a whitespace where none is specified results in a violation. INFO IDEA(2020-01-01)
Identifier format invalid (NIF number (Spain))
REPRESENTATIONAL_CONSISTENCY
ES (Spain) The Spanish NIF identifies both legal and natural persons, for natural persons it is the tax identification number shown on the national identity card.

The NIF has several permitted formats. In the DNI form the first character is either a digit or one of the letters K, L or M. In the NIE form the first character is one of the letters X, Y or Z. In the CIF form the first letter is one of A, B, C, D, E, F, G, H, J, N, P, Q, R, S, U, V or W and the last character, the check digit, can be a digit or a letter, as in Q8350064E.

ERROR RELEASED(2020-01-01)
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)
Invalid checksum of NIF number (Spain)
ACCURACY
ES (Spain) This rule verifies the checksum letter of the Spanish NIF number. The eight digits of the number are divided by 23 and the remainder is translated into a letter according to the reference table defined for the identifier. A NIF whose letter does not match is flagged. ERROR RELEASED(2024-04-16)
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)