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.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.ID | ||||
| QuickProduct.ProductClassTypeID | int | 12000 - Product | |||||
| QuickProduct.ProductID | int | sql_structure_-_customergoodsitem_table.ID WHERE ClassTypeID QuickProduct.ProductClassTypeID | |||||
| QuickProduct.SeqID | int | ||||||
| QuickProduct.StoreID | int | Not Used. |
Related Tables
SQL Strcuture - PricingElement Table
sql_structure_-_customergoodsitem_table
You could leave a comment if you were logged in.