mktg_promocode Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_promocode table in the marketing database contains information about promotion codes in the Marketing System.
The following table describes the columns in the mktg_promocode table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_pc_id |
int |
no |
The ID of this promotion code. This is the primary key. |
i_pcdef_id |
int |
no |
The ID the associated promotion code definition. This is a foreign key into the mktg_promocode_defn table. |
u_pc_code |
nvarchar(50) |
no |
The promotion code itself. |
u_pc_target_user |
nvarchar(50) |
yes |
The target user of this promotion code, if any. |
guid_pcgen_batch_id |
uniqueidentifier |
no |
The GUID associated with the generation of this promotion code. |