OPRIDVENDOR_SETIDVENDOR_IDBUSINESS_UNIT_POPO_IDLANGUAGE_CDEM_VCHR_PO_LNG1(SQL View) |
Index Back |
|---|---|
Seller PO Prompt View |
| SELECT D.OPRID , A.VENDOR_SETID , B.VENDOR_ID , A.BUSINESS_UNIT , A.PO_ID , BL.LANGUAGE_CD , BL.VENDOR_NAME_SHORT , BL.NAME1 FROM PS_PO_HDR_FS A , PS_VENDOR B , PS_VENDOR_LANG BL , PS_VENDOR_USER D WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND D.SETID = A.VENDOR_SETID AND D.VENDOR_ID = A.VENDOR_ID AND B.SETID = BL.SETID AND B.VENDOR_ID = BL.VENDOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 3 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 4 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 5 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL | Short Vendor Name |
| 8 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |