PSMSGVERCON2_VW

(SQL View)
Index Back

IB Messages and Versions

Shows concatenated messages and corresponding versions.

SELECT %TrimSubstr(MSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(APMSGVER,1,30) FROM PSMSGVER WHERE IB_PARTS = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_XFRMMESSAGE2 Character(61) VARCHAR2(61) NOT NULL Message.Ver out of Transforms