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.