PSRELSRCTYPVW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RELATIONSHIPID | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Relationship ID (see PSRELATIONSHIP). |
2 | SRCNODE | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
3 | SRCRQSTMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
4 | SRCRQSTMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Integration Broker Source Request Message Version |
5 | TRXTYPE | Character(4) | VARCHAR2(4) NOT NULL |
Integration Broker Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |