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 NameField TypeColumn TypeDescription
IB_XFRMMESSAGE1Character(61)VARCHAR2(61) NOT NULLMessage.Ver into Transform 1
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
APMSGVERCharacter(30)VARCHAR2(30) NOT NULLMessage Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19