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

Prompt Table: PSMENUDEFN

BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLItem Name
ITEMNUMNumber(4,0)SMALLINT NOT NULLItem Number
ITEMTYPENumber(2,0)SMALLINT NOT NULLItem Type
PTLT_TASK_CODECharacter(30)VARCHAR2(30) NOT NULLTask Code
PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
MARKETCharacter(3)VARCHAR2(3) NOT NULLMarket translate values

Default: GBL

BARLABELCharacter(10)VARCHAR2(10) NOT NULLMenu Bar Label
ITEMLABELCharacter(30)VARCHAR2(30) NOT NULLMenu Item Label
XFERCOUNTNumber(4,0)SMALLINT NOT NULLPanel Transfer Count
SEARCHRECNAMECharacter(15)VARCHAR2(15) NOT NULLSearch Record Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19