GB (United Kingdom of Great Britain and Northern Ireland)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/GB
Jump to navigation Jump to search
Property Value
A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code GB
Language-specific name. Monolingual name 英国 (zh), United Kingdom of Great Britain and Northern Ireland (en), Vereinigtes Königreich (de), Royaume-Uni de Grande-Bretagne et d'Irlande du Nord (fr)
Language-specific short name. Monolingual short name Großbritannien (de), 英国 (zh), Royaume-Uni (fr), United Kingdom (en)
The offical langauge of a country. Official language en
Language used in a country, beside the administrative languages. other language fr
Continent a country belongs to. Part of Europe

Regions

Region (controlled vocabulary) A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code Language-specific name. Monolingual name Language-specific alternative, i.e. non-official, name. Alternative name
GB-ENG (England) GB-ENG Angleterre (fr), England (de), England (en), 英格兰 (zh)
GB-NIR (Northern Ireland) GB-NIR Irlande du Nord (fr), Nordirland (de), Northern Ireland (en), 北爱尔兰 (zh)
GB-SCT (Scotland) GB-SCT Schottland (de), Scotland (en), Écosse (fr), 蘇格蘭 (zh) Scotland (en)
GB-WLS (Wales) GB-WLS Wales (de), Wales (en), pays de Galles (fr), 威爾斯 (zh)

Legal forms

Legal formNameMain abbreviationdescriptionCategory
EU Association (en)
Societas Europaea (la)
SE (en)Association Global Data Packet
Cyfyngedig (cy)
Private Limited Company (en)
Pvt. Ltd. (en)Private Limited Company
Limited Liability Partnership (en)
Partneriaeth Atebolrwydd Cyfyngedig (cy)
LLP (en)Partnership
Charitable Incorporated Organisation (en)CIO (en)Society
Scottish Charitable Incorporated Organisation (en)SCIO (en)Society
United Kingdom Societas (en)UKS (en)Economic Interest Group
Private Unlimited Company (en)Private Unlimited Company
Royal Charter Company (en)Unknown
Industrial and Provident Society (en)IPS (en)Society
Other company type (en)Unknown
Protected Cell Company (en)PCC (en)Unknown
Investment Company with Variable Capital (en)ICVC (en)Investment Company
United Kingdom Economic Interest Grouping (en)UKEIG (en)Economic Interest Group
Registered Society (en)Society
Old Public Company (en)Public Company
Scottish Partnership (en)General Partnership
Public Limited Company (en)PLC (en)Public Limited Company
Converted/Closed (en)Unknown
Societas Cooperativa Europaea (en)SCE (en)Societas Europaea
General partnership (en)GP (en)General Partnership
Limited partnership (en)LP (en)Limited Partnership
Sole proprietorship (en)SP (en)Sole Proprietorship
European Economic Interest Grouping (en)EEIG (en)Economic Interest Group
Private company limited by shares (en)Ltd. (en)Private Company Limited by Shares
Community interest company (en)CIC (en)Social Enterprise

Identifiers

IdentifierNameRegistration authority
EU_VAT_ID_UK (UK - VAT identification number)Value added tax identification number (en)
ID_CRN (ID - Company Reg. number)Company registration number (en)
ID_UTR (UK - National tax number)Unique taxpayer reference number (en)
ID_VAT_UK (UK - VAT registration number)Value added tax registration number (en)
UK_CON (UK - Charity Organisation Number)Charity Organisation Number (en)
UK_DRV_LIC (UK - Drv lic number)Driver's Licence Number (en)
UK_IN_ID (UK - NI number)NI number (en)
UK_NHS_ID (UK - Nat hlth id)National Health Service Number (en)
UK_RCN (UK - Registered charity number)Registered charity number (en)
WR_BTRN (GB - Board of Trade Reg. Num.)Board of Trade Registration Number (en)

Data quality rules

Data quality ruleDescriptionCriticality
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.INFO
Dummy post code detected (GB)This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/GB are the following: Regular expression/Mononumerical post code with delimeter
Regular expression/Not available post code
Regular expression/One digit multiplied several times post code
Regular expression/Ordinal sequence of numbers
Regular expression/Single digit post code
Regular expression/Very long digits post code.
ERROR
Identifier Qualification (EORI number (United Kingdom), Data source:UK.EORI)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the EORI numberINFO
Identifier Qualification (VAT registration number (United Kingdom), Data source:UK.VAT)This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the VAT registration number (United Kingdom)INFO
Identifier format inaccurate (Company registration number (United Kingdom))This rule checks the syntax, i.e. Company registration number (United Kingdom) The first 2 characters can be:
  • Companies formed in England and Wales have CRNs beginning with 0 (zero)
  • AC - Assurance Company England and Wales


  • FC - Foreign Company England and Wales


  • GE - European Economic Interest Grouping (EEIG) England and Wales


  • GN - EEIG Northern Ireland


  • GS - EEIG Scotland


  • IC - Investment Company with Variable Capital (ICVC) England and Wales


  • IP - Industrial and Provident England and Wales


  • LP - Limited Partnership England and Wales


  • NA - Assurance Company Northern Ireland


  • NF - Foreign Company Northern Ireland


  • NI - Northern Ireland Company


  • NL - Limited Partnership Northern Ireland (This prefix is not applicable to CT and should not be used)


  • NO - Other Northern Ireland


  • NP - Industrial and Provident Northern Ireland


  • NR - Royal Charter Northern Ireland


  • NZ - Not Companies Act Northern Ireland


  • OC - Other England and Wales (This prefix is only used for LLP cases in liquidation)


  • R - Northern Ireland Company registered before the partition of Ireland in 1922


  • RC - Royal Charter England and Wales
  • SA - Assurance Company Scotland


  • SC - Scottish Company


  • SF - Foreign Company Scotland


  • SI - Investment Company with Variable Capital (ICVC) Scotland


  • SL - Limited Partnership Scotland (Companies registered under this prefix are not liable to Corporation Tax and must not be set up on COTAX)


  • SO - Other Scotland (This prefix must only be used for LLP cases in liquidation)


  • SP - Industrial / Provident Scotland


  • SR - Royal Charter Scotland


  • SZ - Not Companies Act Scotland


  • ZC - Not Companies Act England and Wales.

This rule checks presence of exactly 8 digits or prefix and 6 or 7 digits.

INFO
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.
INFO
Identifier format invalid (Company registration number (United Kingdom))Company registration number in United Kingdom consists of either 8 digits (English and Welsh companies) or have 1 or 2 character alphabetic prefix (Companies registered in Scotland and Northern Ireland and those registered by the Financial Services Authority). The following are possible values for the prefix.
  • Companies formed in England and Wales have CRNs beginning with 0 (zero)
  • AC - Assurance Company England and Wales


  • FC - Foreign Company England and Wales


  • GE - European Economic Interest Grouping (EEIG) England and Wales


  • GN - EEIG Northern Ireland


  • GS - EEIG Scotland


  • IC - Investment Company with Variable Capital (ICVC) England and Wales


  • IP - Industrial and Provident England and Wales


  • LP - Limited Partnership England and Wales


  • NA - Assurance Company Northern Ireland


  • NF - Foreign Company Northern Ireland


  • NI - Northern Ireland Company


  • NL - Limited Partnership Northern Ireland (This prefix is not applicable to CT and should not be used)


  • NO - Other Northern Ireland


  • NP - Industrial and Provident Northern Ireland


  • NR - Royal Charter Northern Ireland


  • NZ - Not Companies Act Northern Ireland


  • OC - Other England and Wales (This prefix is only used for LLP cases in liquidation)


  • R - Northern Ireland Company registered before the partition of Ireland in 1922


  • RC - Royal Charter England and Wales
  • SA - Assurance Company Scotland


  • SC - Scottish Company


  • SF - Foreign Company Scotland


  • SI - Investment Company with Variable Capital (ICVC) Scotland


  • SL - Limited Partnership Scotland (Companies registered under this prefix are not liable to Corporation Tax and must not be set up on COTAX)


  • SO - Other Scotland (This prefix must only be used for LLP cases in liquidation)


  • SP - Industrial / Provident Scotland


  • SR - Royal Charter Scotland


  • SZ - Not Companies Act Scotland


  • ZC - Not Companies Act England and Wales.

This rule checks presence of exactly 8 digits or prefix and 6 or 7 digits without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more or wrong placed digits/letters or the prexis is missing then the rule is violated.

ERROR
Identifier format invalid (Driver license number (United Kingdom))The rule checks the structure of the Driver's License Number in UK. The UK driver's license number follows a 18-character structure.
  • First 5 characters: First five letters of the surname (padded with the number 9 if the surname has fewer than five characters).
  • Next character (6th): Represents the decade of birth (e.g., '8' for 1980s).
  • Following 5 digits (7th to 11th): Encodes the date of birth in the format MMDDY:
    • MM: Birth month (female drivers add 5 to the first digit, making January range from 51 to 62).
    • DD: Day of birth.
    • Y: Last digit of the birth year.
  • Two letters or digits (12th to 13th): Additional characters, often an issue number or other identifier.
  • Last 5 characters (14th to 18th): Numeric sequence, with a check digit to ensure validity.
ERROR
Identifier format invalid (European value added tax identifier (United Kingdom (Northern Ireland)))This rule checks the format of European value added tax identifier (United Kingdom (Northern Ireland)). Country code XI 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.
INFO
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.
INFO
Identifier format invalid (NHS number (United Kingdom))The rule checks the structure of the NHS number which is ten digits, written in the format 123 456 7890.
  • Digits 1–9: The first nine digits are a unique sequence.
  • Digit 10: The last digit is a check digit, calculated using a weighted modulus 11 algorithm on the first nine digits.
ERROR
Identifier format invalid (NI number (United Kingdom))This rule checks the format of the National Insurance number in the United Kingdom. The National Insurance number is a number used in the United Kingdom in the administration of the National Insurance or social security system. It is also used for some purposes in the UK tax system. The number is sometimes referred to as a NI No or NINO. The format of the number is two prefix letters, six digits and one suffix letter (A, B, C or D). An example is AA123456C.ERROR
Identifier format invalid (Unique taxpayer reference number (United Kingdom))This rule checks the format of the unique taxpayer reference number (United Kingdom). A company UTR is a distinct 10-digit number that HMRC issues to all new limited companies. These numbers are used to identify companies for all tax-related purposes.ERROR
Identifier format invalid (VAT registration number (United Kingdom))This rule checks the format of VAT registration number (United Kingdom). It is a 9 digit number, optionally with ‘GB’ at the start, for example 123456789 or GB123456789.ERROR
Identifier missing (Company registration number (United Kingdom))Each legal entity in the United Kingdom should have a Company registration number.INFO
Identifier missing (European value added tax identifier (United Kingdom))Each legal entity in the United Kingdom should have a European value added tax identifier.INFO
Identifier missing (VAT registration number (United Kingdom))A business partner in UK requires a VAT registration number.INFO
Identifier unknown (Company registration number (United Kingdom))This business rule checks the validity of the Company registration number against Companies House. The registration valid number number is valid, when it is available in the company register .ERROR
Identifier unknown (EORI number (United Kingdom))This business rule checks the existence of the EORI number against the UK.EORI register. The EORI is judged as valid, when it is available in this register.ERROR
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.ERROR
Identifier unknown (VAT registration number (United Kingdom))This business rule checks the existence of the UK VAT number against the UK VAT register. The VAT is judged as valid, when it is available in this register.ERROR
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
ERROR
Legal form invalid (United Kingdom)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (United Kingdom)This rule checks whether the domestic bank account id exceeds the maximum possible length in United KingdomERROR
Locality Qualification (EORI number, Data source:UK.EORI)This data quality rule checks the congruency of the given city against the city maintained as reference for the EORI numberINFO
Locality qualification (VAT registration number (United Kingdom))This business rule checks the congruency of the given city against the city maintained as reference for the VAT registration number (United Kingdom)INFO
Mandatory administrative area missing (United Kingdom)The administrative area (a top-level geographical or political area division in a country) is required (i.e. mandatory) for a complete physical touchpoint in United KingdomINFO
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.ERROR
Mandatory locality missing (United Kingdom)The locality is mandatory for street addresses in United Kingdom.ERROR
Mandatory post code missing (United Kingdom)The post code is mandatory for street addresses in United Kingdom.ERROR
Mandatory thoroughfare missing (United Kingdom)The thoroughfare is mandatory for street addresses in United Kingdom.ERROR
Name Qualification (EORI number, Data source:UK.EORI)This data quality rule checks the congruency of the given name against the name maintained as reference for the EORI numberINFO
Name qualification (VAT registration number (United Kingdom))This business rule checks the congruency of the given name against the name maintained as reference for the VAT registration number (United Kingdom)INFO
Post code Qualification (EORI number, Data source:UK.EORI)This data quality rule checks the congruency of the given post code against the post code maintained as reference for the EORI numberINFO
Post code format invalid (United Kingdom)This rule checks the post code format of United Kingdom. The following patterns are allowed, whereby A is a placeholder for an alphabetic character and N a placeholder for a numeric digit: 'AN NAA', 'ANN NAA', 'AAN NAA', 'AANN NAA', 'ANA NAA', 'AANA NAA'. This rule however ignores any whitespaces.ERROR
Postal code qualification (VAT registration number (United Kingdom))This business rule checks the congruency of the given postal code against the postal code maintained as reference for the VAT registration number (United Kingdom)INFO
Thoroughfare Qualification (EORI number, Data source:UK.EORI)This data quality rule checks the congruency of the given street against the street maintained as reference for the EORI numberINFO
Thoroughfare qualification (VAT registration number (United Kingdom))This business rule checks the congruency of the given street against the street maintained as reference for the VAT registration number (United Kingdom)INFO
Unallowed pattern in name detected (GB)This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for Address/country/GB are the following: Regular expression/One time vendor
Regular expression/Aggregated payments
Regular expression/No new orders
Regular expression/Do not use duplicates note
Regular expression/Reference to other record
Regular expression/No use note
Regular expression/Reference to new record
Regular expression/Reference the former name
Regular expression/Long number in name
Regular expression/Duplicate record note
Regular expression/Deletion note
Regular expression/Dummy record note
Regular expression/Sequence of digits
Regular expression/Unsorted keywords
Regular expression/Length of name .
WARNING

Data sources

Data source An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short 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
[[GB-EAW.CR (data source)]]
Companies House
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
Commercial register of the United Kingdom. LIVE
9,224,308 records
[[UK.EORI (data source)]]
EORI
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
EORI number is used as an identification number in all customs procedures when exchanging information with Customs administrations. LIVE
141 records
[[GB-EAW.CC (data source)]]
Register of Charities
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
The regulator of charities in England and Wales maintaining the charity register. BETA
[[UK.VAT (data source)]]
HM Revenue and Customs VAT Check
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
The official data source for checking UK VATs and retrieving connected data BETA
72,349 records
[[UK.CC (data source)]]
Register of Charities
[[BUSINESS_PARTNER]]A fatal error occurred in the #info parser function
The regulator of charities in England and Wales maintaining the charity register. DESIGN
65,721 records
[[GB.GEON (data source)]]
Great Britain (GeoNames)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.HMRC (data source)]]
United Kingdom HMRC register
n/a IDEA
[[GB.NI.CR (data source)]]
Nother Ireland (govt)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.NI.POST (data source)]]
North Ireland Post Codes Commercial (North Ireland)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.NPE (data source)]]
NPE Maps (United Kingdom)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.PAF (data source)]]
PAF address files (United Kingdom)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.PCF (data source)]]
Great Britain post code finder
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.POST (data source)]]
Open post code data (United Kingdom)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA
[[GB.RM (data source)]]
Royal Mail (United Kingdom)
[[ADDRESS]]A fatal error occurred in the #info parser function
n/a IDEA

Banking metadata

Property Value
Full metadata Bank accounts in United Kingdom of Great Britain and Northern Ireland
Local name of the national bank ID. Bank ID name Sort Code
The provider (national authorities in most cases) of the national bank ID. Bank ID provider BACS Limited
Currency code for accounting in the given country. Currency code GBP
Maximum length of the national bank account ID. Maximum bank account ID length 8