INVOI_VNDUSR_VW

(SQL View)
 Index Back

Supplier Invoices

This view is used by the invoices screen to list the invoices related to supplier and userid

SELECT DISTINCT a.VENDOR_SETID ,A.vendor_id ,A.INVOICE_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 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).