RELATIONSHIPIDSRCNODESRCRQSTMSGNAMESRCRQSTMSGVERTRXTYPEIA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
PSRELSRCTYPVW | index back |
|---|
| SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , B.RQSTMSGNAME , B.RQSTMSGVER , B.TRXTYPE FROM PSRELATIONSHIP A , PSNODETRX B WHERE A.NODE1 = B.MSGNODENAME OR A.NODE2 = B.MSGNODENAME |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| RELATIONSHIPID | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Relationship ID (see PSRELATIONSHIP). |
| SRCNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| SRCRQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| SRCRQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Source Request Message Version |
| TRXTYPE | Character(4) | VARCHAR2(4) NOT NULL | Integration Broker Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |
| index back | (c)David Kurtz 2019, www.go-faster.co.uk | PeopleTools 8.54 PTRef generated on 09-JUN-19 |