Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • xxxxx -
    • xxxxx -

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
ReportElement.ClassTypeID int Identifier for the Type of Object
ReportElement.DefaultIncomeIDOV bit
ReportElement.Description nvarchar(50)
ReportElement.ElementName nvarchar(50)
ReportElement.EndDate datetime
ReportElement.ExpenseClassTypeID int
ReportElement.ExpenseID int
ReportElement.ExpenseIDOV bit
ReportElement.FamilyClassTypeID int
ReportElement.FamilyID int
ReportElement.FamilyStoreID int Not Used.
ReportElement.GLDepartmentClassTypeID int
ReportElement.GLDepartmentID int
ReportElement.GLDepartmentIDOV bit
ReportElement.ID int Primary Key for the Table
ReportElement.IncomeClassTypeID int
ReportElement.IncomeID int
ReportElement.IncomeStoreID int Not Used.
ReportElement.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
ReportElement.IsSystem bit Used to Mark Required Records
ReportElement.ItemPrefix varchar(25)
ReportElement.LinkClassTypeID int
ReportElement.LinkID int
ReportElement.LinkStoreID int Not Used.
ReportElement.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
ReportElement.ModifiedByUser nvarchar(25) Windows User who last modified this record
ReportElement.ModifiedDate SmallDatetime DateTime this Record was last modified
ReportElement.ParentClassTypeID int
ReportElement.ParentID int ID of Category/Group Above
ReportElement.ParentStoreID int Not Used.
ReportElement.PartType int
ReportElement.SeqID int
ReportElement.SortIndex float
ReportElement.StartDate datetime
ReportElement.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.