CAN_TAX_TYPE

(SQL Table)
 Index Back

Tax Type Table (Can)

Tax Type Table (Canada).

  • Related Language Record: CAN_TX_TYPE_LNG

  • 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