mktg_expression Table
The mktg_expression table in the marketing database contains information about expressions used in the Marketing System.
The following table describes the columns in the mktg_expression table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_expr_id |
int |
no |
The ID of this expression. This is the primary key. |
u_expr_name |
nvarchar(100) |
no |
The name of this expression. |
u_expr_description |
nvarchar(200) |
yes |
A description of this expression. |
u_expr_category |
nvarchar(30) |
no |
The category to which this expression belongs. |
b_expr_local |
bit |
no |
A Boolean value that indicates whether this expression is local. |
u_expr_body |
ntext |
no |
A string that contains the expression itself. |
u_expr_prodpicker_catalog_name |
nvarchar(128) |
yes |
The name of product catalog associated with this expression. See the note following this table. |
u_expr_prodpicker_category_id |
nvarchar(256) |
yes |
The name of product category associated with this expression. See the note following this table. |
u_expr_prodpicker_product_id |
nvarchar(256) |
yes |
The name of product associated with this expression. See the note following this table. |
u_expr_created |
datetime |
no |
The date and time at which this expression record was created. |
u_expr_modified |
datetime |
yes |
The date and time at which this expression record was last modified. |
u_expr_modified_by |
nvarchar(50) |
yes |
The name of the user who created or last modified this expression record. |
Note
The three prodpicker columns are only populated for simple discounts. For more information about simple discounts, see How to Display Discounts for Specific Products.