IE (Ireland)

From CDQ Wiki
DataModel:CDQ/Business Partner/Address/Country/IE
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 IE
Language-specific name. Monolingual name Éire (ga), Irland (de), Ireland (en), 爱尔兰共和国 (zh), Irlande (fr)
Language-specific short name. Monolingual short name Ireland (en), Irlande (fr), Irland (de), 爱尔兰 (zh)
The offical langauge of a country. Official language ga, en
Language used in a country, beside the administrative languages. other language ga, 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
IE-C (Connacht) IE-C Connacht (de), Connacht (en), Connacht (fr), Cúige Chonnacht (ga), 康諾特省 (zh)
IE-L (Leinster) IE-L Cúige Laighean (ga), Leinster (de), Leinster (en), Leinster (fr), 倫斯特省 (zh)
IE-M (Munster) IE-M Cúige Mumhan (ga), Munster (de), Munster (en), Munster (fr), 芒斯特省 (zh)
IE-U (Ulster) IE-U Cúige Uladh (ga), Provinz Ulster (de), Ulster (en), Ulster (fr), 阿爾斯特省 (zh)

Legal forms

Legal formELF codeNameMain abbreviation
IE_0481Cuideachta phoibli theoranta (en)
Limited limited company (en)
cpt (en)
IE_2543Designated Activity Company (DAC) – (limited by shares) (en)DAC (en)
IE_3620Irish Collective Asset-management Vehicle (en)ICAV (en)
IE_3879Single Member Company (en)SMC (en)
IE_4042Cuideachta faoi Theorainn Ráthaíochta (en)ctr (en)
IE_4865Company (en)Co. (en)
IE_5040Societas Cooperativa Europaea (en)SCE (en)
IE_6222Company Limited by Guarantee (en)CLG (en)
IE_6253Cuideachta Ghníomhaíochta Ainmnithe (en)cga (en)
IE_6303Limited (en)
Teoranta (ga)
Teo (en)
IE_6653Societas Europaea (en)
EU Association (en)
SE (en)
IE_7190Public Limited Company (PLC) (en)
Public Limited Company (en)
PLC (en)
IE_7711European Economic Interest Grouping (en)EEIG (en)
IE_9612Unlimited company (en)UC (en)
IE_9613Private unlimited company with a share capital (en)ULC (en)
IE_9614Public unlimited company without a share capital (en)PULC (en)
IE_9615Public unlimited company with a share capital (en)PUC (en)
IE_9836Private company limited by shares (en)Ltd. (en)

Identifiers

IdentifierNameRegistration authority
CN_IE (Company number)Company number (en)
Company number (ga)
EU_VAT_ID_IE (Value added tax identification number)Uimhir Cánach ar an Mheasúnacht Bhreisluacha (ga)
Value added tax identification number (en)
Office of the Revenue Commissioners (Ireland)

Data quality rules

Data quality ruleDescriptionCriticality
Dummy post code detected (IE)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 IE (Ireland) are the following: Regular expression/Not available post code
ERROR
Identifier Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Identifier Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Identifier Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Identifier format inaccurate (European value added tax identifier (Ireland))This rule checks the syntax, i.e. format of the European value added tax identifier (Ireland)INFO
Identifier format invalid (European value added tax identifier (Ireland))B) 7 numerical digits followed by 1 character
C) 6 digits and two characters whereby the characters are either placed at the last two positions or on position two and the last one.
The European value added tax identifier in Ireland has different valid formats due to its latest adaptation in 2013. The rule checks the presence of: A) 7 numerical digits followed by 2 letters whereby the last character necessarily equals "A" or "H"
ERROR
Identifier missing (European value added tax identifier (Ireland))Each legal entity in Ireland should have a European value added tax identifier.WARNING
Identifier unknown (Company number (Ireland))This rule checks whether the Company_number_(Ireland) is a really existing by checking whether it can be found in the business register. If it is not available, the identifier will be treated as invalid and the data quality rule is violated.ERROR
Identifier unknown (European value added tax identifier (Ireland))European value added tax identifier (Ireland)ERROR
Invalid checksum of EU VAT ID IE (Ireland)This rule checks the checksum of the European VAT number in Ireland. Identifier's format is:
[C1, C2, C3, C4, C5, C6, C7, C8, C9] where C1 to C7 are number. C8 - checksum letter, C9 is optional and can be a letter in the range [A-I], or “W”.
  • 1. In reverse order, each digit is multiplied by a weight started at 2:
    • C7 - 2
    • C6 - 3
    • C5 - 4
    • C4 - 5
    • C3 - 6
    • C2 - 7
    • C1 - 8
    • LetterToNumber(C9)- 9
  • 2. LetterToNumber(C9) is based on the following mapping:

“A”=1, “B”=2, “C”=3, “D”=4, “E”=5, “F”=6, “G”=7, “H”=8, “I”=9

A “W” or absence of character in position 9 is allocated a numeric value of 0.

  • 3. Sum up the result (sumproduct)
  • 4. The remainder of the modulo 23 indicates the character position on the alphabet according to the following mapping:
ERROR
Legal form invalid (Ireland)Each record should have legal form appropriate for the country.INFO
Length of domestic bank account Id invalid (Ireland)This rule checks whether the domestic bank account id exceeds the maximum possible length in IrelandERROR
Locality Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Locality Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Locality Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Mandatory administrative area missing (Ireland)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 IrelandINFO
Mandatory locality missing (Ireland)The locality is mandatory for street addresses in Ireland.ERROR
Mandatory post code missing (Ireland)The post code is mandatory for street addresses in Ireland.ERROR
Mandatory thoroughfare missing (Ireland)The thoroughfare is mandatory for street addresses in Ireland.ERROR
Name Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Name Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Name Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Post code Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Post code Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Post code Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Post code format invalid (Ireland)This rule checks the post code format of Ireland according to the EIRCODE as introduced in 2015. The Eircode is divided into two parts: The first part consists of three characters (routing key), with the first character being an uppercase letter followed by two numeric digits.The second part consists of a space and four characters, which can be either uppercase letters or numeric digits. This rule however ignores any whitespaces.ERROR
Thoroughfare Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Thoroughfare Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Thoroughfare Qualification (European value added tax identifier (Ireland), 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 (Ireland)INFO
Unallowed pattern in name detected (IE)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 IE (Ireland) are the following: Regular expression/One time vendor
WARNING
Unknown routing key in the post code identified (Ireland)This rule checks the routing key of the post code in Ireland (EIRCODE) as introduced in 2015. The Eircode is divided into two parts: The first part consists of three characters (routing key), with the first character being an uppercase letter followed by two numeric digits.The second part consists of a space and four characters, which can be either uppercase letters or numeric digits. This rule checks whether the routing key is known to us, which means it is documented as a valid routing key :Category:Address/post code/routing key.INFO

Data sources

Data quality ruleNameContent
AT.FON (data source)FinanzOnline Austria (en)BUSINESS_PARTNER
BZST (data source)Federal Central Tax Office (Germany) (en)
Bundeszentralamt für Steuern (Germany) (en)
BUSINESS_PARTNER
CDQ.VAT (data source)CDQ European VAT Registration Database (en)BUSINESS_PARTNER
EU.EORI (data source)Economic Operator Identification and Registration Database (en)BUSINESS_PARTNER
EU.PC (data source)EuroStat Post Code Files (European Union) (en)ADDRESS
IE.CR (data source)Ireland Companies Register (en)BUSINESS_PARTNER
IE.GCB (data source)Bank Data details provided by the Banking & Payments Federation Ireland (en)
IE Bank Data (de)
BANK_ACCOUNT
VIES (data source)VAT Information Exchange System (en)BUSINESS_PARTNER

Banking metadata

Property Value
Full metadata Bank accounts in Ireland
Local name of the national bank ID. Bank ID name National Sort Code
The provider (national authorities in most cases) of the national bank ID. Bank ID provider Irish Payment Services Organisation Lt - IPSO
Currency code for accounting in the given country. Currency code EUR
Maximum length of the national bank account ID. Maximum bank account ID length 8