GPCH_TX_SRCH_LN

(SQL View)
 Index Back

Source Tax Search

Source Tax Search

SELECT A.GPCH_TX_CANTON , B.DESCR , A.GPCH_TX_PCT_TYPE , B.LANGUAGE_CD FROM PS_GPCH_TX A , PS_STATE_TBL_LANG 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 for GPCH_TX_SRCH

    • # 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

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code