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_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. |