Name | Description | Type | Additional information |
---|---|---|---|
PromotionID |
Primary key. Auto-incremented. database reference = promotions.id |
integer |
None. |
PromotionName |
database reference = promotions.promotion_name |
string |
String length: inclusive between 0 and 150 |
PromotionDescription |
database reference = promotions.promotion_description |
string |
String length: inclusive between 0 and 65535 |
PromotionStart |
database reference = promotions.promotion_start |
date |
None. |
PromotionEnd |
database reference = promotions.promotion_end |
date |
None. |
PromotionEnabled |
database reference = promotions.promotion_enabled |
integer |
None. |
PromotionByAmount |
database reference = promotions.by_amount |
decimal number |
None. |
PromotionCheckByAmount |
database reference = promotions.chk_byamount |
integer |
None. |
PromotionByQuantity |
database reference = promotions.by_quantity |
integer |
None. |
PromotionCheckByQuantity |
database reference = promotions.chk_byquantity |
integer |
None. |
PromotionByProduct |
database reference = promotions.by_product |
integer |
None. |
PromotionByCategory |
database reference = promotions.by_category |
string |
String length: inclusive between 0 and 65535 |
PromotionAmount |
database reference = promotions.promotion_amount |
decimal number |
None. |
PromotionPercentage |
database reference = promotions.promotion_percentage |
integer |
None. |
PromotionPerItem |
database reference = promotions.promotion_peritem |
integer |
None. |
PromotionCategory |
database reference = promotions.promotion_category |
string |
String length: inclusive between 0 and 65535 |
PromotionProduct |
database reference = promotions.promotion_product |
string |
String length: inclusive between 0 and 150 |
PromotionFreeShipping |
database reference = promotions.promotion_freeshipping |
integer |
None. |
PromotionFreeProduct |
database reference = promotions.promotion_freeproduct |
string |
String length: inclusive between 0 and 150 |
PromotionProduct1ID |
database reference = promotions.prod1_id |
integer |
None. |
PromotionProduct1Quantity |
database reference = promotions.prod1_qty |
integer |
None. |
PromotionProduct2ID |
database reference = promotions.prod2_id |
integer |
None. |
PromotionProduct2Quantity |
database reference = promotions.prod2_qty |
integer |
None. |
PromotionProduct3ID |
database reference = promotions.prod3_id |
integer |
None. |
PromotionProduct3Quantity |
database reference = promotions.prod3_qty |
integer |
None. |
PromotionProductID |
database reference = promotions.prod4_id |
integer |
None. |
PromotionProduct4Quantity |
database reference = promotions.prod4_qty |
integer |
None. |
PromotionCoupon |
database reference = promotions.coupon |
string |
String length: inclusive between 0 and 50 |
PromotionUses |
database reference = promotions.promotion_uses |
integer |
None. |
PromotionMaxUses |
database reference = promotions.promotion_maxuses |
integer |
None. |
PromotionUsesPerCustomer |
database reference = promotions.promotion_usespercust |
integer |
None. |
PromotionGroupID |
database reference = promotions.coupon_group |
string |
String length: inclusive between 0 and 255 |
PromotionUserid |
database reference = promotions.userid |
string |
String length: inclusive between 0 and 50 |
PromotionLastUpdate |
database reference = promotions.last_update |
date |
None. |
PromotionByAmount2 |
database reference = promotions.by_amount2 |
decimal number |
None. |
PromotionByQuantity2 |
database reference = promotions.by_quantity2 |
decimal number |
None. |
PromotionCountry |
database reference = promotions.promotion_country |
string |
String length: inclusive between 0 and 50 |
PromotionState |
database reference = promotions.promotion_state |
string |
String length: inclusive between 0 and 50 |
PromotionNonStackable |
database reference = promotions.nonstackable |
integer |
None. |
PromotionRulesRetailPrice |
database reference = promotions.rules_retailprice |
integer |
None. |
PromotionExcludeManufacturers |
database reference = promotions.exc_manufacturer |
string |
String length: inclusive between 0 and 65535 |
PromotionFreeProductPrice |
database reference = promotions.promotion_freeproduct_price |
decimal number |
None. |
PromotionExcludePreorder |
database reference = promotions.exc_preorder |
integer |
None. |
PromotionExcludeSpecialOrder |
database reference = promotions.exc_specialorder |
integer |
None. |
PromotionShippingDiscount |
database reference = promotions.shipping_discount |
decimal number |
None. |
PromotionShippingOptions |
database reference = promotions.shipping_options |
string |
String length: inclusive between 0 and 150 |
PromotionRecurringOrders |
database reference = promotions.recurringorders |
integer |
None. |
PromotionBonusRewardPoints |
database reference = promotions.bonus_reward_points |
integer |
None. |
PromotionByReward |
database reference = promotions.by_reward |
integer |
None. |
PromotionByReward2 |
database reference = promotions.by_reward2 |
integer |
None. |