GST_CA (CA - Goods & Services Tax Num.)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/GST CA
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key GST_CA
The country a linked concept is active or generally relevant for. Country scope CA (Canada)
Language-specific name. Monolingual name Goods and Services Tax number (fr), Goods and Services Tax number (en)
Language-specific short name. Monolingual short name CA - Goods & Services Tax Num. (en)
Informal and comprehensive human-readable definition of a concept. Description The Canadian sales taxes include the Provincial Sales Tax (PST), the Quebec Sales Tax (QST), the Goods and Services Tax (GST), and the Harmonized Sales Tax (HST) which is a combination of the provincial sales tax portion and the GST in some provinces.

The GST applies to most goods and services made in Canada, however, certain exceptions may apply.

Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

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
0000000000J0QH012HA1D55F3F Specifies the allowed formats for the Goods and Services Tax number (Canada) IDENTIFIER_FORMAT
^\s*?\.*?-*?(\d\s*\.*-*){9}RC[\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 format inaccurate (GST number (Canada)) The Goods and Services Tax number (Canada) consists of 15 characters. 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.

This rule checks the syntax, i.e. format of the Goods and Services 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 (GST number (Canada)) Goods and Services Tax number (Canada) applies to most goods and services made in Canada. The GST number consists of 15 characters: business number (first nine digits ) followed by a two letter abbreviation (denoting the type of account), followed by a four digit number.

Letter abbreviation “RT” stands for “tax return”, and the final four digits indicate that it is business’s first RT account. If an entity has two different accounts, the second one would end in 0002.

This rule checks presence of exactly 15 characters corresponding to the format of the Goods and Services 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
Invalid checksum of GST CA (Canada) This rule checks the checkdigit of the Goods and Services Tax number (GST) in Canada. The first nine digits of the GST are the Canadian business number. For these 9 digits the checkdigit is calculated, in the following way:
  • a) Add all odd digits, except the 9th one,
  • b) String all even digits together and multiply by 2

,

  • c) Add all digits from the result b. together

,

  • d) Add the result of a. and c. together

,

  • e) Subtract the result of d. from the nearest 10 digit.
  • The result of e. must equal the 9th digit.
RELEASED ERROR