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 NameField TypeColumn TypeDescription
    MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    ITEMNUMNumber(4,0)SMALLINT NOT NULLItem Number
    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