CAN_TAX_TYPE (SQL Table)	Index Back
Tax Type Table (Can) Tax Type Table (Canada).

CAN_TAX_TYPE

(SQL Table)

Tax Type Table (Can)

Tax Type Table (Canada).

Parent Record Of CAN_TAX_CLASS CAN_TAX_HLCLASS CAN_TAX_STCLASS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TAX_TYPE_CAN Character(4) VARCHAR2(4) NOT NULL Tax Type

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 SOURCE_TAX Character(1) VARCHAR2(1) NOT NULL This field is used to indicate the type of tax transaction for a given Tax Type.
G=Goods and Services Tax
H=Health and Payroll Taxes
O=Statutory Deductions
P=Provincial Sales Tax
Default Value: O

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SETID_TBL

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_TAX_VW

7 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
Prompt Table: PROVINCE_NM_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TAX_TYPE_CAN	Character(4)	VARCHAR2(4) NOT NULL	Tax Type
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	SOURCE_TAX	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate the type of tax transaction for a given Tax Type. G=Goods and Services Tax H=Health and Payroll Taxes O=Statutory Deductions P=Provincial Sales Tax Default Value: O
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SETID_TBL
6	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_TAX_VW
7	PROVINCE	Character(6)	VARCHAR2(6) NOT NULL	Province Prompt Table: PROVINCE_NM_VW