PTLT_MNUTASK_VW

index back

SELECT MENUNAME , BARNAME , ITEMNAME , ITEMNUM , ITEMTYPE , %Sql(PTLT_COMP_CODE) , PNLGRPNAME , MARKET , BARLABEL , ITEMLABEL , XFERCOUNT , SEARCHRECNAME FROM PSMENUITEM

PeopleSoft Field Name Field Type Column Type Description
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN

BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
ITEMTYPE Number(2,0) SMALLINT NOT NULL Item Type
PTLT_TASK_CODE Character(30) VARCHAR2(30) NOT NULL Task Code
PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
MARKET Character(3) VARCHAR2(3) NOT NULL Market translate values

Default: GBL

BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
XFERCOUNT Number(4,0) SMALLINT NOT NULL Panel Transfer Count
SEARCHRECNAME Character(15) VARCHAR2(15) NOT NULL Search Record Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19