VENDOR_SETIDVENDOR_IDPO_IDPO_POA_HDR_HVW3(SQL View) |
Index Back |
|---|---|
POA supplier PO prompt |
| SELECT B.VENDOR_SETID , B.VENDOR_ID , A.PO_ID FROM PS_PO_POA_HDR_HIST A , PS_PO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |