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 NameField TypeColumn TypeDescription
RELATIONSHIPIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Relationship ID (see PSRELATIONSHIP).
SRCNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID
SRCRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name
SRCRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Source Request Message Version
TRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19