{$page}

Updated: 10/6/2009

Version: Control 4.4

Table Purpose, Usage, and Notes

This table stores the information for each of the Quick Product items.

Information on Table Data

  • ClassTypeIDs Stored in Table:
    • 12500 - Quick Product

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
QuickProduct.ClassTypeID int Identifier for the Type of Object
QuickProduct.ID int Primary Key Field
QuickProduct.ImageClassTypeID int 1500 - Pricing Graphic
QuickProduct.ImageID int PricingGraphic.ID
QuickProduct.ImageStoreID int Not Used.
QuickProduct.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
QuickProduct.IsSystem bit Used to Mark Required Records
QuickProduct.LinkIndex int 0-based index indicating the descending order of the items as they should be visible in the quick product list.
QuickProduct.ModifiedByComputer varchar(25) HostName of computer that last modified this record
QuickProduct.ModifiedByUser varchar(25) Windows User who last modified this record
QuickProduct.ModifiedDate datetime DateTime this Record was last modified
QuickProduct.ParentID int ID of the PricingElement that contains the name of the list this Quick Product is in. PricingElement.ID
QuickProduct.ProductClassTypeID int 12000 - Product
QuickProduct.ProductID int CustomerGoodsItem.ID WHERE ClassTypeID QuickProduct.ProductClassTypeID
QuickProduct.SeqID int
QuickProduct.StoreID int Not Used.

Related Tables

PricingElement

CustomerGoodsItem

See Also

You could leave a comment if you were logged in.