PO_TAX_AUTH_WS

(SQL View)
 Index Back

Tax Authority View


select SETID, TAX_AUTHORITY_CD, TAX_PCT from PS_TAX_AUTHORITY A where EFF_STATUS = 'A' and EFFDT = (select MAX(EFFDT) from PS_TAX_AUTHORITY B where A.SETID = B.SETID and A.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD and B.EFFDT <= %currentdatein)

  • Parent record: TAX_AUTH_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    2 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
    3 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent