EU_VAT_ID_DE (DE - VAT identification number)
DataModel:CDQ/Business Partner/Identifier/EU VAT ID DE
| Property | Value |
|---|---|
| A technical identifier, unique in a certain context. Technical key | EU_VAT_ID_DE
|
| The country a linked concept is active or generally relevant for. Country scope | DE (Germany) |
| Language-specific name. Monolingual name | Umsatzsteuer-Identifikationsnummer (de), Value added tax identification number (en) |
| Language-specific short name. Monolingual short name | DE - VAT identification number (en) |
| Category of business identifiers. Identifier category | VAT Number |
| Legacy property. A technical SAP code. SAP mapping | STCEG
|
| Registration authority | Federal Ministry of Finance, Bundesfinanzministerium |
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 |
|---|---|---|---|
REGEXP_0137
|
Specifies the allowed formats for the European value added tax identifier (Germany) | IDENTIFIER_FORMAT
|
^(\s*?\.*?-*?)DE(\s*?\.*?-*?)(\d\s*\.*-*){9}$
|
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 | Specifies how critical of the violation of a data quality rule. The following levels are defined:<br/><code>ERROR</code>: The violation (e.g. missing information) puts a process at risk or hinders regular processing of data.<br/><code>WARNING</code>: The violation does not hinder regular processing of data but represents semantically defective data.<br/><code>INFO</code>: The data quality rule has not uncovered a data defect, but some information is available that might be interesting for the user.<br/> Criticality |
|---|---|---|---|
| Identifier Qualification (European value added tax identifier (Germany), 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 (Germany) | LIVE
|
INFO
|
| Identifier Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Identifier Qualification (European value added tax identifier (Germany), 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 (Germany) | LIVE
|
INFO
|
| Identifier format inaccurate (European value added tax identifier (Germany)) | This rule checks the syntax, i.e. format of the European value added tax identifier in Germany with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.
The European value added tax identifier in Germany consists of exact 9 numerical digits prefixed by "DE". 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 (European value added tax identifier (Germany)) | The European value added tax identifier in Germany consists of exact 9 numerical digits prefixed by "DE". This rule checks the existence of exact 9 digits without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more or non-numeric digits the rule is violated. | LIVE
|
ERROR
|
| Identifier missing (European value added tax identifier (Germany)) | Each legal entity in Germany should have a European value added tax identifier. | LIVE
|
WARNING
|
| Identifier unknown (European value added tax identifier (Germany)) | European value added tax identifier (Germany) | LIVE
|
ERROR
|
| Invalid checksum of EU VAT ID DE (Germany) | This rule checks the checksum of the European VAT number in Germany. An interactive procedure involving each of the digits C1…C8 in turn used to calculate C9.
P = 10 For N = 1…8 (N = character position i.e. C1)
R = 11 – P If R = 10 then: C9 = 0 else: C9 =R |
LIVE
|
ERROR
|
| Locality Qualification (European value added tax identifier (Germany), 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 (Germany) | LIVE
|
INFO
|
| Locality Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Locality Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Name Qualification (European value added tax identifier (Germany), 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 (Germany) | LIVE
|
INFO
|
| Name Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Name Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Post code Qualification (European value added tax identifier (Germany), 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 (Germany) | LIVE
|
INFO
|
| Post code Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Post code Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Thoroughfare Qualification (European value added tax identifier (Germany), 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 (Germany) | LIVE
|
INFO
|
| Thoroughfare Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
| |
| Thoroughfare Qualification (European value added tax identifier (Germany), 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 (Germany) | INFO
|