ES (Spain)

From CDQ Wiki
< Business Partner (CDQ) | Address (CDQ) | Country (CDQ)
DataModel:CDQ/Business Partner/Address/Country/ES
Jump to navigation Jump to search
Property Value
A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code ES
Language-specific name. Monolingual name Espainia (eu), Spain (en), España (gl), España (es), Spanien (de), 西班牙 (zh), Espagne (fr), Espanha (oc), Espanya (ca)
Language-specific short name. Monolingual short name 西班牙 (zh), España (es), Spanien (de), Espagne (fr), Spain (en)
The offical langauge of a country. Official language es
Language used in a country, beside the administrative languages. other language es
Continent a country belongs to. Part of Europe

Regions

Region (controlled vocabulary) A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code Language-specific name. Monolingual name
ES-AN (Andalusia) ES-AN Andalosia (oc), Andalousie (fr), Andalucía (es), Andalucía (gl), Andalusia (ca), Andalusia (en), Andalusien (de), Andaluzia (eu), 安達盧西亞 (zh)
ES-AR (Aragon) ES-AR Aragoi (eu), Aragon (en), Aragon (fr), Aragon (oc), Aragonien (de), Aragó (ca), Aragón (es), Aragón (gl), 阿拉贡 (zh)
ES-AS (Asturias) ES-AS Asturias (en), Asturias (es), Asturiasko Printzerria (eu), Asturien (de), Asturies (fr), Astúrias (oc), Astúries (ca), Principado de Asturias (gl), 阿斯图里亚斯 (zh)
ES-CB (Cantabria) ES-CB Autonome Gemeinschaft Kantabrien (de), Cantabria (en), Cantabria (es), Cantabria (gl), Cantabrie (fr), Cantàbria (ca), Cantàbria (oc), Kantabria (eu), 坎塔布里亚 (zh)
ES-CE (Ceuta) ES-CE Ceuta (ca), Ceuta (de), Ceuta (en), Ceuta (es), Ceuta (eu), Ceuta (fr), Ceuta (gl), Ceuta (oc), 休达 (zh)
ES-CL (Castile and León) ES-CL Autonome Gemeinschaft Kastilien und León (de), Castela e León (gl), Castelha e Leon (oc), Castella i Lleó (ca), Castile and León (en), Castilla y León (es), Castille-et-León (fr), Gaztela eta Leon (eu), 卡斯蒂利亚-莱昂 (zh)
ES-CM (Castile-La Mancha) ES-CM Autonome Gemeinschaft Kastilien-La Mancha (de), Castela-A Mancha (gl), Castelha-La Mancha (oc), Castella - la Manxa (ca), Castile-La Mancha (en), Castilla-La Mancha (es), Castille-La Manche (fr), Gaztela-Mantxa (eu), 卡斯蒂利亚-拉曼恰 (zh)
ES-CN (Canary Islands) ES-CN Canarias (es), Canary Islands (en), Illas Canarias (gl), Illas Canàrias (oc), Kanariak (eu), Kanarische Inseln (de), illes Canàries (ca), îles Canaries (fr), 加那利群岛 (zh)
ES-CT (Catalonia) ES-CT Catalogne (fr), Catalonha (oc), Catalonia (en), Catalunya (ca), Cataluña (es), Cataluña (gl), Katalonien (de), Katalunia (eu), 加泰罗尼亚 (zh)
ES-EX (Extremadura) ES-EX Autonome Gemeinschaft Extremadura (de), Estremadura (gl), Estrémadure (fr), Extremadura (ca), Extremadura (en), Extremadura (es), Extremadura (eu), Extremadura (oc), 埃斯特雷马杜拉 (zh)
ES-GA (Galicia) ES-GA Galice (fr), Galicia (en), Galicia (es), Galicia (gl), Galicien (de), Galizia (eu), Galícia (ca), Galícia (oc), 加利西亚 (zh)
ES-IB (Balearic Islands) ES-IB Balear Uharteak (eu), Balearic Islands (en), Balearische Inseln (de), Illas Balearas (oc), Illas Baleares (gl), Illes Balears (ca), Islas Baleares (es), Îles Baléares (fr), 巴利阿里群島 (zh)
ES-MC (Region of Murcia) ES-MC Autonome Gemeinschaft Region Murcia (de), Murtziako Eskualdea (eu), Region de Múrcia (oc), Region of Murcia (en), Regió de Múrcia (ca), Región de Murcia (es), Rexión de Murcia (gl), région de Murcie (fr), 穆尔西亚自治区 (zh)
ES-MD (Community of Madrid) ES-MD Autonome Gemeinschaft Madrid (de), Community of Madrid (en), Comunautat autonòma de Madrid (oc), Comunidad de Madrid (es), Comunidade de Madrid (gl), Comunitat de Madrid (ca), Madrilgo Erkidegoa (eu), communauté de Madrid (fr), 马德里自治区 (zh)
ES-ML (Melilla) ES-ML Melilla (ca), Melilla (de), Melilla (en), Melilla (es), Melilla (eu), Melilla (fr), Melilla (gl), Melilla (oc), 梅利利亚 (zh)
ES-NC (Navarre) ES-NC Nafarroa (eu), Navarra (ca), Navarra (de), Navarra (es), Navarra (gl), Navarra (oc), Navarre (en), Navarre (fr), 納瓦拉 (zh)
ES-PV (Basque Country) ES-PV Autonome Gemeinschaft Baskenland (de), Basque Country (en), Communauté autonome du Pays basque (fr), Comunautat Autonòma Basca (oc), Euskal Autonomia Erkidegoa (eu), País Basc (ca), País Vasco (es), País Vasco (gl), 巴斯克自治區 (zh)
ES-RI (La Rioja) ES-RI A Rioxa (gl), Errioxa (eu), La Rioja (ca), La Rioja (de), La Rioja (en), La Rioja (es), La Rioja (fr), La Rioja (oc), 拉里奥哈 (zh)
ES-VC (Valencian Community) ES-VC Comunidad Valenciana (es), Comunidade Valenciana (gl), País Valencian (oc), País Valencià (ca), Valencian Community (en), Valencianische Gemeinschaft (de), Valentziako Erkidegoa (eu), communauté valencienne (fr), 巴倫西亞自治區 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
ES_0408 (CDQ)ES_0408Sociedad de garantía recíproca (es)SGR (es)
ES_0856 (CDQ)ES_0856European Economic Interest Grouping (es)EEIG (es)
ES_1035 (CDQ)ES_1035Sociedad Anónima (es)S.A. (es)
ES_1755 (CDQ)ES_1755Sociedad Anónima Deportiva (es)S.A.D. (es)
ES_1893 (CDQ)ES_1893Sociedad Cooperativa Europea (es)SCE (es)
ES_2759 (CDQ)ES_2759Sociedad Colectiva Profesional (es)S.R.C.P. (es)
ES_3053 (CDQ)ES_3053Sociedad profesional (es)SP (es)
ES_3088 (CDQ)ES_3088Sociedad Limitada (es)S.L. (es)
ES_3339 (CDQ)ES_3339Sociedad agraria de transformación (es)SAT (es)
ES_3610 (CDQ)ES_3610Sociedad limitada unipersonal (es)S.L.U. (es)
ES_4280 (CDQ)ES_4280Sociedad Colectiva (es)SC (es)
ES_4401 (CDQ)ES_4401Sociedad Anónima Unipersonal (es)S.A.U. (es)
ES_5464 (CDQ)ES_5464Sociedad Anónima Laboral (es)SAL (es)
ES_5599 (CDQ)ES_5599Agrupación de Interés económico (es)AIE (es)
ES_5836 (CDQ)ES_5836Agrupación Europea de Interés Económico (es)AEIE (es)
ES_5898 (CDQ)ES_5898Sociedad Cooperativa (es)S.Coop (es)
ES_6480 (CDQ)ES_6480Sociedad Comanditaria (es)S.Cra. (es)
ES_6919 (CDQ)ES_6919Sociedad Limitada Nueva Empresa (es)S.L.N.E. (es)
ES_7609 (CDQ)ES_7609Sociedad Comanditaria por acciones (es)S. COM. P.A. (es)
ES_8079 (CDQ)ES_8079Sociedad Limitada Laboral (es)S.L.L. (es)
ES_8139 (CDQ)ES_8139Sociedad Comanditaria Simple (es)S. EN C. (es)
ES_8141 (CDQ)ES_8141Sociedad civil profesional (es)S.C.P. (es)
ES_9608 (CDQ)ES_9608Sociedad Anónima Europea o Sociedad Europea (es)SE (es)

Identifiers

IdentifierNameRegistration authority
CIF_ES (CIF number)Certificado de Identificación Fiscal (es)
CIF number (en)		Spanish Tax Administration Agency
ES_IRUS (Unique Registry Identifier of the Company)Identificador Registral Único de la Sociedad (es)
Unique Registry Identifier of the Company (en)
ES_NIE (Tax Identification Number)Numero de Identificacion de Extranjero (es)
Tax Identification Number (en)
ES_NIF (Tax Identification Number)Documento Nacional de Identidad (es)
Número de Identificación Fiscal (es)
Tax Identification Number (en)		Spanish Tax Administration Agency
EU_VAT_ID_ES (Value added tax identification number)Número de Identificación Fiscal (es)
Value added tax identification number (en)		Spanish Tax Administration Agency

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (ES)Regular expression/Not available post code
Regular expression/One digit multiplied several times post code
Regular expression/Ordinal sequence of numbers
Regular expression/Single digit post code
Regular expression/Very long digits post code.
This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for ES (Spain) are the following: Regular expression/Mononumerical post code with delimeter		ERROR
Identifier Qualification (European value added tax identifier (Spain), Data source:AT.FON)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the European value added tax identifier (Spain)INFO
Identifier Qualification (European value added tax identifier (Spain), Data source:BZST)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the European value added tax identifier (Spain)INFO
Identifier Qualification (European value added tax identifier (Spain), Data source:VIES)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the European value added tax identifier (Spain)INFO
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.INFO
Identifier format inaccurate (European value added tax identifier (Spain))This rule checks the syntax, i.e. format of the European value added tax identifier (Spain)INFO
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$INFO
Identifier format inaccurate (Numero de Identificacion de Extranjero (Spain))Numero de Identificacion de Extranjero (Spain) consists of a letter followed by 7 digits and one checksum letter. This rule checks possible whitespaces, hyphens where they are not specified in a reference Numero de Identificacion de Extranjero (Spain)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.
ERROR
Identifier format invalid (European value added tax identifier (Spain))The European value added tax identifier in Spain has different valid formats whereby the identifier is prefixed with "ES". For companies it's either 'ES'+letter+8 digits or 'ES'+letter+7 digits+letter. Where the first letter defines the type of company and the following first 2 digits define the province where the company was registered. The last character is a control digit. For individual people / freelancers, its either 'ES'+8 digits+letter (for Spaniards) or 'ES'+letter+7 digits+letter (for foreigners).ERROR
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"		ERROR
Identifier format invalid (Numero de Identificacion de Extranjero (Spain))NIE identifier in Spain is a sort of NIF for foreigners. NIE has the following format: A-NNNNNNN-A. This rules checks presence of exactly 9 characters with respect to the Numero de Identificacion de Extranjero (Spain).ERROR
Identifier missing (European value added tax identifier (Spain))Each legal entity in Spain should have a European value added tax identifier.INFO
Identifier unknown (European value added tax identifier (Spain))European value added tax identifier (Spain)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
ERROR
Inconsistency of legal form and identifier (NIF number (ES))The first letter of the NIF number (Spain) in Spain indicates the legal formation of the represented entity. This rule checks for any inconsistencies between a given legal form (e.g. as provided in the business partner name) and the first letter of the given NIF number.INFO
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
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

ERROR
Invalid checksum of Numero de Identificacion de Extranjero (Spain)This rule describes the algorithm for checksum digits for Numero de Identificacion de Extranjero (Spain) using the following logic:

To calculate the check digit, each letter is replaced by a number: - replace the first letter accordingly: 

   X → 0
   Y → 1
   Z → 2
- the number (8 digits) is divided by 23
- the remainder is replaced by a letter determined by the following table:		ERROR
Legal form invalid (Spain)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (Spain)This rule checks whether the domestic bank account id exceeds the maximum possible length in SpainERROR
Length of national bank Id invalid (Spain)This rule checks whether the domestic bank id exceeds the maximum possible length in SpainERROR
Locality Qualification (European value added tax identifier (Spain), Data source:AT.FON)This data quality rule checks the congruency of the given city against the city maintained as reference for the European value added tax identifier (Spain)INFO
Locality Qualification (European value added tax identifier (Spain), Data source:BZST)This data quality rule checks the congruency of the given city against the city maintained as reference for the European value added tax identifier (Spain)INFO
Locality Qualification (European value added tax identifier (Spain), Data source:VIES)This data quality rule checks the congruency of the given city against the city maintained as reference for the European value added tax identifier (Spain)INFO
Mandatory administrative area missing (Spain)The administrative area (a top-level geographical or political area division in a country) is required (i.e. mandatory) for a complete physical touchpoint in SpainINFO
Mandatory identifier not maintained (Spain)A business partner in Spain should have at least European value added tax identifier (Spain) or a CIF number (Spain) or a NIF number (Spain). If none of these three is available the record is invalid.ERROR
Mandatory locality missing (Spain)The locality is mandatory for street addresses in Spain.ERROR
Mandatory post code missing (Spain)The post code is mandatory for street addresses in Spain.ERROR
Mandatory thoroughfare missing (Spain)The thoroughfare is mandatory for street addresses in Spain.ERROR
Name Qualification (European value added tax identifier (Spain), Data source:AT.FON)This data quality rule checks the congruency of the given name against the name maintained as reference for the European value added tax identifier (Spain)INFO
Name Qualification (European value added tax identifier (Spain), Data source:BZST)This data quality rule checks the congruency of the given name against the name maintained as reference for the European value added tax identifier (Spain)INFO
Name Qualification (European value added tax identifier (Spain), Data source:VIES)This data quality rule checks the congruency of the given name against the name maintained as reference for the European value added tax identifier (Spain)INFO
Post code Qualification (European value added tax identifier (Spain), Data source:AT.FON)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the European value added tax identifier (Spain)INFO
Post code Qualification (European value added tax identifier (Spain), Data source:BZST)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the European value added tax identifier (Spain)INFO
Post code Qualification (European value added tax identifier (Spain), Data source:VIES)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the European value added tax identifier (Spain)INFO
Post code format invalid (Spain)This rule checks the postcode format of Spain. Postal codes (Código Postal) in Spain consist of a block of 5 digits which should be placed before the town name on the last line of the address. The first two digits of the postal code, ranging from 01 to 52, indicate the province. The third digit indicates a place within the province. If this digit is 0, the address is in the capital of the province, if it is 1 it is in the vicinity of the capital, and so on. The higher this number, the further the address is from the region’s capital. The last two digits are split into three ranges of numbersERROR
Thoroughfare Qualification (European value added tax identifier (Spain), Data source:AT.FON)This data quality rule checks the congruency of the given street against the street maintained as reference for the European value added tax identifier (Spain)INFO
Thoroughfare Qualification (European value added tax identifier (Spain), Data source:BZST)This data quality rule checks the congruency of the given street against the street maintained as reference for the European value added tax identifier (Spain)INFO
Thoroughfare Qualification (European value added tax identifier (Spain), Data source:VIES)This data quality rule checks the congruency of the given street against the street maintained as reference for the European value added tax identifier (Spain)INFO
Unallowed pattern in name detected (ES)Regular expression/Aggregated payments
Regular expression/No new orders
Regular expression/Do not use duplicates note
Regular expression/Reference to other record
Regular expression/No use note
Regular expression/Reference to new record
Regular expression/Reference the former name
Regular expression/Long number in name
Regular expression/Duplicate record note
Regular expression/Dummy record note
Regular expression/Sequence of digits
Regular expression/Unsorted keywords
Regular expression/Length of name .
This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for ES (Spain) are the following: Regular expression/One time vendor		WARNING

Data sources

Data quality ruleNameContent
AT.FON (data source)FinanzOnline Austria (en)BUSINESS_PARTNER
BZST (data source)Federal Central Tax Office (Germany) (en)
Bundeszentralamt für Steuern (Germany) (en)		BUSINESS_PARTNER
CDQ.VAT (data source)CDQ European VAT Registration Database (en)BUSINESS_PARTNER
ES.BR (data source)Spanish Register of Companies (en)
Registradores de Espana (de)		BUSINESS_PARTNER
ES.COR (data source)Correos (Spain) (en)ADDRESS
ES.CR (data source)Correos (en)ADDRESS
ES.GBR (data source)GBR direct (en)
EU.EORI (data source)Economic Operator Identification and Registration Database (en)BUSINESS_PARTNER
EU.PC (data source)EuroStat Post Code Files (European Union) (en)ADDRESS
VIES (data source)VAT Information Exchange System (en)BUSINESS_PARTNER

Banking metadata

Property Value
Full metadata Bank accounts in Spain
Local name of the national bank ID. Bank ID name Oficinas Entidades Financieras - OEF
The provider (national authorities in most cases) of the national bank ID. Bank ID provider De Cooperacion Interbancaria via CTI (Calculo y Tratamiento de la Informacion) S.A
Currency code for accounting in the given country. Currency code EUR
Maximum length of the national bank ID. Maximum bank ID length 8
Maximum length of the national bank account ID. Maximum bank account ID length 10
Retrieved from "https://meta.cdq.com/w/index.php?title=DataModel:CDQ/Business_Partner/Address/Country/ES&oldid=73937"