mktg_order_discount Table
The mktg_order_discount table in the marketing database contains information about order discounts in the Marketing System.
The following table describes the columns in the mktg_order_discount table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_disc_id |
int |
no |
The ID of this order discount. This is the primary key. It is used internally by the Marketing System and is not used to retrieve order discounts. Order discounts are retrieved using the associated campaign item ID |
i_campitem_id |
int |
no |
The ID of the corresponding campaign item. This is a foreign key into the mktg_campaign_item table. This ID is used to uniquely identify this order discount in the Marketing System. |
i_disc_template |
int |
yes |
The ID of the discount template that was used to create this order discount. |
i_disc_rank |
int |
no |
The relative rank of this order discount. |
i_disc_limit |
int |
yes |
The maximum number of times that this discount may be applied to a basket. |
i_disc_click_required |
bit |
no |
A Boolean value that indicates whether a click is required in order to apply this discount. |
i_disc_disjoint_cond_award |
bit |
yes |
A Boolean value that indicates whether the condition and award expression must be disjoint for this discount. |
i_disc_award_expr |
int |
yes |
The ID of an expression associated with this discount. This is a foreign key into the mktg_expression table. |
i_disc_award_max |
int |
yes |
The maximum number of items that are eligible for this order discount. |
i_disc_offer_type |
int |
no |
The type of the order discount: currency value or percentage value. |
mny_disc_offer_value |
money |
no |
The amount of the discount in either percentage or currency. |
b_disc_order_level_discount |
bit |
no |
A Boolean value that indicates whether this discount applies to the whole order. |
u_disc_special_offer_type |
nvarchar(25) |
yes |
Determines how order-level discounts are applied. |
b_auto_add_award |
bit |
no |
A Boolean value that indicated whether the discount should be added automatically. |
i_pcdef_id |
int |
yes |
The ID of the associated promotion code definition. This is a foreign key into the mktg_promocode_defn table. |
b_reuse_cond_as_cond |
bit |
yes |
A Boolean value that indicates that condition expressions should be reused as condition expressions. |
b_reuse_cond_as_award |
bit |
yes |
A Boolean value that indicates that condition expressions should be reused as award expressions. |
b_reuse_award_as_cond |
bit |
yes |
A Boolean value that indicates that award expressions should be reused as condition expressions. |
b_reuse_award_as_award |
bit |
yes |
A Boolean value that indicates that award expressions should be reused as award expressions. |
b_disc_expressions_used_for_display |
bit |
no |
A Boolean value that indicates whether eligibility requirement expressions are used as target groups for discount display. |
i_disc_type |
int |
no |
The type of this order discount. |