FO_EMPL_VNDR_VW

(SQL View)
Index Back

Employee Supplier Information


SELECT A.EMPLID ,B.SETID ,B.VENDOR_ID ,B.DEFAULT_LOC FROM PS_FO_VEND_AVE A , PS_FO_AVE_VNDR_TBL B WHERE A.SETID=B.SETID AND A.VENDOR_ID=B.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location