Updated: 2009-06-19



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores the header record and default values for Selection Lists.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 1601 - Selection List



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| SelectionList.AutoSort || bit ||  ||   ||
|| SelectionList.AutoSortType || int ||  ||   ||
|| SelectionList.BlankCostFormula || text ||  ||   ||
|| SelectionList.BlankCostFormulaType || int ||  ||   ||
|| SelectionList.BlankDependentLinksXML || text ||  ||   ||
|| SelectionList.BlankFilters || text ||  ||   ||
|| SelectionList.BlankImageLinks || text ||  ||   ||
|| SelectionList.BlankItemColor || int ||  ||   ||
|| SelectionList.BlankListCost || float ||  ||   ||
|| SelectionList.BlankListValue || float ||  ||   ||
|| SelectionList.BlankPart2ClassTypeID || int ||  ||   ||
|| SelectionList.BlankPart2ConsumptionFx || text ||  ||   ||
|| SelectionList.BlankPart2Description || text ||  ||   ||
|| SelectionList.BlankPart2ID || int ||  ||   ||
|| SelectionList.BlankPart2StoreID || int || Not Used. ||   ||
|| SelectionList.BlankPartClassTypeID || int ||  ||   ||
|| SelectionList.BlankPartConsumptionFx || text ||  ||   ||
|| SelectionList.BlankPartDescription || text ||  ||   ||
|| SelectionList.BlankPartID || int ||  ||   ||
|| SelectionList.BlankPartLinksXML || text ||  ||   ||
|| SelectionList.BlankPartStoreID || int || Not Used. ||   ||
|| SelectionList.BlankPriceFormula || text ||  ||   ||
|| SelectionList.BlankPriceFormulaType || int ||  ||   ||
|| SelectionList.BlankProperties || text ||  ||   ||
|| SelectionList.BlankSecondaryListBlank || nvarchar(40) ||  ||   ||
|| SelectionList.BlankSecondaryListClassTypeID || int ||  ||   ||
|| SelectionList.BlankSecondaryListID || int ||  ||   ||
|| SelectionList.BlankSecondaryListStoreID || int || Not Used. ||   ||
|| SelectionList.BlankUseDefaultPart || bit ||  ||   ||
|| SelectionList.BlankUseDefaultPart2 || bit ||  ||   ||
|| SelectionList.CategoryID || int ||  ||   ||
|| SelectionList.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| SelectionList.DefaultCostFormula || text ||  ||   ||
|| SelectionList.DefaultCostFormulaType || int ||  ||   ||
|| SelectionList.DefaultDependentLinksXML || text ||  ||   ||
|| SelectionList.DefaultFilters || text ||  ||   ||
|| SelectionList.DefaultImageLinks || text ||  ||   ||
|| SelectionList.DefaultItemColor || int ||  ||   ||
|| SelectionList.DefaultListCost || float ||  ||   ||
|| SelectionList.DefaultListValue || decimal(18, 4) ||  ||   ||
|| SelectionList.DefaultPart2ClassTypeID || int ||  ||   ||
|| SelectionList.DefaultPart2ConsumptionFx || text ||  ||   ||
|| SelectionList.DefaultPart2Description || text ||  ||   ||
|| SelectionList.DefaultPart2ID || int ||  ||   ||
|| SelectionList.DefaultPart2StoreID || int || Not Used. ||   ||
|| SelectionList.DefaultPartClassTypeID || int ||  ||   ||
|| SelectionList.DefaultPartConsumptionFx || text ||  ||   ||
|| SelectionList.DefaultPartDescription || text ||  ||   ||
|| SelectionList.DefaultPartID || int ||  ||   ||
|| SelectionList.DefaultPartLinksXML || text ||  ||   ||
|| SelectionList.DefaultPartStoreID || int || Not Used. ||   ||
|| SelectionList.DefaultPriceFormula || text ||  ||   ||
|| SelectionList.DefaultPriceFormulaType || int ||  ||   ||
|| SelectionList.DefaultProperties || text ||  ||   ||
|| SelectionList.DefaultSecondaryListClassTypeID || int ||  ||   ||
|| SelectionList.DefaultSecondaryListDefault || nvarchar(40) ||  ||   ||
|| SelectionList.DefaultSecondaryListID || int ||  ||   ||
|| SelectionList.DefaultSecondaryListStoreID || int || Not Used. ||   ||
|| SelectionList.Format || int ||  ||   ||
|| SelectionList.ID || int || Primary Key for the Table ||   ||
|| SelectionList.IncludeNewListItem || bit ||  ||   ||
|| SelectionList.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| SelectionList.IsSystem || bit || Used to Mark Required Records ||   ||
|| SelectionList.ListName || nvarchar(25) ||  ||   ||
|| SelectionList.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| SelectionList.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| SelectionList.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| SelectionList.SeqID || int ||  ||   ||
|| SelectionList.StoreID || int || Not Used. ||   ||
Related Tables