PSIBMSGCAT_L2VW

(SQL View)
Index Back

IB view into message catalog.


SELECT MESSAGE_SET_NBR , MESSAGE_NBR , LANGUAGE_CD , MESSAGE_TEXT , DESCRLONG FROM PSMSGCATLANG

  • Related Language Record for PSIBMSGCAT_VW2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_MESSAGE_SET Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
    2 IB_MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    5 DESCRLONG Long Character CLOB Long Description