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.