Updated: 2009-09-16



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is used for various links that have a Product for one of the connections.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 12501 - Quick Product List
    * 14020 - ???
    * 14510 - Goods Item Variable Link



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| PricingLink.ClassTypeID || int || Identifier for the Type of Object ||  ||
|| PricingLink.ID || int || Primary Key Field ||  ||
|| PricingLink.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||  ||
|| PricingLink.IsSystem || bit || Used to Mark Required Records ||  ||
|| PricingLink.LeftClassTypeID || int || ClassTypeID of Link1 (Left) ||  ||
|| PricingLink.LeftID || int || Link1 (left) ID || [[sql_structure_-_customergoodsitem_table]].ID where ClassTypeID  14510 ||
|| PricingLink.LeftStoreID || int || Not Used. ||  ||
|| PricingLink.LinkIndex || int ||  ||  ||
|| PricingLink.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||  ||
|| PricingLink.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||  ||
|| PricingLink.ModifiedDate || datetime || DateTime this Record was last modified ||  ||
|| PricingLink.RightClassTypeID || int || ClassTypeID of Link2 (right) ||  ||
|| PricingLink.RightID || int || Link2 (right) ID || [[sql_structure_-_variable_table]].ID where ClassTypeID  14510 ||
|| PricingLink.RightStoreID || int || Not Used. ||   ||
|| PricingLink.SeqID || int ||  ||   ||
|| PricingLink.StoreID || int || Not Used. ||   ||
Related Tables