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.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables

mktg_campaign_item Table

mktg_expression Table

mktg_promocode_defn Table