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 Tax ID Number (NIF) of the individuals of Spanish nationality will be their DNI (Spanish National ID) followed by the verification code. Every legal person, as well as parties required to pay taxes under Article 35 (4) of General Tax Act 58/2003 of 17th December, shall possess a Tax ID number to be used in any interactions of a tax nature or with a bearing on taxation. NIF format is different for legal entities (then it is a CIF) and natural persons. NIF format for natural persons can have either 8 digits + control letter (equals to DNI) or have letters "K", "L", "M" + 7 digits + control letter (for those who do nt have DNI).
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
0000000000V0ZA49HDQC0NXFGV Specifies the allowed formats for the NIF number (Spain) 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

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 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
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"

RELEASED 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:
RELEASED ERROR