VENDOR_NAME_SHORTOPRIDEM_VEND2_OPR_VW(SQL View) |
Index Back |
|---|---|
Supplier Security Drop Down ViThis view is used by the voucher inquiries screen to list the supplier's related to an OPRID. Market Pay Module |
| SELECT DISTINCT v.vendor_name_short , sec.oprid FROM PS_EM_AGREEMENT ag , ps_sec_bu_opr sec , ps_vendor v WHERE sec.business_unit = ag.setid AND v.setid = ag.vendor_setid AND v.vendor_id = ag.vendor_id AND v.vendor_status = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_NAME_SHORT |
Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |