CAN_TAX_STCLASS

(SQL Table)
Index Back

Tax Class (Canada)

Tax Class (Canada)

  • Parent record: CAN_TAX_TYPE
  • # 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 DED_SLSTX_CLASS Character(1) VARCHAR2(1) NOT NULL Sales Tax Class
    B=None
    G=Goods and Services Tax
    H=Harmonized Sales Tax
    I=Provincial Sales Tax Insurance
    P=Provincial Sales Tax
    Q=QC Prov Sales Tax Insurance
    S=QC Provincial Sales Tax
    T=Provincial Premium Tax
    U=QC Provincial Premium Tax

    Prompt Table: %RECNAME_EDIT