mktg_promocode_defn Table
The mktg_promocode_defn table in the marketing database contains information about promotion code definitions in the Marketing System.
The following table describes the columns in the mktg_promocode_defn table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_pcdef_id |
int |
no |
The ID of this promotion code definition. This is the primary key. |
u_pcdef_name |
nvarchar(50) |
no |
The name of this promotion code definition. |
u_pcdef_public_code |
nvarchar(50) |
yes |
The actual promotion code for public promotion codes. |
i_pcdef_recent_batch_status |
int |
yes |
The status associated with the most recent batch generation of this promotion code. |
i_pcdef_usage_type |
int |
no |
The usage type of the associated promotion code(s). |
i_pcdef_usage_limit |
int |
no |
The usage limit of the associated promotion code(s). |
i_pcdef_numcodes |
int |
no |
The number of promotion codes associated with this definition. |
dt_pcdef_created |
datetime |
no |
The date and time at which this promotion code definition was created. |
dt_pcdef_modified |
datetime |
yes |
The date and time at which this promotion code definition was last modified. |
u_pcdef_modified_by |
nvarchar(50) |
yes |
The name of the user who created or last modified this promotion code definition. |