CH_VAT_ID (CH - VAT registration number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/CH VAT ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key CH_VAT_ID
The country a linked concept is active or generally relevant for. Country scope CH (Switzerland)
Language-specific name. Monolingual name VAT registration number (de), VAT registration number (rm), VAT registration number (it), VAT registration number (fr), VAT registration number (en)
Language-specific short name. Monolingual short name CH - VAT registration number (en)
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD2

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
0000000000P7EKT5Q1HYX8WJ19 Specifies the allowed formats for the VAT registration number (Switzerland) IDENTIFIER_FORMAT
^(\s*?\.*?-*?)CHE(-*?\s*?\.*?)(\d-*?\s*\.*-*){9}\s*(MWST|TVA|MWST\/HR|HR\/MWST|IVA|RC\/IVA|RC\/TVA)?$

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 checkdigit invalid (VAT registration number (Switzerland)) The last digit is a MOD11 checksum digit build with weighting pattern: 5,4,3,2,7,6,5,4. The rule allows for any valid formatted CH VAT ID, in case of an invalid format (see Identifier format invalid (VAT registration number (Switzerland))) the rule will fail directly. RELEASED ERROR
Identifier format invalid (VAT registration number (Switzerland)) The VAT number is based on the Swiss UID. It starts with CHE, followed by 9 digits (whereby the last digit is a MOD11 checksum), and either ends with MWST, TVA or IVA depending on the part of Switzerland a business is registered in.

The extension of the UID will change as follows: German part: MWST (German abbreviation for “Mehrwertsteuer”) French part: TVA (French abbreviation for “taxe sur la valeur ajoutée”) Italian part: IVA (Italian abbreviation for “Imposta sul valore aggiunto”) For example, a Swiss VAT number could look like this: CHE-123.456.789 MWST.

Combinations with the suffixes HR and RC (which indicate that the exact identical number is a company identification number and registered in the UID register) are allowed such as MWST/HR or TVA/RC in any possible combination.

RELEASED ERROR
Identifier missing (VAT registration number (Switzerland)) In Switzerland, a business partner should have a VAT registration number RELEASED INFO
Identifier unknown (VAT registration number (Switzerland)) This business rule checks the validity of the VAT ID identifier against UID-Register from Switzerland, also in case when the business entity information incomplete/unavailable is.

The VAT ID is valid, when it is available in the UID-Register, also when the company already closed/inactive is.

RELEASED ERROR