Updated: 2009-10-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to store all Lookup Tables. The “cell” contents are all stored in XML format in the TableElementStr field.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 14040 - Pricing Table
Table Structure
~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
PricingTable.CategoryClassTypeID | int | The ClassTypeID of pricing table Category. This should always be 14045. | |||||
PricingTable.CategoryID | int | ID of Pricing Table Category | sql_structure_-_pricingelement_table.ID where PricingElement.ClassTypeID 14045 | ||||
PricingTable.CategoryStoreID | int | Not Used. | |||||
PricingTable.ClassTypeID | int | Identifier for the Type of Object | |||||
PricingTable.ColCount | int | The number of columns in the table. | |||||
PricingTable.ColParamClassTypeID | int | The ClassTypeID of variable for the column. This should always be 14001. | |||||
PricingTable.ColParamID | int | Variable for the Column | sql_structure_-_variable_table.ID where Variable.ClassTypeID 14001 | ||||
PricingTable.ColUnitID | int | The ID of the units that the column values are stored in. | sql_structure_-_systemunit_table.ID | ||||
PricingTable.ID | int | Primary Key Field | |||||
PricingTable.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
PricingTable.IsSymmetricTable | bit | Is the table symmetric. (i.e. Does it have only one row and all the row values match the column values.) | |||||
PricingTable.IsSystem | bit | Used to Mark Required Records | |||||
PricingTable.ModifiedByComputer | nvarchar(25) | HostName of computer that last modified this record | |||||
PricingTable.ModifiedByUser | nvarchar(25) | Windows User who last modified this record | |||||
PricingTable.ModifiedDate | datetime | DateTime this Record was last modified | |||||
PricingTable.Notes | text | Notes about the pricing table. | |||||
PricingTable.OnColNotFound | int | Specifies what to do when the column value is not found. (Only available if the column variable is a number variable) 0 - Get Next Value 1 - Get Previous Value 2 - Calculate Value (Not Available for columns) 3 - Display Message | |||||
PricingTable.OnRowNotFound | int | Specifies what to do when the row values are not found, but within the table values. (Only available if the row variables are a number variable) 0 - Get Next Value 1 - Get Previous Value 2 - Calculate Value (Interpolate) 3 - Display Message | |||||
PricingTable.OnRowOutOfBounds | int | Specifies what to do when the row values beyond the table values. (Only available if the row variables is a number variable) 0 - Get Next Value (Not Available for Row out of bounds) 1 - Get Previous Value (Not Available for Row out of bounds) 2 - Calculate Value (Extrapolate) 3 - Display Message | |||||
PricingTable.PricingTableName | varchar(50) | The name of the pricing table. | |||||
PricingTable.Row1UnitID | int | The ID of the units that the 1st row values are stored in. | sql_structure_-_systemunit_table.ID | ||||
PricingTable.Row2UnitID | int | The ID of the units that the 2nd row values are stored in. | sql_structure_-_systemunit_table.ID | ||||
PricingTable.RowCount | int | The number of rows in the table. | |||||
PricingTable.RowParam1ClassTypeID | int | The ClassTypeID of variable for the 1st row. This should always be 14001. | |||||
PricingTable.RowParam1ID | int | Variable for the 1st Row | sql_structure_-_variable_table.ID where Variable.ClassTypeID 14001 | ||||
PricingTable.RowParam2ClassTypeID | int | The ClassTypeID of variable for the 2nd row. This should always be 14001. | |||||
PricingTable.RowParam2ID | int | Variable for the 2nd Row | sql_structure_-_variable_table.ID where Variable.ClassTypeID 14001 | ||||
PricingTable.SeqID | int | ||||||
PricingTable.StoreID | int | Not Used. | |||||
PricingTable.TableElementStr | text | Stores and XML of the table's contents |
Related Tables
sql_structure_-_pricingelement_table
sql_structure_-_variable_table
sql_structure_-_systemunit_table
You could leave a comment if you were logged in.