Updated: 2009-09-16
Version: Control 4.4
Table Purpose, Usage, and Notes
This table stores information of the Order Promotions defined in Control.
Information on Table Data
- ClassTypeIDs Stores in Table:
- 12052 - Promotion
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| Promotion.AllowOrderEdit | bit | ||||||
| Promotion.ClassTypeID | int | Identifier for the Type of Object | |||||
| Promotion.Description | text | ||||||
| Promotion.FixedDiscount | float | ||||||
| Promotion.ID | int | Primary Key for the Table | |||||
| Promotion.IsActive | bit | Indicates if Enabled. 1Record is Active, 0Record is Not Active | |||||
| Promotion.IsAlwaysValid | bit | ||||||
| Promotion.IsSystem | bit | Used to Mark Required Records | |||||
| Promotion.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| Promotion.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| Promotion.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| Promotion.PercentageOff | float | ||||||
| Promotion.PromotionName | varchar(25) | ||||||
| Promotion.PromotionType | int | ||||||
| Promotion.SaleAccountClassTypeID | int | ||||||
| Promotion.SaleAccountID | int | ||||||
| Promotion.SaleAccountStoreID | int | Not Used. | |||||
| Promotion.SeqID | int | ||||||
| Promotion.StoreID | int | Not Used. | |||||
| Promotion.ValidEnd | datetime | ||||||
| Promotion.ValidStart | datetime |
Related Tables
You could leave a comment if you were logged in.