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
You could leave a comment if you were logged in.