Updated: 2009-09-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table stores User Constants
Information on Table Data
- ClassTypeIDs Stores in Table:
- 700 - Store Constant
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
StoreConstant.CategoryClassTypeID | int | ||||||
StoreConstant.CategoryID | int | ID of Category for Store Constant | sql_structure_-_element_table.ID where ClassTypeID 701 | ||||
StoreConstant.CategoryStoreID | int | Not Used. | |||||
StoreConstant.ClassTypeID | int | Identifier for the Type of Object | |||||
StoreConstant.ConstantValue | decimal(18, 4) | ||||||
StoreConstant.Formula | text | Value of User Constant | |||||
StoreConstant.ID | int | Primary Key Field | |||||
StoreConstant.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
StoreConstant.IsSystem | bit | Used to Mark Required Records | |||||
StoreConstant.ItemProperties | text | ||||||
StoreConstant.ItemText | nvarchar(50) | Name of User Constant | |||||
StoreConstant.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
StoreConstant.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
StoreConstant.ModifiedDate | datetime | DateTime this Record was last modified | |||||
StoreConstant.SeqID | int | ||||||
StoreConstant.StoreID | int | Not Used. | |||||
StoreConstant.UnitID | int |
Related Tables
You could leave a comment if you were logged in.