Updated: 2009-mm-dd

Version: Control 4.x

Table Purpose, Usage, and Notes

This table is used to store small elements that mostly just have a name, description, and active options.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 350 - Title
    • 701 - Store Constant Category
    • 1750 - Activity Pick List
    • 1751 - Activity Pick List Item
    • 1810 - Signature Usage Type
    • 2600 - Service Ticket Type
    • 4000 - Address Type
    • 4101 - Phone Number Type
    • 5004 - Postal Code Tax Class List
    • 5500 - Marketing List
    • 5511 - Prospect (Company) Stage
    • 5512 - Client (Company) Stage
    • 5600 - DispositionList
    • 5601 - Disposition
    • 6010 - Security Right Template
    • 6050 - WebPro Security Right Template
    • 6130 - Shipping Methods
    • 13000 - Commission Plan
    • 26000 - LineItemStage
    • 26001 - ServiceTicketStage
    • 26002 - VendorStage

Table Structure

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

Related Tables

You could leave a comment if you were logged in.