EM_LOCL_VNDR_VW(SQL View) |
Index Back |
---|---|
Local Adm. Supplier PermissionMarketPay 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 |
# | 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 |