EM_LOCL_VNDR_VW

(SQL View)
Index Back

Local Adm. Supplier Permission

MarketPay Security This SQLview is used as a prompt table behind Supplier IDs in the Seller Security page.This list is retreived from PS_SUPPLIER_USER, where the Host or System Administrator has entered the Seller Administrator's SUPPLIER_IDs from Maintain Suppliers, Use, Supplier User.

SELECT DISTINCT A.OPRID ,A.VENDOR_ID , B.NAME1 ,A.SETID FROM PS_VENDOR_USER A , PS_VENDOR B WHERE B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID

  • Related Language Record: EM_LOCL_VN_LGVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR

    3 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL