{$page} 



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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]