{$page} 



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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]