EM_VAT_CD_VW

(SQL View)
 Index Back

VAT Tax Code Header Info


SELECT A.SETID , A.TAX_CD , A.DESCR , B.TAX_AUTHORITY_CD , C.DESCR , C.DESCRSHORT , D.TAX_PCT FROM PS_TAX_HEADER_TBL A , PS_TAX_CD B , PS_TAX_AUTH_HDR C , PS_TAX_AUTHORITY D WHERE A.TAX_CD_TYPE = 'V' AND B.SETID = A.SETID AND B.TAX_CD = A.TAX_CD AND C.SETID = A.SETID AND C.TAX_AUTHORITY_CD = B.TAX_AUTHORITY_CD AND D.SETID = A.SETID AND D.TAX_AUTHORITY_CD = C.TAX_AUTHORITY_CD AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_TAX_AUTHORITY D1 WHERE D1.SETID = A.SETID AND D1.TAX_AUTHORITY_CD = C.TAX_AUTHORITY_CD AND D1.EFFDT <= %CurrentDateIn)

  • 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 TAX_AUTHORITY_CD Character(3) VARCHAR2(3) NOT NULL Tax Authority
    5 DESCR_2 Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent