EU_VAT_ID_UK (UK - VAT identification number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/EU VAT ID UK
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key EU_VAT_ID_UK
The country a linked concept is active or generally relevant for. Country scope GB (United Kingdom of Great Britain and Northern Ireland)
Language-specific name. Monolingual name Value added tax identification number (en)
Language-specific short name. Monolingual short name UK - VAT identification number (en)
Informal and comprehensive human-readable definition of a concept. Description The value added tax identification number of the United Kingdom was its European VAT identifier until the country left the European Union, after which it lost that function. It is kept in reference data so that historical records carrying such a number can still be interpreted, while current British VAT numbers are handled as a national identifier.
Category of business identifiers. Identifier category Tax 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
Regular expression/EU VAT ID UK/format Validates the format of the British VAT registration number, which was the European VAT identifier of the United Kingdom until it left the European Union and is still issued by HM Revenue and Customs. The pattern accepts the prefix GB followed by the standard nine or twelve digit number or by the special series for government departments and health authorities. IDENTIFIER_FORMAT
GB((GD[0-4]\d{2})|(HA[5-9]\d{2})|(\d{3}\s?\d{4}\s?(\d{2}|\d{5})))$

Data quality rules

Data quality rule The country a linked concept is active or generally relevant for. Country scope Informal and comprehensive human-readable definition of a concept. Description 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 Rule release status<br/>The release status in terms of development progress or maturity of a data quality rule.<br/>IDEA: Initial rule definition that documents a business requirement but is not yet active in services.<br/>PLANNED: Rule is specified and scheduled for implementation, but not yet active in services.<br/>DRAFT: Rule concept is being prepared or refined but is not yet finalized for implementation or execution.<br/>HYPERCARE: Rule is newly released and under increased observation to ensure stable behaviour and correct results.<br/>RELEASED: Rule has passed verification and is actively executed in productive CDQ services.<br/>DEACTIVATED: Rule is temporarily removed from the active rule set because it needs correction or clarification before re release.<br/>BLOCKED: Rule cannot be released because something it depends on is missing, for example a data source or a clarification.<br/>ARCHIVED: Rule is permanently retired and no longer maintained or intended for future activation. Rule release status
Deprecated identifier found (European value added tax identifier (United Kingdom))
ACCURACY
GB (United Kingdom of Great Britain and Northern Ireland) This rule detects business partners that still carry a British European value added tax identifier. Such identifiers are no longer valid since Brexit. INFO RELEASED(2024-04-16)
Identifier format inaccurate (European value added tax identifier (United Kingdom))
REPRESENTATIONAL_CONSISTENCY
GB (United Kingdom of Great Britain and Northern Ireland) This rule checks whether the European value added tax identifier of the United Kingdom is written exactly in its reference format, any deviation, such as a whitespace where none is specified, results in a violation.

The identifier is the code GB followed by one of four patterns: the standard form of nine digits, written as a block of three, a block of four and a block of two, for example GB999 9999 73, the branch trader form of twelve digits, that is the nine-digit form followed by a further block of three digits, the government department form of the letters GD and three digits from 000 to 499, for example GBGD001, and the health authority form of the letters HA and three digits from 500 to 999, for example GBHA599. The rule flags any whitespace, hyphen or dot in the value.

INFO ARCHIVED(2020-01-01)
Identifier format invalid (European value added tax identifier (United Kingdom))
REPRESENTATIONAL_CONSISTENCY
GB (United Kingdom of Great Britain and Northern Ireland) This rule checks the format of the European value added tax identifier of the United Kingdom, which is the country code GB followed by one of several patterns. The standard pattern is nine digits, written as a block of three, a block of four and a block of two, for example GB999 9999 73. Branch traders use twelve digits, that is the nine-digit form followed by a further block of three digits. Government departments use the letters GD followed by three digits from 000 to 499, for example GBGD001, and health authorities use the letters HA followed by three digits from 500 to 999, for example GBHA599.

For the nine-digit scheme the rule requires exactly nine digits and no non-digit characters. For the short scheme the digits after the GD prefix must lie between 000 and 499, and the digits after the HA prefix between 500 and 999.

INFO RELEASED(2020-01-01)
Identifier missing (European value added tax identifier (United Kingdom))
COMPLETENESS
GB (United Kingdom of Great Britain and Northern Ireland) Every legal entity in the United Kingdom is expected to hold a European value added tax identifier. This rule reports records in which the identifier is absent. INFO ARCHIVED(2021-07-01)
Identifier unknown (European value added tax identifier (United Kingdom))
ACCURACY
GB (United Kingdom of Great Britain and Northern Ireland) European VAT identifiers of the United Kingdom are exchanged through VIES, the central VAT Information Exchange System provisioned by the European Commission. This rule checks whether the British VAT identifier is known to that system, if it is not available there, the identifier is treated as invalid and the rule is violated. ERROR ARCHIVED(2020-01-01)
Invalid checksum of EU VAT ID UK (United Kingdom)
ACCURACY
GB (United Kingdom of Great Britain and Northern Ireland) This rule verifies the checksum of the European VAT number in the United Kingdom. For the standard nine-character format the eighth and ninth digits are the check digits.

R1 is the remainder, modulo 97, of 8 times C1 plus 7 times C2 plus 6 times C3 plus 5 times C4 plus 4 times C5 plus 3 times C6 plus 2 times C7 plus the two-digit value formed by C8 and C9. R2 is the same expression with 55 added, again modulo 97. Either R1 or R2 must be zero for the number to be valid.

Two restrictions apply to the ranges of the identifier. For the MOD97 variant the number must not fall in the ranges 0100000 to 0999999, 9490001 to 9700000 or 9990001 to 9999999. For the MOD9755 variant it must not fall in the ranges 0000001 to 0100000 or 0100001 to 1000000.

ERROR ARCHIVED
Mandatory identifier not maintained (United Kingdom)
COMPLETENESS
GB (United Kingdom of Great Britain and Northern Ireland) A business partner in the United Kingdom should carry at least one of three identifiers: the British European value added tax identifier, which is still supported for now, the British VAT registration number or the British company registration number. If none of the three is available, the record is invalid. ERROR RELEASED(2024-04-16)