RELATIONSHIPIDTGTNODETRXTYPEIA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
PSRELTGTTYPVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , 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 | TGTNODE |
Character(30) | VARCHAR2(30) NOT NULL | Integration Server Business Entity ID |
| 3 | TRXTYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Integration Broker Transaction Type
IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous |