GB (United Kingdom of Great Britain and Northern Ireland)

From CDQ Wiki
< Business Partner (CDQ) | Address (CDQ) | Country (CDQ)
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 Vereinigtes Königreich (de), United Kingdom of Great Britain and Northern Ireland (en), 英国 (zh), 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 en
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
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)
GB-WLS (Wales) GB-WLS Wales (de), Wales (en), pays de Galles (fr), 威爾斯 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
GB_0088 (CDQ)GB_0088EU Association (en)
Societas Europaea (la)		SE (en)
GB_0971 (CDQ)GB_0971Private Limited Company (en)
Cyfyngedig (cy)		Pvt. Ltd. (en)
GB_2546 (CDQ)GB_2546Limited Liability Partnership (en)
Partneriaeth Atebolrwydd Cyfyngedig (cy)		LLP (en)
GB_3007 (CDQ)GB_3007Charitable Incorporated Organisation (en)CIO (en)
GB_3008 (CDQ)GB_3008Scottish Charitable Incorporated Organisation (en)SCIO (en)
GB_3012 (CDQ)GB_3012Private Unlimited Company (en)
GB_3016 (CDQ)GB_3016Royal Charter Company (en)
GB_3025 (CDQ)GB_3025Industrial and Provident Society (en)IPS (en)
GB_3033 (CDQ)GB_3033Other company type (en)
GB_3036 (CDQ)GB_3036Protected Cell Company (en)PCC (en)
GB_3039 (CDQ)GB_3039Investment Company with Variable Capital (en)ICVC (en)
GB_3040 (CDQ)GB_3040United Kingdom Economic Interest Grouping (en)UKEIG (en)
GB_3043 (CDQ)GB_3043Registered Society (en)
GB_3046 (CDQ)GB_3046Old Public Company (en)
GB_3053 (CDQ)GB_3053Scottish Partnership (en)
GB_3551 (CDQ)GB_3551Public Limited Company (en)PLC (en)
GB_3999 (CDQ)GB_3999Converted/Closed (en)
GB_5311 (CDQ)GB_5311Societas Cooperativa Europaea (en)SCE (en)
GB_7452 (CDQ)GB_7452General partnership (en)GP (en)
GB_7880 (CDQ)GB_7880Limited partnership (en)LP (en)
GB_8340 (CDQ)GB_8340Sole proprietorship (en)SP (en)
GB_8402 (CDQ)GB_8402European Economic Interest Grouping (en)EEIG (en)
GB_8489 (CDQ)GB_8489Private company limited by shares (en)Ltd. (en)
GB_9839 (CDQ)GB_9839Community interest company (en)CIC (en)

Identifiers

IdentifierNameRegistration authority
EU_VAT_ID_UK (Value added tax identification number)Value added tax identification number (en)
ID_CRN (Company registration number)Company registration number (en)
ID_UTR (Unique taxpayer reference number)Unique taxpayer reference number (en)HM Revenue & Customs
ID_VAT_UK (Value added tax registration number)Value added tax registration number (en)HM Revenue & Customs
UK_DRV_LIC (Driver's Licence Number)Driver's Licence Number (en)
UK_IN_ID (NI number)NI number (en)
UK_NHS_ID (National Health Service Number)National Health Service Number (en)
UK_RCN (Registered charity number)Registered charity number (en)
WR_BTRN (Board of Trade Registration Number)Board of Trade Registration Number (en)Department for Business and Trade

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)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.
This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for GB (United Kingdom of Great Britain and Northern Ireland) are the following: Regular expression/Mononumerical post code with delimeter		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))
  • 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.
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)
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))
  • 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.
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)
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)))
  • for prefix "HA": 3 digits after the prefix should be from 500 to 999.


    • 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
    		INFO
    Identifier format invalid (European value added tax identifier (United Kingdom))
  • for prefix "HA": 3 digits after the prefix should be from 500 to 999.


    • 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
    		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)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 .
    This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for GB (United Kingdom of Great Britain and Northern Ireland) are the following: Regular expression/One time vendor    		WARNING

    Data sources

    Data quality ruleNameContent
    GB-EAW.CR (data source)Companies House (en)BUSINESS_PARTNER
    GB.GEON (data source)Great Britain (GeoNames) (en)ADDRESS
    GB.HMRC (data source)Her Majesty's Revenue and Customs (HM Revenue and Customs or HMRC) (en)
    United Kingdom HMRC register (en)
    HMRC (de)
    GB.NI.CR (data source)Nother Ireland (govt) (en)ADDRESS
    GB.NI.POST (data source)North Ireland Post Codes Commercial (North Ireland) (en)ADDRESS
    GB.NPE (data source)NPE Maps (United Kingdom) (en)ADDRESS
    GB.PAF (data source)PAF address files (United Kingdom) (en)ADDRESS
    GB.PCF (data source)Great Britain post code finder (en)ADDRESS
    GB.POST (data source)Open post code data (United Kingdom) (en)ADDRESS
    GB.RM (data source)Royal Mail (United Kingdom) (en)ADDRESS
    UK.CC (data source)Register of Charities (en)BUSINESS_PARTNER
    UK.EORI (data source)Economic Operators Registration and Identification Database (en)BUSINESS_PARTNER
    UK.VAT (data source)HM Revenue and Customs VAT Check (en)BUSINESS_PARTNER

    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
    Retrieved from "https://meta.cdq.com/w/index.php?title=DataModel:CDQ/Business_Partner/Address/Country/GB&oldid=73953"