{$page} 



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 32x32 for the Quick Product list if you have not set a Quick Product image manually.



{{::http:www.ecyrious.comcontrolimagespricinggraphic_example.png?nolink&|}}



Quick Product images setup (located in //Setup > Pricing Setup > All Pricing Setup// on the //Quick Products// screen:



{{::http:www.ecyrious.comcontrolimagespricinggraphic_example2.png?nolink&|}}



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|CustomerGoodsItem]].ImageID \\ [[sql_structure_-_quickproduct_tablequickproduct|QuickProduct]].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_tabletransdetailgraphic|TransDetailGraphic]]



[[sql_structure_-_graphic_table|Graphic]]



[[sql_structure_-_customergoodsitem_table|CustomerGoodsItem]]



[[sql_structure_-_quickproduct_tablequickproduct|QuickProduct]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]