EM_VCHR_INQ_LNG

(SQL View)
 Index Back

Voucher Inquiry view

This view is used by the Market Pay Module to retrieve all of the voucher inquiry page rows.

SELECT DISTINCT a.business_unit , a.voucher_id , sec.oprid , bul.language_cd , bul.descrshort , bl.vendor_name_short , tl.descrshort FROM PS_VOUCHER a , ps_vendor b , ps_vendor_lang bl , ps_sec_bu_opr sec , ps_pymnt_vchr_xref d , ps_bus_unit_tbl_fs bu , ps_bus_unit_lang bul , ps_pymt_trms_hdr t , ps_pymt_tr_hd_lang tl WHERE sec.business_unit = a.business_unit AND a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND b.setid = bl.setid AND b.vendor_id = bl.vendor_id AND a.business_unit = d.business_unit AND a.voucher_id = d.voucher_id AND a.business_unit = bu.business_unit AND bu.business_unit = bul.business_unit AND t.setid = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE REC_GROUP_ID = 'FS_14' AND RECNAME = 'PYMT_TRMS_HDR' AND SETCNTRLVALUE = a.business_unit) AND a.pymnt_terms_cd = t.pymnt_terms_cd AND t.setid = tl.setid AND t.pymnt_terms_cd = tl.pymnt_terms_cd

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EM_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Buyer
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 EM_BU_NAME_SHORT Character(10) VARCHAR2(10) NOT NULL Buyer Short Name
6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
7 EM_TERM_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Payment Term