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