CNTRCT_TAX_VW

(SQL View)
 Index Back

Search view for Tax Code


select %substring(b.setcntrlvalue,1,5), b.setid, c.tax_cd, c.descr, c.descrshort, c.tax_cd_type from PS_BUS_UNIT_TBL_AP a, ps_set_cntrl_group b, ps_tax_header_tbl c where a.business_unit = b.setcntrlvalue and b.setid = c.setid and b.rec_group_id = 'FS_17' and c.TAX_CD_TYPE = 'V'

  • Related Language Record: CNTRCT_TAX_VWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 TAX_CD_TYPE Character(1) VARCHAR2(1) NOT NULL Tax Code Type
    S=Sales Tax
    V=VAT