Updated: 2009-10-05
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store Product Images and Quick Product Images.
Product Images can be added from Product Setup as seen below and will attempt to be scaled down to 32×32 for the Quick Product list if you have not set a Quick Product image manually.
Quick Product images setup (located in Setup > Pricing Setup > All Pricing Setup on the Quick Products screen:
Information on Table Data
- ClassTypeIDs Stores in Table:
- 1500 - Pricing Graphic
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
PricingGraphic.ClassTypeID | int | Identifier for the Type of Object | |||||
PricingGraphic.Description | nvarchar(50) | Not Used. | |||||
PricingGraphic.FileName | nvarchar(25) | If the image was loaded from a file as opposed to be pasted in, this will contain the location of that file. | |||||
PricingGraphic.ID | int | Primary Key for the Table | sql_structure_-_customergoodsitem_table.ImageID sql_structure_-_quickproduct_table.ImageID |
||||
PricingGraphic.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
PricingGraphic.IsSystem | bit | Used to Mark Required Records | |||||
PricingGraphic.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
PricingGraphic.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
PricingGraphic.ModifiedDate | datetime | DateTime this Record was last modified | |||||
PricingGraphic.Picture | image | Binary data representing the image. | |||||
PricingGraphic.SeqID | int | ||||||
PricingGraphic.StoreID | int | Not Used. |
Related Tables
sql_structure_-_transdetailgraphic_table
sql_structure_-_customergoodsitem_table
sql_structure_-_quickproduct_table
You could leave a comment if you were logged in.