{$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 ||  || [[sql_structure_-_pricinggraphic_table|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. || [[sql_structure_-_pricingelement_table|PricingElement]].ID ||
|| QuickProduct.ProductClassTypeID || int || 12000 - Product || ||
|| QuickProduct.ProductID || int ||  || [[sql_structure_-_customergoodsitem_table|CustomerGoodsItem]].ID WHERE ClassTypeID  QuickProduct.ProductClassTypeID  ||
|| QuickProduct.SeqID || int ||  ||   ||
|| QuickProduct.StoreID || int || Not Used. ||   ||
Related Tables 



[[sql_strcuture_-_pricingelement_tablepricingelement|PricingElement]]



[[sql_structure_-_customergoodsitem_table|CustomerGoodsItem]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]