European value added tax identifier (United Kingdom)

From CDQ
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_UK
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. GB
Monolingual name Language-specific name of a data model concept or concept value. Value added tax identification number (en)
Monolingual short name Language-specific short name of a data model concept or concept value. UK - 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. n/a
Description Informal and comprehensive human-readable definition of a concept. Deprecated European value added tax identifier of United Kingdom.
Applies to Describes what kind of entities are assigned the identifier at hand n/a
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 Tax Number
Mappings mapping source: STCEG (SAP.FLAT), mapping: SAP.FLAT STCEG (GB) ↣ IDENTIFIER_VALUE

Formal definition[edit]

 DescriptionRegular expressionType
Regular expression/EU VAT ID UK/formatSpecifies the allowed formats for the European value added tax identifier (United Kingdom)
GB((GD[0-4]\d{2})|(HA[5-9]\d{2})|(\d{3}\s?\d{4}\s?(\d{2}|\d{5})))$
IDENTIFIER_FORMAT

Data quality rules[edit]

Business ruleDescriptionStatusCriticality
Deprecated identifier found (European value added tax identifier (United Kingdom))This rule checks whether there is still a European value added tax identifier (United Kingdom) maintained. These identifiers are no longer valid since the Brexit.RELEASEDINFO
Identifier format inaccurate (European value added tax identifier (United Kingdom))This rule checks the syntax, i.e. format of the European value added tax identifier (United Kingdom) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

European value added tax identifier (United Kingdom) consists of code GB followed by either:

  • A) standard: 9 digits (block of 3, block of 4, block of 2 – e.g. GB999 9999 73),
  • B) branch traders: 12 digits (as for 9 digits, followed by a block of 3 digits),
  • C) government departments: the letters GD then 3 digits from 000 to 499 (e.g. GBGD001)
  • D) health authorities: the letters HA then 3 digits from 500 to 999 (e.g. GBHA599)
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.
ARCHIVEDINFO
Identifier format invalid (European value added tax identifier (United Kingdom))This rule checks the format of European value added tax identifier (United Kingdom). Country code GB followed by either:

standard: 9 digits (block of 3, block of 4, block of 2 – e.g. GB999 9999 73) branch traders: 12 digits (as for 9 digits, followed by a block of 3 digits) government departments: the letters GD then 3 digits from 000 to 499 (e.g. GBGD001) health authorities: the letters HA then 3 digits from 500 to 999 (e.g. GBHA599)

For the 9-digit scheme the rules checks presence of exactly 9 digits without any non-digit characters.

For the short scheme (government departments and health authorities) the rules has the following restrictions:

  • for prefix "GD": 3 digits after the prefix should be from 000 to 499;
  • for prefix "HA": 3 digits after the prefix should be from 500 to 999.
RELEASEDINFO
Identifier missing (European value added tax identifier (United Kingdom))Each legal entity in the United Kingdom should have a European value added tax identifier.ARCHIVEDINFO
Identifier unknown (European value added tax identifier (United Kingdom))United Kingdom European VAT IDs are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether the United Kingdom EU VAT ID is known to this central exchange system. If it is not available, the identifier is treated as invalid and the data quality rule is violated.ARCHIVEDERROR
Invalid checksum of EU VAT ID UK (United Kingdom)This rule checks the checksum of the European VAT number in the United Kingdom. For the standard identifier format (9 characters) validation of the 8th and 9th checksum digits follows the logic:
  • R1 = (8*C1 + 7*C2 + 6*C3 + 5*C4 + 4*C5 + 3*C6 + 2*C7 + C8C9) modulo 97
  • R2 = ((8*C1 + 7*C2 + 6*C3 + 5*C4 + 4*C5 + 3*C6 + 2*C7 + C8C9) + 55) modulo 97
  • Either R1 or R2 must equal to zero.

The following restrictions should be considered:

MOD97 (R1):

  • Not in 0100000...0999999
  • Not in 9490001...9700000
  • Not in 9990001...9999999

MOD9755 (R2):

  • Not in 0000001...0100000
  • Not in 0100001...1000000
ARCHIVEDERROR
Mandatory identifier not maintained (United Kingdom)A business partner in the United Kingdom should have at least a European value added tax identifier (United Kingdom) (still supported for now), a VAT registration number (United Kingdom) or a Company registration number (United Kingdom). If none of these three is available the record is invalid.RELEASEDERROR