FO_VNDR_TRANS_ID10=Log Everything
20=Log XML on Error
30=Never Log XML
FO_VTRANS_VW(SQL View) |
Index Back |
|---|---|
Supplier-Transaction TableSupplier - Transaction Association Table |
| SELECT A.FO_VNDR_TRANS_ID , A.FO_OI_VENDOR_ID , A.FO_TRANSACT_ID , A.FO_XSLT_REQ_ID , A.FO_XSLT_RES_ID , A.FO_XSLT_ASYNC_ID , A.MSGNODENAME , A.FO_LOG_STYLE FROM PS_FO_VNDR_TRANS A , PS_FO_TG_SERVICE B , PS_FO_VENDOR C WHERE A.FO_OI_VENDOR_ID=C.FO_OI_VENDOR_ID AND A.FO_OI_VERSION=C.FO_OI_VERSION AND A.FO_TRANSACT_ID=B.FO_TRANSACT_ID AND B.FO_OI_TG_ID=C.FO_OI_TG_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FO_VNDR_TRANS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Id specific to a Vendor and Transaction |
| 2 | FO_OI_VENDOR_ID | Number(15,0) | DECIMAL(15) NOT NULL | Integration Vendor ID |
| 3 | FO_TRANSACT_ID | Character(30) | VARCHAR2(30) NOT NULL | Transaction ID |
| 4 | FO_XSLT_REQ_ID | Number(15,0) | DECIMAL(15) NOT NULL | A reference to an XSLT ID used to transform a request for a transaction |
| 5 | FO_XSLT_RES_ID | Number(15,0) | DECIMAL(15) NOT NULL | A reference to an XSLT ID used to transform a response for a transaction |
| 6 | FO_XSLT_ASYNC_ID | Number(15,0) | DECIMAL(15) NOT NULL | XSLT ID |
| 7 | MSGNODENAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 8 | FO_LOG_STYLE | Character(3) | VARCHAR2(3) NOT NULL |
The logging style for integrations
10=Log Everything 20=Log XML on Error 30=Never Log XML |