GPCH_TX_SRCH

(SQL View)
 Index Back

Source Tax Search

Source Tax Search

SELECT A.GPCH_TX_CANTON , B.DESCR , A.GPCH_TX_PCT_TYPE FROM PS_GPCH_TX A , PS_STATE_TBL B WHERE B.COUNTRY = 'CHE' AND A.GPCH_TX_CANTON = B.STATE AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GPCH_TX A1 WHERE A1.GPCH_TX_CANTON = A.GPCH_TX_CANTON AND A1.GPCH_TX_PCT_TYPE = A.GPCH_TX_PCT_TYPE)

  • Related Language Record: GPCH_TX_SRCH_LN

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 GPCH_TX_PCT_TYPE Character(1) VARCHAR2(1) NOT NULL Percent Type
    0=General
    1=Municipal

    Default Value: 0