GPES_TAX2_SH_VW

(SQL View)
 Index Back

IRPF Search record

IRPF Search record

SELECT DISTINCT A.COMPANY , A.GPES_TAX_LOCATION , A.GPES_YEAR , A.GPES_MONTH , B.DESCR ,C.DESCR FROM PS_GPES_TAX2_RSLT A LEFT OUTER JOIN PS_COMPANY_TBL B ON A.COMPANY = B.COMPANY , PS_GPES_TAX_LOCATN C WHERE A.GPES_TAX_LOCATION = C.GPES_TAX_LOCATION AND B.EFFDT = (SELECT MAX(D.EFFDT) FROM PS_COMPANY_TBL D WHERE D.COMPANY = A.COMPANY AND D.EFFDT <= A.EFFDT) AND C.EFFDT = (SELECT MAX(E.EFFDT) FROM PS_GPES_TAX_LOCATN E WHERE E.GPES_TAX_LOCATION = A.GPES_TAX_LOCATION AND E.EFFDT <= A.EFFDT)

  • Related Language Record: GPES_TX2_SH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GPES_TAX_LOCATION Character(5) VARCHAR2(5) NOT NULL Fiscal Territory. This field is used to populate the GP Write Array, which is used to generate the Tax Reports.

    Prompt Table: GPES_TAX_LOCATN

    3 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
    4 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR1 Character(30) VARCHAR2(30) NOT NULL Description