EU_VAT_ID_FR (FR - VAT identification number)

From CDQ Wiki
< Business Partner (CDQ) | Identifier (CDQ)
DataModel:CDQ/Business Partner/Identifier/EU VAT ID FR
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key EU_VAT_ID_FR
The country a linked concept is active or generally relevant for. Country scope FR (France)
Language-specific name. Monolingual name Taxe sur la Valeur Ajoutée (fr), Value added tax identification number (en)
Language-specific short name. Monolingual short name FR - VAT identification number (en)
Informal and comprehensive human-readable definition of a concept. Description The French VAT identifier is used for businesses involved in cross-border transactions within the EU. Issued by the Direction Générale des Finances Publiques, it is essential for VAT-related operations in France.

Format: FRXX 999999999 (11 digits, the first two digits are check digits).

Check Digit Logic: The first two digits are a check digits based on the SIREN number of the company.

Category of business identifiers. Identifier category VAT Number
Legacy property. A technical SAP code. SAP mapping STCEG

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
0000000000R0S8C2REJ618Y9TD Specifies the allowed formats for the European value added tax identifier (France) IDENTIFIER_FORMAT
^FR(\w{2}|\d{2})\d{9}$

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. 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 Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality
Identifier Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Identifier Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Identifier Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Identifier format inaccurate (European value added tax identifier (France)) This rule checks the syntax, i.e. format of the European value added tax identifier in France with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

The European value added tax identifier in France consists of the prefix "FR" followed by two numerical or non-numerical digits followed by 9 digits. 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.

IDEA INFO
Identifier format invalid (European value added tax identifier (France)) The European value added tax identifier (France) RELEASED ERROR
Identifier missing (European value added tax identifier (France)) Each legal entity in France should have a European value added tax identifier. RELEASED ERROR
Identifier unknown (European value added tax identifier (France)) European value added tax identifier (France) RELEASED ERROR
Identifier unknown (European value added tax identifier (Guadeloupe)) European VAT IDs issued in France are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether for a business partner in Guadeloupe a given French 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. RELEASED ERROR
Identifier unknown (European value added tax identifier (Martinique)) European VAT IDs issued in France are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether for a business partner in Martinique a given French 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. RELEASED ERROR
Identifier unknown (European value added tax identifier (Reunion)) European VAT IDs issued in France are exchanged via a central system provisioned by the European Commission (i.e. VAT Information Exchange System (VIES)). This rule checks whether for a business partner in Reunion a given French 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. RELEASED ERROR
Inconsistency between SIREN and EU VAT ID (France) The SIREN number is the French Company Register ID. It consists of 9 digits. The VAT number in France is composed as follows: FR XX YYYYYYYYY whereby
  • Y: is exactly the 9 digit SIREN number
  • X: two calculated digits (logic unclear)
  • FR: the EU VAT prefix

This rule checks whether there is a SIREN number and EU_VAT_ID_FR available, and whether the last 9 digits of the VAT number are identical to the 9 digits of the SIREN number. If this is not the case then either the SIREN or VAT ID are considered invalid.

RELEASED ERROR
Invalid checksum of EU VAT ID FR (France) This rule checks the checksum of the European VAT number in France which consists of 11 digits in a format:

[ C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 ]

The check rules are different for old style and for a new style:

  • Case 1: Old Style C1 C2

[C1 C2] = ([C3 C4 C5 C6 C7 C8 C9 C10 C11] [1 2]) modulo 97

  • Case 2 : New Style C1 C2

S1 = Check Character (C1) S2 = Check Character (C2)

  • If C1 numeric then:
    • C2 alphabetic
    • S = (S1 * 24) + (S2 – 10)
  • If C1 alphabetic then:
    • S = (S1*34) + (S2-100)
    • P = (S/11) + 1

R1 = (S) modulo 11 R2 = ( [C3 C4 C5 C6 C7 C8 C9 C10 C11] + P) modulo 11 R1 = R2

Check Character: 

0-0, 1-1, 2-2, 3-3, 4-4, 5-5, 6-6, 7-7, 8-8, 9-9, 10-A, 11-B, 12-C, 13-D,   14-E, 15-F, 16-G, 17-H, 18-J, 19-K, 20-L, 21-M, 22-N, 23-P, 24-Q, 25-R, 26-S, 27-T, 28-U, 29-V, 30-W, 31-X, 32-Y, 33-Z.
RELEASED ERROR
Locality Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Locality Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Locality Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Name Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Name Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Name Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Post code Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Post code Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Post code Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Thoroughfare Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Thoroughfare Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Thoroughfare Qualification (European value added tax identifier (France), 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 (France) RELEASED INFO
Retrieved from "https://meta.cdq.com/w/index.php?title=DataModel:CDQ/Business_Partner/Identifier/EU_VAT_ID_FR&oldid=179253"