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