ACLCOMPONENT_V2

index back

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

  • Related language record: ACLCOMPONENTLV2
  • PeopleSoft Field Name Field Type Column Type Description
    MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
    BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
    ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
    ACTIONS Number(4,0) SMALLINT NOT NULL Actions
    PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19