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 España (es), Espagne (fr), España (gl), Spain (en), Espainia (eu), Espanha (oc), Espanya (ca), Spanien (de), 西班牙 (zh)
Language-specific short name. Monolingual short name Spanien (de), Espagne (fr), Spain (en), España (es), 西班牙 (zh)
The offical langauge of a country. Official language es
Language used in a country, beside the administrative languages. other language fr, en
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 Language-specific alternative, i.e. non-official, name. Alternative 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) Andalucia (en)
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) Principality of Asturias (en)
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) Autonomous City of Ceuta (en)
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) Castilla and Leon (en)
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) Castille-La Mancha (en)
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) Islas Canarias (es)
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) Murcia Region (en)
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) Autonomous City of Melilla (en)
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) VALENCIA (en)

Legal forms

Legal formNameMain abbreviationdescriptionCategory
ES_0408 (CDQ)Sociedad de garantía recíproca (es)SGR (es)Association Global Data Packet
ES_0856 (CDQ)European Economic Interest Grouping (es)EEIG (es)Economic Interest Group
ES_1035 (CDQ)Sociedad Anónima (es)S.A. (es)Society
ES_1755 (CDQ)Sociedad Anónima Deportiva (es)S.A.D. (es)Insurance Company
ES_1893 (CDQ)Sociedad Cooperativa Europea (es)SCE (es)International Organization
ES_2759 (CDQ)Sociedad Colectiva Profesional (es)S.R.C.P. (es)De-facto Partnership
ES_3053 (CDQ)Sociedad profesional (es)SP (es)De-facto Partnership
ES_3088 (CDQ)Sociedad Limitada (es)S.L. (es)Private Limited Company
ES_3339 (CDQ)Sociedad agraria de transformación (es)SAT (es)Agricultural Collective Interest Company
ES_3610 (CDQ)Sociedad limitada unipersonal (es)S.L.U. (es)Private Limited Company
ES_4280 (CDQ)Sociedad Colectiva (es)SC (es)General Partnership
ES_4401 (CDQ)Sociedad Anónima Unipersonal (es)S.A.U. (es)Society
ES_5464 (CDQ)Sociedad Anónima Laboral (es)SAL (es)Government Agency
ES_5599 (CDQ)Agrupación de Interés económico (es)AIE (es)Economic Interest Group
ES_5836 (CDQ)Agrupación Europea de Interés Económico (es)AEIE (es)Economic Association
ES_5898 (CDQ)Sociedad Cooperativa (es)S.Coop (es)Civil Company
ES_6480 (CDQ)Sociedad Comanditaria (es)S.Cra. (es)Commandite Partnership
ES_6919 (CDQ)Sociedad Limitada Nueva Empresa (es)S.L.N.E. (es)Private Limited Company
ES_7609 (CDQ)Sociedad Comanditaria por acciones (es)S. COM. P.A. (es)Limited Cooperative Company
ES_8079 (CDQ)Sociedad Limitada Laboral (es)S.L.L. (es)Private Limited Company
ES_8139 (CDQ)Sociedad Comanditaria Simple (es)S. EN C. (es)Collective Name Company
ES_8141 (CDQ)Sociedad civil profesional (es)S.C.P. (es)Civil Company
ES_9608 (CDQ)Sociedad Anónima Europea o Sociedad Europea (es)SE (es)Societas Europaea

Identifiers

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

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (ES)This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/ES are the following: Regular expression/Mononumerical post code with delimeter
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.		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:
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)This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/ES are the following: Regular expression/One time vendor
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 .		WARNING

Data sources

Data source An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short 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
[[AT.FON (data source)]]
FinanzOnline
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		Allows to verify the validity of a VAT number issued by any European Member State. LIVE
[[BZST (data source)]]
Bundeszentralamt für Steuern (Germany)
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		Verifies the validity of the VAT number. LIVE
[[EU.EORI (data source)]]
EORI
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		EORI number is used as an identification number in all customs procedures when exchanging information with Customs administrations. LIVE
1,064 records
[[VIES (data source)]]
VIES
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		Official interface to the European MIAS database. LIVE
50,000,000 records
[[CDQ.VAT (data source)]]
CDQ VAT Numbers
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		European VAT numbers with registrant names and addresses, collected by CDQ from public websites. IDEA
[[ES.COR (data source)]]
Correos (Spain)
[[ADDRESS]]A fatal error occurred in the #info parser function 		n/a IDEA
[[ES.CR (data source)]]
Correos
[[ADDRESS]]A fatal error occurred in the #info parser function 		n/a IDEA
[[ES.GBR (data source)]]
GBR direct 		n/a IDEA
[[EU.PC (data source)]]
EuroStat Post Code Files (European Union)
[[ADDRESS]]A fatal error occurred in the #info parser function 		n/a IDEA
[[ES.BR (data source)]]
Spanish Business Register
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function 		Registradores de España is the official organization of property and commercial registrars in Spain DISCONTINUED
221,284 records

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