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.