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

You could leave a comment if you were logged in.