Share via


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.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables