mktg_promocode_generation Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_promocode_generation table in the marketing database contains information about the generation of promotion codes in the Marketing System.
The following table describes the columns in the mktg_promocode_generation table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_pcgen_id |
int |
no |
The ID of this promotion code generation. |
guid_pcgen_batch_id |
uniqueidentifier |
no |
A GUID associated with the generation of a batch of promotion codes. |
u_batch_name |
nvarchar(50) |
no |
The name associated with the generation of a batch of promotion codes. |
i_pcdef_id |
int |
no |
The ID of the promotion code definition associated with this generation. |
i_pcgen_method |
int |
no |
The method that was used for this promotion code generation. |
i_pcgen_numcodes_requested |
int |
no |
The number of promotion codes to be generated. |
i_pcgen_numcodes_generated |
int |
no |
The number of promotion codes actually generated. |
i_pcgen_percent_complete |
int |
no |
The percentage complete of this promotion code generation. |
i_pcgen_batch_status |
int |
no |
The status of this promotion code generation. |
u_pcgen_batch_error_msg |
nvarchar(512) |
yes |
The error message associated with this promotion code generation. |
b_pcgen_cancel_requested |
bit |
no |
A Boolean value that indicates whether this promotion code generation has been canceled. |
dt_pcgen_record_created |
datetime |
no |
The date and time at which this promotion code generation record was created. |
dt_pcgen_batch_started |
datetime |
yes |
The date and time at which this promotion code generation was started. |
dt_pcgen_batch_completed |
datetime |
yes |
The date and time at which this promotion code generation was completed. |
dt_pcgen_batch_deleted |
datetime |
yes |
The date and time at which this promotion code generation was deleted. |
u_pcgen_code_prefix |
nvarchar(15) |
yes |
A prefix for the generated promotion codes, if any. |
u_pcgen_code_suffix |
nvarchar(15) |
yes |
A suffix for the generated promotion codes, if any. |
i_pcgen_code_random_length |
int |
yes |
The length of the generated promotion codes, or an indication that they should be of random length. |
guid_pcgen_upload_token |
uniqueidentifier |
yes |
A GUID used as a token when the generated promotion codes are uploaded. |
u_pcgen_original_filepath |
nvarchar(512) |
yes |
The original file path associated with this promotion code generation. |
u_pcgen_batch_submitted_by |
nvarchar(50) |
no |
The name of the user who submitted this promotion code generation. |