EU_VAT_ID_ES (ES - VAT identification number)
DataModel:CDQ/Business Partner/Identifier/EU VAT ID ES
| Property | Value |
|---|---|
| A technical identifier, unique in a certain context. Technical key | EU_VAT_ID_ES
|
| The country a linked concept is active or generally relevant for. Country scope | ES (Spain) |
| Language-specific name. Monolingual name | Número de Identificación Fiscal (es), Value added tax identification number (en) |
| Language-specific short name. Monolingual short name | ES - VAT identification number (en) |
| Informal and comprehensive human-readable definition of a concept. Description | The Spanish VAT identifier is issued by the Agencia Estatal de Administración Tributaria (AEAT) and is used for VAT reporting in cross-border transactions within the EU. It applies to both individuals and businesses involved in trade.
Format: ESX9999999X (9 characters, where the first and last characters can be letters). Check Digit Logic: The first letter represents the type of entity (e.g., businesses), and the last character is a check letter calculated using a modulus 23 check. |
| Category of business identifiers. Identifier category | VAT Number |
| Legacy property. A technical SAP code. SAP mapping | STCEG
|
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 |
|---|---|---|---|
| 00000000004ZY1RHNDJEBF41QP | Specifies the allowed formats for the European value added tax identifier (Spain) | IDENTIFIER_FORMAT
|
^ES(\w{1}|\d{1})\d{7}(\w{1}|\d{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 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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
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) | IDEA
|
INFO
|
| 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). |
RELEASED
|
ERROR
|
| Identifier missing (European value added tax identifier (Spain)) | Each legal entity in Spain should have a European value added tax identifier. | RELEASED
|
INFO
|
| Identifier unknown (European value added tax identifier (Spain)) | European value added tax identifier (Spain) | RELEASED
|
ERROR
|
| 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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
INFO
|
| 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. | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
INFO
|
| 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) | RELEASED
|
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) | RELEASED
|
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) | RELEASED
|
INFO
|