PSMSGVERCON4_VW |
index back |
---|---|
IB Messages and Versions |
SELECT DISTINCT %TrimSubstr(V.MSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(V.APMSGVER,1,30) , V.MSGNAME , V.APMSGVER FROM PSMSGVER V , PSMSGREC R WHERE V.MSGNAME = R.MSGNAME AND V.APMSGVER = R.APMSGVER AND V.IB_PARTS = 1 |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Character(61) | VARCHAR2(61) NOT NULL | Message.Ver into Transform 1 |
MSGNAME | Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |
APMSGVER | Character(30) | VARCHAR2(30) NOT NULL | Message Version |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |