PSNODETRX_VW2

index back

SELECT b.MSGNODENAME , a.TRXTYPE , a.EFFDT , a.RQSTMSGNAME , a.RQSTMSGVER , b.DESCR , a.RESPMSGNAME , a.RESPMSGVER FROM PSNODETRX a , PSMSGNODEDEFN b WHERE a.MSGNODENAME = b.MSGNODENAME AND a.RQSTMSGNAME IN ( SELECT MSGNAME FROM PSMSGREC)

PeopleSoft Field NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
TRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

RQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSMSGDEFNVW1

RQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Request Message Version

Prompt Table: PSRQSTMSGVERVW

DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
RESPMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Response Message Name
RESPMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Response Message Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19