Table Name:value_item
Table Number:266
Group:User Interface
Description:Stores context sensitive menu items, methods, or properties for a form (window_db) or context sensitive menu items for a control (control_db)
Flags: 
Baseline/Custom:Baseline
select * from table_value_item
Keyboard shortcuts available
Fields:
Field NameCommon TypeDatabase TypeGeneric Field IDArray SizeDefaultFlagsCommentField Used in Views
column_ctl_idLONGint  -1 DIRECT Control ID for a grid column  
ctl_idLONGint   DIRECT ID of the control for the current value item  
devLONGint151 1 DIRECT, ALLOW_NULL Row version number for mobile distribution purposes  
idLONGint   DIRECT Display sequence number of the value item within its control  
intval1LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval10LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval2LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval3LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval4LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval5LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval6LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval7LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval8LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item  
intval9LONGint   DIRECT Multi-purpose integer attribute; use depends on type of the control that owns the item Search (2)
objidLONGint3  DIRECT Internal record number Search (3)
value1CHARvarchar 80  Multipurpose string attribute for the value item; use depends on the control to which it belongs Search (3)
value2CHARvarchar 255  Multipurpose string attribute for the value item; use depends on the control to which it belongs Search (2)
value3CHARvarchar 80  Multipurpose string attribute for the value item; use depends on the control to which it belongs  
value4CHARvarchar 80  Multipurpose string attribute for the value item; use depends on the control to which it belongs  
value5CHARvarchar 80  Multipurpose string attribute for the value item; use depends on the control to which it belongs  
Relations:
RelationTypeTarget ObjectInverse RelationCommentFlagsMTM TableUsed in Views
value2control_dbMTOcontrol_dbitem2value_itemRelated control   Search (3)
value_item2privclassMTMprivclassprivclass2value_itemAssigned privclasses  mtm_privclass7_
value_item2		Search (1)
item2window_dbMTOwindow_dbwindow_db2itemRelated form   Search (2)
Indexes: (Defined in Clarify Schema)
Index NameFieldsFlags
value_itemindexid:ctl_id:item2window_dbUNIQUE 
Indexes (Defined in Database):
Index NameFieldsAdditional Information
ind_item2window_dbitem2window_db, ctl_id, idclustered located on PRIMARY
objindexobjidnonclustered, unique located on PRIMARY
value_itemindexid, ctl_id, item2window_dbnonclustered, unique located on PRIMARY
My Recent Objects
value_item      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user