SRM_DB_ODPO_VNS

(SQL View)
 Index Back

Supplier Search

ODPS

SELECT DISTINCT A.BUYER_ID , A.SETID , A.VENDOR_ID , A.VNDR_NAME_SHRT_USR FROM PS_SRM_DB_ODPO_VW2 A , PS_VENDOR B WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID

  • Parent record: SRM_DB_ODPO_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    4 VNDR_NAME_SHRT_USR Character(10) VARCHAR2(10) NOT NULL Short Vendor Name