{$page} 



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|Element]].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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]