QST_CA (CA - Quebec Sales Tax number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/QST CA
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key QST_CA
The country a linked concept is active or generally relevant for. Country scope CA (Canada)
Language-specific name. Monolingual name Quebec Sales Tax (en), Quebec Sales Tax (fr)
Language-specific short name. Monolingual short name CA - Quebec Sales Tax number (en)
Informal and comprehensive human-readable definition of a concept. Description The Quebec sales tax (QST, French: Taxe de vente du Québec or TVQ) is applied in a province Quebec. This is a kind of Provincial sales taxes (PST). The QST consists of 16 digits.
Category of business identifiers. Identifier category Tax Number

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
0000000000S654TAVT0MKE9RGW Specifies the allowed formats for the Quebec Sales Tax number (Canada) IDENTIFIER_FORMAT
^\s*?\.*?-*?(\d\s*\.*-*){10}QT\s*?\.*?-*?(\d\s*\.*-*){4}$

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 (Quebec Sales Tax number (Canada)) This rule checks the checkdigit of the Quebec Sales Tax number (Canada). The checksum is done in the following way:
  • a) starting from the ninth digit multiply each digit by the factor. The factors form a circular secuence of values 2 through 7, beginning on the right,
  • b) sum up the result

,

  • c) divide the result by 11 (183/11) = 16 reste 7

, If the reminder is 0, the check digit is 1. If the reminder is 1, the check digit are 0. For any other reminder obtained, the check digit is the diference between 11 and the reminder. Subtract the reminder obtained from 11.

RELEASED ERROR
Identifier format inaccurate (Quebec Sales Tax number (Canada)) Quebec Sales Tax number (Canada) consists of 16 characters: 9 digits, 1 check digit, abbreviation "QT" followed by 4 digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, dots or hyphens then the rule is violated.

This rule checks the syntax, i.e. format of the Quebec Sales Tax number (Canada) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.

IDEA INFO
Identifier format invalid (Quebec Sales Tax number (Canada)) Quebec Sales Tax number (Canada) is a tax identifier applied in province Quebec. The PST number consists of 16 characters: 9 digits, 1 check digit, abbreviation "QT" followed by 4 digits.

This rule checks presence of exactly 16 characters corresponding to the format of the Quebec Sales Tax number (Canada) without considering possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are less/more digits, unexpected non-digits characters then the rule is violated.

RELEASED ERROR