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.