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_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
You could leave a comment if you were logged in.