Updated: 2009-09-16

Version: Control 4.4

Table Purpose, Usage, and Notes

This table stores the information for Pricing Levels.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 12051 - Pricing Level

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
PricingLevel.ClassTypeID int Identifier for the Type of Object
PricingLevel.Description varchar(50)
PricingLevel.ID int Primary Key for the Table
PricingLevel.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
PricingLevel.IsSystem bit Used to Mark Required Records
PricingLevel.LevelName varchar(25)
PricingLevel.ModifiedByComputer varchar(25) HostName of computer that last modified this record
PricingLevel.ModifiedByUser varchar(25) Windows User who last modified this record
PricingLevel.ModifiedDate datetime DateTime this Record was last modified
PricingLevel.PricingLevel float
PricingLevel.SeqID int
PricingLevel.StoreID int Not Used.

Related Tables

You could leave a comment if you were logged in.