European value added tax identifier (Ireland)

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_IE
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. IE
Monolingual name Language-specific name of a data model concept or concept value. Value added tax identification number (en), Uimhir Cánach ar an Mheasúnacht Bhreisluacha (ga)
Monolingual short name Language-specific short name of a data model concept or concept value. IE - 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. VAT (en), CBL (en), UCMB (ga)
Description Informal and comprehensive human-readable definition of a concept. Issued by the Revenue Commissioners, the Irish VAT identifier is used for cross-border VAT transactions within the EU.

Format: IE9999999X or IE9X99999X (9 characters).

Check Digit Logic: Uses a weighted modulus 23 check system.

Applies to Describes what kind of entities are assigned the identifier at hand Legal Entity
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 IE_CDQ00069 (CDQ)
Identifier category Categories of identification numbers VAT Number
Mappings mapping source: uid (AT.FON), mapping: AT.FON uid (IE) ↣ IDENTIFIER_VALUE
mapping source: STCEG (SAP.FLAT), mapping: SAP.FLAT STCEG (IE) ↣ IDENTIFIER_VALUE
mapping source: vatNumer (VIES), mapping: VIES vatNumer (IE) ↣ IDENTIFIER_VALUE

Formal definition[edit]

 DescriptionRegular expressionType
Regular expression/EU VAT ID IE/formatSpecifies the allowed formats for the European value added tax identifier (Ireland)
^(\s*?\.*?-*?)((IE\d{7}\w{1}(A|H))|(IE\d{7}\w{1}$)|(IE\d{1}(\d{1}|\w{1})\d{4}(\d{1}|\w{1})\w{1}))(\s*?\.*?-*?)$
IDENTIFIER_FORMAT
Regular expression/EU VAT ID IE/natural personFor individuals the identifier ends with an "A" (e.g. 1234567FA)NATURAL_PERSON_IDENTIFICATION

Data quality rules[edit]

Business ruleDescriptionStatusCriticality
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)IDEAINFO
Identifier format invalid (European value added tax identifier (Ireland))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";

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.
RELEASEDERROR
Identifier missing (European value added tax identifier (Ireland))Each legal entity in Ireland should have a European value added tax identifier.RELEASEDWARNING
Identifier unknown (European value added tax identifier (Ireland))European value added tax identifier (Ireland)RELEASEDERROR
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:
EU VAT IE.PNG
RELEASEDERROR
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO
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)RELEASEDINFO