original_pages:sql_structure_-_discounttable

{$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 DiscountTableItem Table.

Information on Table Data

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