CA (Canada)
DataModel:CDQ/Business Partner/Address/Country/CA
| Property | Value |
|---|---|
| A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code | CA
|
| Language-specific name. Monolingual name | Kanada (de), Canada (fr), 加拿大 (zh), Canada (en) |
| Language-specific short name. Monolingual short name | Canada (en), Canada (fr), Kanada (de), 加拿大 (zh) |
| The offical langauge of a country. Official language | fr, en
|
| Language used in a country, beside the administrative languages. other language | fr, en
|
| Continent a country belongs to. Part of | North America |
Regions
| Region (controlled vocabulary) | A standardized code according to an ISO standard, e.g. ISO 3166-1 alpha-2 for regions. ISO code | Language-specific name. Monolingual name |
|---|---|---|
| CA-AB (Alberta) | CA-AB
|
Alberta (de), Alberta (en), Alberta (fr), 艾伯塔 (zh) |
| CA-BC (British Columbia) | CA-BC
|
British Columbia (de), British Columbia (en), Colombie-Britannique (fr), 不列颠哥伦比亚 (zh) |
| CA-MB (Manitoba) | CA-MB
|
Manitoba (de), Manitoba (en), Manitoba (fr), 曼尼托巴 (zh) |
| CA-NB (New Brunswick) | CA-NB
|
Neu-Braunschweig (de), New Brunswick (en), Nouveau-Brunswick (fr), 新不倫瑞克 (zh) |
| CA-NL (Newfoundland and Labrador) | CA-NL
|
Neufundland und Labrador (de), Newfoundland and Labrador (en), Terre-Neuve-et-Labrador (fr), 紐芬蘭與拉布拉多 (zh) |
| CA-NS (Nova Scotia) | CA-NS
|
Nouvelle-Écosse (fr), Nova Scotia (de), Nova Scotia (en), 新斯科舍 (zh) |
| CA-NT (Northwest Territories) | CA-NT
|
Nordwest-Territorien (de), Northwest Territories (en), Territoires du Nord-Ouest (fr), 西北地区 (zh) |
| CA-NU (Nunavut) | CA-NU
|
Nunavut (de), Nunavut (en), Nunavut (fr), 努納武特 (zh) |
| CA-ON (Ontario) | CA-ON
|
Ontario (de), Ontario (en), Ontario (fr), 安大略省 (zh) |
| CA-PE (Prince Edward Island) | CA-PE
|
Prince Edward Island (de), Prince Edward Island (en), Île-du-Prince-Édouard (fr), 愛德華王子島 (zh) |
| CA-QC (Quebec) | CA-QC
|
Quebec (en), Québec (de), Québec (fr), 魁北克 (zh) |
| CA-SK (Saskatchewan) | CA-SK
|
Saskatchewan (de), Saskatchewan (en), Saskatchewan (fr), 薩斯喀徹溫 (zh) |
| CA-YT (Yukon) | CA-YT
|
Yukon (de), Yukon (en), Yukon (fr), 育空 (zh) |
Legal forms
| Legal form | ELF code | Name | Main abbreviation |
|---|---|---|---|
| CA_0861 (CDQ) | CA_0861 | Unlimited liability company (en) | AULC (en) |
| CA_1387 (CDQ) | CA_1387 | Company (en) | Co. (en) |
| CA_1456 (CDQ) | CA_1456 | General partnership (en) | GP (en) |
| CA_1797 (CDQ) | CA_1797 | Limited partnership (fr) | LP (fr) |
| CA_2267 (CDQ) | CA_2267 | Limitée (fr) Limited (en) | Ltée (fr) Ltd (en) |
| CA_5444 (CDQ) | CA_5444 | Sole proprietorship (en) | SP (en) |
| CA_8327 (CDQ) | CA_8327 | Joint venture (en) | JV (en) |
| CA_9251 (CDQ) | CA_9251 | Cooperative (en) | Cooperativa (en) |
| CA_9461 (CDQ) | CA_9461 | Société par actions de régime fédéral (fr) Federal Joint Stock Company (en) | S.A.R.F (fr) |
| CA_9836 (CDQ) | CA_9836 | Corporation (en) | Corp (en) |
Identifiers
| Identifier | Name | Registration authority |
|---|---|---|
| BN_CA (Federal Business Number) | Federal Business Number (en) Federal Business Number (fr) | Canada Revenue Agency |
| CA_CNUM (Corporation number) | Corporation number (fr) Corporation number (en) | |
| GST_CA (Goods and Services Tax number) | Goods and Services Tax number (en) Goods and Services Tax number (fr) | Canada Revenue Agency |
| HST_CA (Harmonized Sales Tax number) | Harmonized Sales Tax number (en) Harmonized Sales Tax number (fr) | Canada Revenue Agency |
| PST_CA (Provincial Sales Tax) | Provincial Sales Tax (fr) Provincial Sales Tax (en) | Canada Revenue Agency |
| PST_CA_MB (Provincial Sales Tax Manitoba) | Provincial Sales Tax Manitoba (en) | |
| PST_CA_SK (Provincial Sales Tax Saskatchewan) | Provincial Sales Tax Saskatchewan (en) | |
| QST_CA (Quebec Sales Tax) | Quebec Sales Tax (fr) Quebec Sales Tax (en) | Canada Revenue Agency |
Data quality rules
| Data quality rule | Description | Criticality |
|---|---|---|
| Dummy post code detected (CA) | Regular expression/Not available post code Regular expression/One digit multiplied several times post code Regular expression/Ordinal sequence of numbers Regular expression/Single digit post code Regular expression/Very long digits post code. This data quality rule checks whether the post code comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for CA (Canada) are the following: Regular expression/Mononumerical post code with delimeter | ERROR |
| Identifier Qualification (Corporation number (Canada), Data source:CA.CR) | This data quality rule checks the congruency of the given identifier against the identifier maintained as reference for the Corporation number (Canada) | INFO |
| 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:
| ERROR |
| Identifier format inaccurate (Business number (Canada)) | This rule checks the syntax, i.e. format of the Business number in Canada with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation. The Canadian business number consists of exactly 9 numerical 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. | INFO |
| 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. | INFO |
| Identifier format inaccurate (Provincial Sales Tax number (Canada)) | Provincial Sales Tax number (Canada) consists of 11 characters with 2 delimeters: "PST" abbreviation followed by "-" and a delimeter after the first 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 situated in wrong places then the rule is violated. This rule checks the syntax, i.e. format of the Provincial 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. | INFO |
| 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. | INFO |
| Identifier format invalid (Business number (Canada)) | The Canadian business number consists of exactly 9 numerical digits. The rule checks whether there are exactly 9 numerical digits available not considering possible whitespaces or other delimiters between the digits. | ERROR |
| Identifier format invalid (Corporation number (Canada)) | The Canadian corporation number consists of exactly 7 numerical digits. The rule checks whether there are exactly 7 numerical digits available not considering possible whitespaces or other delimiters between the digits. | ERROR |
| 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. | ERROR |
| Identifier format invalid (Provincial Sales Tax number (Canada - Manitoba)) | The Provincial Sales Tax number in Manitoba is a retail sales tax that is payable when a taxable good or service is acquired for personal or business use. Manitoba leverages the Canadian Business Number. The PST number consists of the 9 digits of the business number + optionally the program identifier "MT" and a sequence number formatted like "0001" This rule checks presence of exactly 9 digits 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. | ERROR |
| Identifier format invalid (Provincial Sales Tax number (Canada - Saskatchewan)) | The Provincial Sales Tax number in Saskatchewan is a retail sales tax that is payable when a taxable good or service is acquired for personal or business use. The PST number consists of 7 digits This rule checks presence of exactly 7 digits 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. | ERROR |
| Identifier format invalid (Provincial Sales Tax number (Canada)) | Provincial Sales Tax number (Canada) is a retail sales tax that is payable when a taxable good or service is acquired for personal or business use. The PST number consists of 11 characters: "PST" followed by 8 digits. This rule checks presence of exactly 11 characters corresponding to the format of the Provincial 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. | ERROR |
| 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. | ERROR |
| Identifier missing (Business number (Canada)) | Each legal entity in Canada requires a business number. | WARNING |
| Identifier missing (Corporation number (Canada)) | Each legal entity in Canada requires a corporation number. | WARNING |
| Identifier unknown (Corporation number (Canada)) | This business rule checks the validity of the Corporation number (Canada) against the Canadian Corporation Register. The Corporation number will be judged valid by this rule if it is available in the register. | ERROR |
| Inconsistency between Business Number and GST number (Canada) | The Canadian business number consists of 9 digits. The GST number in Canada is composed as follows: XXXXXXXXX RT YYYY whereby
| ERROR |
| Invalid checksum of BN CA (Canada) | The Canadian Business number consists of exactly 9 digits. It is important to be correct as it is used as part of the GST/HST number as well. For these 9 digits the checkdigit is calculated in the following way:
| ERROR |
| Invalid checksum of GST CA (Canada) |
| ERROR |
| Legal form invalid (Canada) | Each record should have legal form appropriate for the country. | INFO |
| Length of national bank Id invalid (Canada) | This rule checks whether the domestic bank id exceeds the maximum possible length in Canada | ERROR |
| Locality Qualification (Corporation number (Canada), Data source:CA.CR) | This data quality rule checks the congruency of the given city against the city maintained as reference for the Corporation number (Canada) | INFO |
| Mandatory administrative area missing (Canada) | The administrative area (a top-level geographical or political area division in a country) is required (i.e. mandatory) for a complete physical touchpoint in Canada | ERROR |
| Mandatory locality missing (Canada) | The locality is mandatory for street addresses in Canada. | ERROR |
| Mandatory post code missing (Canada) | The post code is mandatory for street addresses in Canada. | ERROR |
| Mandatory thoroughfare missing (Canada) | The thoroughfare is mandatory for street addresses in Canada. | ERROR |
| Name Qualification (Corporation number (Canada), Data source:CA.CR) | This data quality rule checks the congruency of the given name against the name maintained as reference for the Corporation number (Canada) | INFO |
| Post code Qualification (Corporation number (Canada), Data source:CA.CR) | This data quality rule checks the congruency of the given post code against the post code maintained as reference for the Corporation number (Canada) | INFO |
| Post code format invalid (Canada) | This rule checks the post code format of Canada. The system was gradually introduced starting in April 1971 in Ottawa. The letters D, F, I, O, Q, and U are not used to avoid confusion with other letters or numbers. A Canadian postal code is a six-character string that forms part of a postal address in Canada. Like British, Irish and Dutch postcodes, Canada's postal codes are alphanumeric. They are in the format ANA NAN, where A is a letter and N is a digit, with a space separating the third and fourth characters. | ERROR |
| Thoroughfare Qualification (Corporation number (Canada), Data source:CA.CR) | This data quality rule checks the congruency of the given street against the street maintained as reference for the Corporation number (Canada) | INFO |
| Unallowed pattern in name detected (CA) | Regular expression/Aggregated payments Regular expression/No new orders Regular expression/Do not use duplicates note Regular expression/Reference to other record Regular expression/No use note Regular expression/Reference to new record Regular expression/Reference the former name Regular expression/Long number in name Regular expression/Duplicate record note Regular expression/Deletion note Regular expression/Dummy record note Regular expression/Sequence of digits Regular expression/Unsorted keywords Regular expression/Length of name . This data quality rule checks whether the name comprises dubious patterns that may render the record incorrect. The patterns, selected specifically for CA (Canada) are the following: Regular expression/One time vendor | WARNING |
Data sources
| Data quality rule | Name | Content |
|---|---|---|
| CA.CR (data source) | Corporations Register Canada (en) | BUSINESS_PARTNER |
| CA.POST (data source) | Canada post (en) | ADDRESS |
| CA.RQ (data source) | Revenu Quebec (en) |
Banking metadata
| Property | Value |
|---|---|
| Full metadata | Bank accounts in Canada |
| Local name of the national bank ID. Bank ID name | Canadian Transit Number / Routing Numbers |
| The provider (national authorities in most cases) of the national bank ID. Bank ID provider | Canadian Payments Association |
| Currency code for accounting in the given country. Currency code | CAD
|
| Maximum length of the national bank ID. Maximum bank ID length | 26 |