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