PSMSGVERCON4_VW

index back

IB Messages and Versions

Shows concatenated messages and corresponding 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
IB_XFRMMESSAGE1 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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19