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.
Information on Table Data
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.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