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 Name Field Type Column Type Description
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

RQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSMSGDEFNVW1

RQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Request Message Version

Prompt Table: PSRQSTMSGVERVW

DESCR Character(30) VARCHAR2(30) NOT NULL Description
RESPMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Response Message Name
RESPMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Server Response Message Version
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19