EU_VAT_ID_NL (NL - VAT identification number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/EU VAT ID NL
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key EU_VAT_ID_NL
The country a linked concept is active or generally relevant for. Country scope NL (Netherlands)
Language-specific name. Monolingual name Omzetbelastingnummer (nl), Value added tax identification number (en)
Language-specific short name. Monolingual short name NL - VAT identification number (en)
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
REGEXP_0153 Specifies the allowed formats for the European value added tax identifier (The Netherlands) IDENTIFIER_FORMAT ^(\s*?\.*?-*?)NL(\d\s*\.*-*){9}B(\d\s*\.*-*){2}$

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 (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) LIVE 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) LIVE 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) LIVE 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. LIVE ERROR
Identifier missing (European value added tax identifier (The Netherlands)) Each legal entity in The Netherlands should have a European value added tax identifier. LIVE INFO
Identifier unknown (European value added tax identifier (The Netherlands)) European value added tax identifier (The Netherlands) LIVE 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:
  • A1 = C1*9 + C2*8 + C3*7 + C4*6 + C5*5 + C6*4 + C7*3 + C8*2
  • A2 = A1 modulo 11
  • If A2 = 10:
    • then number is invalid
    • else C9 = A2
LIVE 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) LIVE 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) LIVE 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) LIVE 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. LIVE 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) LIVE 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) LIVE 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) LIVE 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) LIVE 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) LIVE 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) LIVE 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) LIVE 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) LIVE 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) LIVE INFO