mktg_order_discount_condition Table
The mktg_order_discount_condition table in the marketing database contains information about order discount conditions in the Marketing System.
The following table describes the columns in the mktg_order_discount_condition table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_cond_id |
int |
no |
The ID of this order discount condition. This is the primary key. |
i_disc_id |
int |
no |
The ID of the associated order discount. This is a foreign key into the mktg_order_discount table. |
i_cond_basis |
int |
no |
The basis of this order discount condition. |
i_cond_expr |
int |
yes |
The ID of the associated order discount expression, if any. This is a foreign key into the mktg_expression table. |
mny_cond_min |
money |
yes |
The minimum monetary value of this order discount condition. |
i_qty_cond_min |
int |
yes |
The minimum quantity of this order discount condition. |