{$page} 



Updated: 2009-09-16



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores the individual discount lines for a discount table in Control.  The header record is the [[sql_structure_-_discounttable_table|DiscountTable Table]].



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 14051 - Discount Table Item



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| DiscountTableItem.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| DiscountTableItem.DiscountAmount || decimal(18, 4) || $ or % Discount ||  ||
|| DiscountTableItem.DiscountTableID || int || ID of the Discount Table || [[sql_structure_-_discounttable_table|DiscountTable]].ID ||
|| DiscountTableItem.ID || int || Primary Key Field ||  ||
|| DiscountTableItem.IsActive || bit || Not Used for This Table ||   ||
|| DiscountTableItem.IsSystem || bit || Used to Mark Required Records ||   ||
|| DiscountTableItem.ItemValue || nvarchar(25) || Lookup Value ||  ||
|| DiscountTableItem.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| DiscountTableItem.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| DiscountTableItem.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| DiscountTableItem.SeqID || int ||  ||   ||
|| DiscountTableItem.StoreID || int || Not Used. ||   ||
Related Tables 
  * [[sql_structure_-_discounttable_table|DiscountTable Table]]



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]