EU_VAT_ID_ES (ES - VAT identification number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/EU VAT ID ES
Jump to navigation Jump to search
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