ACLCOMPONENTLV2

index back

SELECT A.MENUNAME , A.ITEMNUM , C.LANGUAGE_CD , A.BARNAME , A.ITEMNAME , C.BARLABEL , C.ITEMLABEL , B.ACTIONS , A.PNLGRPNAME , B.MARKET FROM PSMENUITEM A , PSPNLGRPDEFN B , PSMENUITEMLANG C WHERE A.ITEMTYPE = 5 AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND A.MENUNAME=C.MENUNAME AND A.BARNAME=C.BARNAME AND A.ITEMNAME=C.ITEMNAME

  • Related language record for ACLCOMPONENT_V2
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    ITEMNUMNumber(4,0)SMALLINT NOT NULLItem Number
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
    BARITEMNAMECharacter(30)VARCHAR2(30) NOT NULLBar Item Name
    BARLABELCharacter(10)VARCHAR2(10) NOT NULLMenu Bar Label
    ITEMLABELCharacter(30)VARCHAR2(30) NOT NULLMenu Item Label
    ACTIONSNumber(4,0)SMALLINT NOT NULLActions
    PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
    MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19