Table Name:	menu_item
Table Number:	319
Group:	User Interface
Description:	Describes a particular pulldown menu item; used in defining privileges to menu commands
Flags:
Baseline/Custom:	Baseline

select * from table_menu_item

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
description	CHAR	varchar		255			Description of the item
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dimmable	LONG	int				DIRECT	Indicates whether the menu item can be dimmed or not	Search (1)
flags	LONG	int				DIRECT	Attribute for the menu item; e.g., when invoked from different platform whether it is visible or not
function_id	LONG	int				DIRECT	Reserved; not used
icon_id	LONG	int	16			DIRECT	Id number of the item's icon
mac_accel_flag	LONG	int				DIRECT	Accelerator key flag for Mac platform
mac_accel_key	LONG	int				DIRECT	Accelerator key for Mac platform
mac_title	CHAR	varchar		80			Display title for Mac platform
menu_bar	LONG	int				DIRECT	ID of the menu bar for the item	Search (1)
menu_tag	LONG	int				DIRECT	ID of the menu item. Used to bind menu item with its callback function	Search (1)
mkey	LONG	int				DIRECT	ASCII code for the letter used to invoke the item
mtif_accel_flag	LONG	int				DIRECT	Accelerator key flag for Motif platform
mtif_accel_key	LONG	int				DIRECT	Accelerator key for Motif platform
mtif_title	CHAR	varchar		80			Display title for Motif platform
name	CHAR	varchar		80			Internal name of the menu item
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
position	LONG	int				DIRECT	Display order for the item in its pull down menu
pulldown	CHAR	varchar		80			Name of the parent menu item within a hierarchical series of items within items. Reserved; not used
state	LONG	int				DIRECT	Reserved; not used
subtype	LONG	tinyint			0	DIRECT	Subtype of the item; i.e., 0=Action, 1=Query, 2=Related Object, default=0
title	CHAR	varchar	2	80			Display name of item as it appears in the pulldown menu
type	LONG	tinyint			0	DIRECT	Type of the item; i.e., 0=Side Menu, 1=Main Menu, default=0
win_accel_flag	LONG	int				DIRECT	Accelerator key flag for the form's platform
win_accel_key	LONG	int				DIRECT	Accelerator key for form's platform
win_title	CHAR	varchar		80			Display name for form's platform

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
menu_item2menu_bar	MTO	menu_bar	menu_bar2menu_item	Menu bar under which the menu item appears		Search (1)
role_for2mui_mui_role	OTM	mui_mui_role	role_for2menu_item	Menu item roles received by the item
player2mui_mui_role	OTM	mui_mui_role	player2menu_item	Menu item roles played by the item
menu_item2privclass	MTM	privclass	privclass2menu_item	Privilege classes for which the menu item is disabled	mtm_privclass3_ menu_item1	Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
menu_item_index	name:menu_item2menu_bar	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_pulldown_position	pulldown, position	clustered located on PRIMARY
menu_item_index	name, menu_item2menu_bar	nonclustered, unique located on PRIMARY
objindex	objid	nonclustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
323	priv_menu_item	menu_bar, menu_item, privclass

My Recent Objects

menu_item

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog