HRS_VNDR_TRANS

(SQL Table)
Index Back

Vendor-Transaction Table

Vendor - Transaction Association Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HRS_VNDR_TRANS_ID Number(15,0) DECIMAL(15) NOT NULL Id specific to a Vendor and Transaction
2 HRS_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID
3 HRS_VERSION Number(15,0) DECIMAL(15) NOT NULL used as version for numerous integration objects
4 HRS_TRANSACTION_ID Character(30) VARCHAR2(30) NOT NULL Transaction ID
5 HRS_XSLT_REQ_ID Number(15,0) DECIMAL(15) NOT NULL A reference to an XSLT ID used to transform a request for a transaction
6 HRS_XSLT_RES_ID Number(15,0) DECIMAL(15) NOT NULL A reference to an XSLT ID used to transform a response for a transaction
7 HRS_XSLT_ASYNC_ID Number(15,0) DECIMAL(15) NOT NULL XSLT ID
8 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
9 HRS_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