{$page} 



Updated: 2009-09-16



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores the header record for a discount table in Control.  The individual items are stored in the [[sql_structure_-_discounttableitem_tablediscounttableitem_table|DiscountTableItem Table]].



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 14050 - Discount Table (Header)



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| DiscountTable.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| DiscountTable.DiscountTableName || nvarchar(40) || Name of the Discount Table ||  ||
|| DiscountTable.DiscountType || int ||  ||   ||
|| DiscountTable.ID || int || Primary Key Field ||  ||
|| DiscountTable.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| DiscountTable.IsSystem || bit || Used to Mark Required Records ||   ||
|| DiscountTable.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| DiscountTable.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| DiscountTable.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| DiscountTable.ParameterClassTypeID || int ||  ||   ||
|| DiscountTable.ParameterID || int || Variable for the Discount Table || Variable.ID ||
|| DiscountTable.SeqID || int ||  ||   ||
|| DiscountTable.StoreID || int || Not Used. ||   ||
|| DiscountTable.UnitID || int ||  ||   ||
Related Tables 
  * [[sql_structure_-_discounttableitem_table]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]