RQSTMSGNAMEMSGNODENAMEPTPPB_IBMSGNDVW(SQL View) |
Index Back |
|---|---|
Message Node View for PW |
| SELECT A.RQSTMSGNAME ,B.MSGNODENAME ,A.RESPMSGNAME , B.DESCR FROM PSNODETRX A , PSMSGNODEDEFN B WHERE A.TRXTYPE = 'OS' AND A.MSGNODENAME = B.MSGNODENAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RQSTMSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Integration Server Request Message Name |
| 2 | MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| 3 | RESPMSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Integration Server Response Message Name |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |