VENDOR_SETID_VW

(SQL View)
Index Back

Run Control AP Supplier 4


SELECT A.SETID , A.VENDOR_ID FROM PS_VENDOR A , PS_SP_SETVC_NONVW B WHERE A.SETID = B.SETID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETVC_NONVW

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR