Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is …
Information on Table Data
- ClassTypeIDs Stores in Table:
- 17200 - Report Menu Change
- 17230 - Report Menu Group
- 17240 - Action Report Menu Item
- 17250 - Word Report Menu Item
- 17260 - SMS Report Menu Item
- 17270 - Crystal Report Menu Item
- 17290 - SQL Report Menu Item
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| ReportMenuItem.AllowGroupPrint | bit | ||||||
| ReportMenuItem.ChangedShowOnMenu | varchar(1) | ||||||
| ReportMenuItem.ChildSortOrder | text | ||||||
| ReportMenuItem.ClassTypeID | int | Identifier for the Type of Object | |||||
| ReportMenuItem.CriteriaOptions | text | ||||||
| ReportMenuItem.Description | text | ||||||
| ReportMenuItem.DeviceOptions | text | ||||||
| ReportMenuItem.FileName | text | ||||||
| ReportMenuItem.HasSeparator | varchar(1) | ||||||
| ReportMenuItem.ID | int | Primary Key for the Table | |||||
| ReportMenuItem.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| ReportMenuItem.IsSystem | bit | Used to Mark Required Records | |||||
| ReportMenuItem.LastReportModifiedDate | datetime | ||||||
| ReportMenuItem.MenuItemName | varchar(40) | ||||||
| ReportMenuItem.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| ReportMenuItem.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| ReportMenuItem.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| ReportMenuItem.OtherOptions | text | ||||||
| ReportMenuItem.ParentClassTypeID | int | ||||||
| ReportMenuItem.ParentID | int | ID of Category/Group Above | |||||
| ReportMenuItem.ParentStoreID | int | Not Used. | |||||
| ReportMenuItem.PrintOption | int | ||||||
| ReportMenuItem.RequiredModules | text | ||||||
| ReportMenuItem.SecurityRightClassTypeID | int | ||||||
| ReportMenuItem.SecurityRightID | int | ||||||
| ReportMenuItem.SeqID | int | ||||||
| ReportMenuItem.Shortcut | varchar(20) | ||||||
| ReportMenuItem.SortingOptions | text | ||||||
| ReportMenuItem.StoreID | int | Not Used. | |||||
| ReportMenuItem.SystemReportClassTypeID | int | ||||||
| ReportMenuItem.SystemReportID | int | ||||||
| ReportMenuItem.TemplateID | int | ||||||
| ReportMenuItem.TemplateStoreID | int | Not Used. | |||||
| ReportMenuItem.UseSystemReport | bit |
Related Tables
You could leave a comment if you were logged in.