EM_VCHID_USR_VW

(SQL View)
 Index Back

Supplier Security Drop Down Vi

This view is used by the voucher inquiries screen to list the suppliers related to an OPRID. Market Pay Module

SELECT DISTINCT a.voucher_id , b.oprid FROM PS_VOUCHER a , ps_vendor_user b WHERE b.setid = a.vendor_setid AND b.vendor_id = a.vendor_id

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).