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)
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1
Registration authority Spanish Tax Administration Agency

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
REGEXP_0127 Specifies the allowed formats for the NIF number (Spain) IDENTIFIER_FORMAT ^((A
REGEXP_0128 Spanish natural persons (DNI): 8 digits + 1 control letter (format: 99999999L)

Non-resident Spaniards without DNI: letter L + 7 digits + 1 control letter (format: L9999999L)

Foreigners with NIE: letter X or Y or Z + 7 digits + 1 control letter (format: X or Y or Z 9999999)

Foreigners without NIE: letter M + 7 digits + 1 control letter (format: M9999999L)

NATURAL_PERSON_IDENTIFICATION ^(\d{8}

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. Description nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status Specifies how critical of the violation of a data quality rule. The following levels are defined:<br/><code>ERROR</code>: The violation (e.g. missing information) puts a process at risk or hinders regular processing of data.<br/><code>WARNING</code>: The violation does not hinder regular processing of data but represents semantically defective data.<br/><code>INFO</code>: The data quality rule has not uncovered a data defect, but some information is available that might be interesting for the user.<br/> Criticality
Identifier format inaccurate (NIF number (Spain)) NIF number (Spain) consists of 8 digits and one checksum letter. This rule checks possible whitespaces, hyphens where they are not specified in a reference \w)\d\w$ IDEA INFO
Identifier format invalid (NIF number (Spain)) NIF identifier is used for spanish legal and natural perosns. For natural perosns this is a TIN number which stays on the National Identity Card.

The NIF has multiple allowed formats: DNI: can have first character a digit OR a letter 'KLM'(one of those) NIE: first character contains "XYZ"(one of those) CIF: first letter contains "ABCDEFGHJNPQRSUVW"(one of those) and the last character (the checkdigit) can be a digit or alphabetic, like here "Q8350064E"

LIVE ERROR
Invalid checksum of NIF number (Spain) This rule describes the algorithm for checksum digits for NIF number (Spain) using the following logic:
  • the number (8 digits) is divided by 23,
  • the remainder is replaced by a letter determined by the following table:

File:NIF.PNG

LIVE ERROR