VAT_HEADER_VW

(SQL View)
 Index Back

VAT Tax Code Header Info


SELECT SETID , TAX_CD , DESCR , DESCRSHORT , TAX_CD_TYPE FROM PS_TAX_HEADER_TBL WHERE TAX_CD_TYPE = 'V' AND EXISTS ( SELECT B.TAX_AUTHORITY_CD FROM PS_TAX_CD A , PS_TAX_AUTHORITY B WHERE A.SETID = PS_TAX_HEADER_TBL.SETID AND A.TAX_CD = PS_TAX_HEADER_TBL.TAX_CD AND A.SETID = B.SETID AND A.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD AND B.EFF_STATUS = 'A' AND B.EFFDT=( SELECT MAX(D.EFFDT) FROM PS_TAX_CD C , PS_TAX_AUTHORITY D WHERE C.SETID = PS_TAX_HEADER_TBL.SETID AND C.TAX_CD = PS_TAX_HEADER_TBL.TAX_CD AND C.SETID = D.SETID AND C.TAX_AUTHORITY_CD = D.TAX_AUTHORITY_CD ))

  • Related Language Record: VAT_HEADER_VWLG

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

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: TAX_HEADER_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 TAX_CD_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Code Type
    S=Sales Tax
    V=VAT