Updated: 2009-09-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table stores the global and local (product-overridden) variables for Control.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 14505 - Global Variable Definition
- 14515 - Pricing Plan Variable (Overridden Definition)
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
Variable.AltDependentListName | varchar(40) | ||||||
Variable.ClassTypeID | int | Identifier for the Type of Object | |||||
Variable.Formula | text | ||||||
Variable.ID | int | Primary Key for the Table | |||||
Variable.ImageLinkName | varchar(40) | ||||||
Variable.ImageSaveType | int | ||||||
Variable.InputUnitID | int | ||||||
Variable.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
Variable.IsLimitedToList | bit | ||||||
Variable.IsModifierVariable | bit | ||||||
Variable.IsProductionVar | bit | ||||||
Variable.IsRequired | bit | ||||||
Variable.IsRequiredFormula | text | ||||||
Variable.IsSystem | bit | Used to Mark Required Records | |||||
Variable.MaxValue | float | ||||||
Variable.MaxValueFormula | text | ||||||
Variable.MinValue | float | ||||||
Variable.MinValueFormula | text | ||||||
Variable.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
Variable.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
Variable.ModifiedDate | datetime | DateTime this Record was last modified | |||||
Variable.Notes | text | ||||||
Variable.NumberValue | float | ||||||
Variable.OutputUnitID | int | ||||||
Variable.ParentClassTypeID | int | ||||||
Variable.ParentID | int | ID of Category/Group Above | |||||
Variable.ParentStoreID | int | Not Used. | |||||
Variable.Part2ConsumptionFormula | text | ||||||
Variable.Part2Description | text | ||||||
Variable.PartConsumptionFormula | text | ||||||
Variable.PartConsumptionFormulas | text | ||||||
Variable.PartConsumptionUnitIDs | text | ||||||
Variable.PartDescription | text | ||||||
Variable.PricingPlanClassTypeID | int | ||||||
Variable.PricingPlanID | int | ||||||
Variable.PricingPlanStoreID | int | Not Used. | |||||
Variable.PricingTableClassTypeID | int | ||||||
Variable.PricingTableID | int | ||||||
Variable.PricingTableStoreID | int | Not Used. | |||||
Variable.ResetOnClone | bit | ||||||
Variable.SaveOption | int | ||||||
Variable.SaveTransRecord | bit | ||||||
Variable.SecondaryListVariableClassTypeID | int | ||||||
Variable.SecondaryListVariableID | int | ||||||
Variable.SecondaryListVariableStoreID | int | Not Used. | |||||
Variable.SelectionListClassTypeID | int | ||||||
Variable.SelectionListFilterName | varchar(40) | ||||||
Variable.SelectionListID | int | ||||||
Variable.SelectionListStoreID | int | Not Used. | |||||
Variable.SeqID | int | ||||||
Variable.StoreID | int | Not Used. | |||||
Variable.SystemListType | int | ||||||
Variable.textValue | varchar(50) | ||||||
Variable.UnitType | int | ||||||
Variable.UseFormula | bit | ||||||
Variable.UseMaxValueFormula | bit | ||||||
Variable.UseMinValueFormula | bit | ||||||
Variable.UseRequiredFormula | bit | ||||||
Variable.UseSecondaryList | bit | ||||||
Variable.VariableName | varchar(50) | ||||||
Variable.VariableType | int |
Related Tables
You could leave a comment if you were logged in.