| 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. |