GPCH_TX

(SQL Table)
 Index Back

Source Tax Table CHE

Swiss Source Tax Table - Header record for each Canton

  • Parent Record Of GPCH_TX_CHK_VW GPCH_TX_RATES GPCH_TX_STAR_VW GPCH_TX_TAR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

    Prompt Table: GPCH_SI_STCD_VW

    2 GPCH_TX_PCT_TYPE Character(1) VARCHAR2(1) NOT NULL Percent Type
    0=General
    1=Municipal

    Default Value: 0

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 GPCH_TX_RPT Character(1) VARCHAR2(1) NOT NULL Withholding Tax Cycle
    J=Annually
    M=Monthly
    Q=Quarterly

    Default Value: M

    6 GPCH_TX_MAX_CHLDRN Character(1) VARCHAR2(1) NOT NULL Maximum Children
    7 GPCH_TX_FRQ Character(1) VARCHAR2(1) NOT NULL Withholding Tax Basis
    J=Annually
    M=Monthly

    Default Value: M