MAINTAIN CANADIAN TAX RATES#
Canadian Tax Rates are the tax rates for all federally or provincially mandated deductions and contributions, such as pensions (CPP, QPP), employment insurance (EI), income tax (federal and provincial).The Canadian Tax Rate detail contains all of the rates, limits, constants and amounts that are to be used for legislative calculations, recorded by effective date.
CCRA supplies the legislated rates, effective January 1st, and sometimes July 1st, of each year. The Canadian Tax Rates file is provided. A new file is provided whenever there is a change in the tax rates.
Canadian Tax Rates are maintained through the Maintain CDN Tax Rates (IPCT) form.
EHT, MHE, QHIP Provincial Health Insurance rate are user-defined on the IDGV form by registration type for the province.
CDN Tax Rates data is stored in the P2K_PR_CDN_TAX_RATES and P2K_PR_CDN_TAX_RATE_DETAILS tables.
- Effective
- This field displays the effective date of the tax rate. Effective is a mandatory date field.
- Expiry
- This field displays the expiry date of the tax rate. Expiry is a mandatory date field.
- Change Reason
- This field displays the ‘Change Reason’ code, which provides the rationale as to why information has been created or changed as of an effective date. Change_Reason is a 16-character alphanumeric optional field users may fill by using the LOV(F9) provided.
- Province
- This field shows the province to which the rate detail belongs. This field may be blank if using federal rates.
- Tax Code
- This field identifies the tax rate code preassigned to hold a specific rate given by CCRA. Tax_Rate_Code is a mandatory 16 character alphanumeric field.
- Description
- This field shows the provided description of the rate. Description is a 50 character alphanumeric mandatory field that you must manually enter.
- Limit/Amount
- This field shows the annual limit to which the tax rate applies. Tax_Limit is an optional 18 digit numeric field that is supplied.
- Tax Rate
- This field holds the tax rate amount.Tax_Rate is an optional 18 digit numeric field that is supplied.
- Tax Constant
- This field shows the constant value associated with the tax rate. Tax_Constant is an optional 18 digit numeric field that is supplied.
