Identifier qualification

From CDQ Wiki
< Data quality rules
Public:Data quality rules/identifier qualification
Jump to navigation Jump to search
Property Value
The human-friendly name shown for this concept in the user interface, used instead of the technical name to improve readability and understanding. Display name Identifier qualification
An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description For a given EU VAT, it is checked whether the name and address are really associated with this identifier (same information maintained in the VAT register as provided by the user).
Informal and comprehensive human-readable definition of a concept. Description For a given identifier, the company's name and address it is checked whether the name and address are really associated with this identifier. This means that in a external managed business partner data source or the CDQ database the name and address belong to the entity that comprises the identifier value. The service employs a fine granular qualification of the identifier by not only considering the company name, andthe address as a whole but also on post code, locality (i.e. city, town etc.) and street level. Doing so the CDQ enables a qualified validation of identifiers according to EU VAT compliance rules (in German: "UID Bestätigungsverfahren").
Category of a concept, not managed by wiki categories but regular pages. Category EU TAX Qualification (rule category), EU VAT Qualification by AT.FON (rule category), EU VAT Qualification by BZSt (rule category), EU VAT Qualification by VIES (rule category), Qualification (rule category), Worldwide TAX Qualification (rule category)

Rule categories

Data quality rules


How does it work?

European value added tax identifiers can be qualified by different data sources. The typical business use case is to qualify name and address data against a VAT number when doing intra-community business, i.e. delivering/selling goods across inner-European borders. A German company that sells and delivers goods to a French business partner has to perform a qualified check of the French business partner's VAT number against the German tax authority (BZSt). Based on the compliance and business requirements different validation sources might have to be used. Currently the CDQ services support the domestic tax authorities in Austria and Germany. Additionally the MIAS database of the European Commission can be used for qualified checks, but with limitations.

Germany (BZST (data source)). Using the interface of the BZSt all EU VAT numbers except German EU VATs can be qualified. BZSt does not provide back the actual registration data but just a summary of comparison of given address and name data with the VAT registered data.

Austria (AT.FON (data source)). The Austrian tax authorities allow qualification of any EU VAT numbers and provide as well the actual registration data. However, only CDQ clients that have access (registered credentials for FinanzOnline) can qualify VAT data using this data source.

VIES / MIAS database (VIES (data source)). The European Commission's webservice can be used to check the format and existence of any EU VAT number. Though, qualified checks are possible for all countries (except Germany and Spain). VIES returns, identically to AT.FON (data source) the VAT registration data.

In general, the following qualification levels are distinguished:

  • QUALIFIED: The value is approved by external data source
  • FAILED: The value is not confirmed by external data source
  • NOT PROVIDED: The value has not been provided and has not been checked by external data source.
  • IDENTIFIER VALID: The identifier value is approved by external data source.
  • UNKNOWN: There was no response provided by the external data source for this attribute and thus we don't know whether the input is correct or incorrect.

The result of the qualification (Possible result levels are: QUALIFIED, FAILED or UNKNOWN) is structured with respect to:

  • Name qualification. Is the company name provided by the data source used for qualification identical with the input name?
  • Address qualification. Is the address provided by the data source identical with the input address?
Regarding the address, different address elements are separately checked. The result of the address qualification is defined according to the decision matrix below. Please expand for viewing the table
Case Post code Locality Thoroughfare Thoroughfare number Address qualification result Explanation
Differing post code FAILED * * * FAILED Wrong post code always results in a FAILED result
Differing locality * FAILED * * FAILED Wrong locality always results in a FAILED result
Differing thoroughfare * * FAILED * FAILED Wrong street always results in a FAILED result
Differing thoroughfare number QUALIFIED QUALIFIED QUALIFIED FAILED QUALIFIED Wrong thoroughfare number, i.e. house number is accepted
Missing locality/post code/street NOT PROVIDED NOT PROVIDED NOT PROVIDED * FAILED If one of locality, post code or street is not provided the result is FAILED
No response data UNKNOWN UNKNOWN UNKNOWN * UNKNOWN If one of post code locality or street is not known, the result is UNKNOWN.


  • Overall qualification. Are name and address qualified with respect to the data provided by the data source?
Decision matrix for the overall qualification result. Please expand!
Case Name qualification Address qualification Identifier validity Overall
Name not qualified FAILED * VALID FAILED
Address not qualified * FAILED VALID FAILED
Identifier not valid * * INVALID UNKNOWN
Address qualification UNKNOWN * UNKNOWN VALID UNKNOWN
Name qualification UNKNOWN UNKNOWN * VALID UNKNOWN
Qualified QUALIFIED QUALIFIED VALID QUALIFIED
Retrieved from "https://meta.cdq.com/w/index.php?title=Public:Data_quality_rules/identifier_qualification&oldid=98193"