European value added tax identifier (The Netherlands)
Jump to navigation
Jump to search
Technical key Defines a unique key by which e.g. data model concepts can be referenced in a technical integration context. These keys are unique in the CDL context. | EU_VAT_ID_NL
|
---|---|
Country scope Defines a address/country a given concept is used in (or valid in, or relevant for etc.), i.e. the country-specific scope of a concept. | NL |
Monolingual name Language-specific name of a data model concept or concept value. | Omzetbelastingnummer (nl) |
Monolingual short name Language-specific short name of a data model concept or concept value. | NL - VAT identification number (en) |
International name Defines the name of a concept in English with Latin characters, e.g. if the major name of a concept is defined in a local language. | Value added tax identification number |
Alternative name Alternative (i.e. synonymous) name of a concept. | n/a |
Abbreviation Language-specific abbreviation of a data model concept or concept value. | VAT (en), BTW (nl) |
Description Informal and comprehensive human-readable definition of a concept. | The Dutch VAT identifier is issued by the Belastingdienst (Dutch Tax and Customs Administration) and is required for VAT compliance in EU cross-border transactions.
Format: NL999999999B99 (12 characters). The first 9 digits are the company’s RSIN or BSN (tax ID), and 'B99' is a suffix used for VAT identification. Check Digit Logic: The first 9 digits are verified using a modulus 11 system. |
Applies to Describes what kind of entities are assigned the identifier at hand | Legal Entity |
Release status The release status in terms of development progress or maturity of a product feature or a business capability.<br/><code>EMPTY</code> (0): No feature considered yet, just rough idea for capability.<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; nonetheless, we continue to offer the most recent available data. | LIVE
|
Issuing body The authority that publishes data or is responsible for its content | missing |
Identifier category Categories of identification numbers | VAT Number |
Mappings | mapping source: uid (AT.FON), mapping: AT.FON uid (NL) ↣ IDENTIFIER_VALUE mapping source: STCEG (SAP.FLAT), mapping: SAP.FLAT STCEG (NL) ↣ IDENTIFIER_VALUE mapping source: vatNumer (VIES), mapping: VIES vatNumer (NL) ↣ IDENTIFIER_VALUE
|
Formal definition[edit]
Description | Regular expression | Type | |
---|---|---|---|
Regular expression/EU VAT ID NL/format | Specifies the allowed formats for the European value added tax identifier (The Netherlands) | ^(\s*?\.*?-*?)NL(\d\s*\.*-*){9}B(\d\s*\.*-*){2}$ | IDENTIFIER_FORMAT |
Data quality rules[edit]
Business rule | Description | Status | Criticality |
---|---|---|---|
Identifier Qualification (European value added tax identifier (The Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Identifier Qualification (European value added tax identifier (The Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Identifier Qualification (European value added tax identifier (The Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Identifier format inaccurate (European value added tax identifier (The Netherlands)) | This rule checks the syntax, i.e. format of the European value added tax identifier in the Netherlands 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 Netherlands consists of the prefix "NL", followed by 9 numerical digits + the character "B" + 2 numerical digits. 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 (The Netherlands)) | The European value added tax identifier in Netherlands consists of the prefix "NL", followed by 9 numerical digits + the character "B" + 2 numerical digits. This rule checks the presence of exact 12 ciphers including a letter "B" on a right place according to this scheme without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. | RELEASED | ERROR |
Identifier missing (European value added tax identifier (The Netherlands)) | Each legal entity in The Netherlands should have a European value added tax identifier. | RELEASED | INFO |
Identifier unknown (European value added tax identifier (The Netherlands)) | European value added tax identifier (The Netherlands) | RELEASED | ERROR |
Inconsistency between RSIN and European value added tax identifier (The Netherlands) | The 9 digits following the "NL"-prefix are the RSIN. This rules check if the 9 digits following the "NL" in EU_VAT_ID_BE are equal to RSIN. Any difference result in a rule violation. | RELEASED | ERROR |
Invalid checksum of EU VAT ID NL (The Netherlands) | This rule checks the checksum of the European VAT number in The Netherlands. The checksum validation is done following modulo 11:
| RELEASED | ERROR |
Locality Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Locality Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Locality Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Mandatory identifier not maintained (Netherlands) | A business partner in the Netherlands should have at least an European value added tax identifier (The Netherlands) or a KVK number (Netherlands). If none of these two is available the record is invalid. | RELEASED | ERROR |
Name Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Name Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Name Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Post code Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Post code Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Post code Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Thoroughfare Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Thoroughfare Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |
Thoroughfare Qualification (European value added tax identifier (Netherlands), 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 (The Netherlands) | RELEASED | INFO |