Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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.