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 This is the tax ID number for all companies. CIF number consists of a letter (ussually A or B) followed by 8 digits (or 7 digits + letter for foreign companies).

The letter at the beginning of CIF represents the type of company, the most common being an 'A' for Sociedad Anónima or a 'B' for Sociedad Limitada.

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
00000000007Y0C2QRAFHVGTZR5 Specifies the allowed formats for the CIF number (Spain) 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

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 (CIF number (Spain)) This rule checks the syntax, i.e. format of the CIF number in Spain with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

CIF number (Spain) consists of a letter followed by 8 digits or by 7 digits and a letter. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots then the rule is violated.

IDEA INFO
Identifier format invalid (CIF number (Spain)) Certificado de Identificación Fiscal consists of 9 alphanumeric characters:
  • a letter followed by 8 digits

or:

  • a letter followed by 7 digits + 1 letter.

The structure following:

T P P N N N N N C

Being:

  • T: Organization type letter (1 alpha/letter digit) indicates the type of the organization, for example, A for Public Limited company or B for Limited Liability Company.
  • P: Provincial Code (2 numerical digits), correspond to an identifier of the geographical Spanish province in which the organization’s headquarters of the company is located. For example 28 for Madrid or 58 for Barcelona.
  • N: Sequential numbering ( 5 numerical digits) within province determined for letters P in the previous point.
  • C: Control digit (1 digit, letter or numerical).

Meaning of the first letter:

  • A Sociedad Anónima
  • B Sociedad de Responsabilidad Limitada
  • C Sociedades Colectivas
  • D Sociedades Comanditarias
  • E Comunidades de Bienes
  • F Sociedades Cooperativas
  • G Asociaciones
  • H Comunidades de propietarios en régimen de propiedad horizontal
  • J Sociedades civiles con o sin personalidad jurídica
  • P Corporaciones Locales)
  • Q Organismos Autónomos
  • R Congregaciones e instituciones religiosas
  • S Órganos de la administración del estado y de las Comunidades Autónomas
  • U Uniones Temporales de Empresas
  • V – Otros tipos no definidos en el resto de claves.
RELEASED ERROR
Inconsistency between CIF ES and EU VAT ID 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
RELEASED ERROR
Invalid checksum of CIF number (Spain) This rule describes the algorithm for checksum letter for CIF number (Spain) using the following logic:
  • 1) sum up the 7 digits of the CIF identifier --> Summa A,
  • 2) for each of the digits of the odd positions, multiply the digit by 2 and add the result numbers, but if the result has a single digit simply this figure is added. (ie if the digit is 6, the result would be 6 x 2 = 12 -> 1 + 2 = 3, more if the digit is 2, the result would be 2 x 2 = 4). --> Summa = B

,

  • 3) add the result of the previous 2 steps. --> A + B = C
  • 4) the last digit of the previous sum (C) is subtracted to 10, whose result would be the control code:
    • if C = 14, the last digit is 4, so we would have 10 - 4 = 6.
    • if the last digit of the previous step sum is 0 (eg C = 30), subtraction is not performed and 0 is taken as the control code
RELEASED ERROR