FO_OI_VENDOR_IDFO_VNDR_TRANS_IDFO_VTRANS_DDWN(SQL View) |
Index Back |
|---|---|
Supplier Transaction DropDownA record used to populate the Supplier-Transaction Drop Down on the Supplier Page |
| SELECT DISTINCT A.FO_OI_VENDOR_ID , A.FO_VNDR_TRANS_ID , A.FO_TRANSACT_ID , C.FO_TRANS_NAME FROM PS_FO_VNDR_TRANS A , PS_FO_OI_VALMAP B , PS_FO_SOA_SRV_VW C WHERE B.FO_OBJECT_ID=A.FO_VNDR_TRANS_ID AND B.FO_OI_USE_TYPE='20' AND A.FO_TRANSACT_ID=C.FO_TRANSACT_ID AND A.FO_OI_VERSION = ( SELECT MAX (D.FO_OI_VERSION) FROM PS_FO_VENDOR D WHERE D.FO_OI_VENDOR_ID=A.FO_OI_VENDOR_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_OI_VENDOR_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Integration Vendor ID |
| 2 | FO_VNDR_TRANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Id specific to a Vendor and Transaction |
| 3 | FO_TRANSACT_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction ID |
| 4 | FO_TRANS_NAME | Character(52) | VARCHAR2(52) NOT NULL | Transaction Name |