HRS_VNDR_TRANS(SQL Table) |
Index Back |
---|---|
Vendor-Transaction TableVendor - 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 |