mktg_promocode_history Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_promocode_history table in the marketing database contains information about promotion code history in the Marketing System.
The following table describes the columns in the mktg_promocode_history table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_pchist_id |
int |
no |
The ID of this promotion code history record. This is the primary key. |
i_pc_id |
int |
no |
The ID of the associated promotion code. |
guid_pchist_basketordergroup_id |
uniqueidentifier |
no |
A GUID that uniquely identifies the ID of the corresponding basket order group. |
u_pchist_user_id |
nvarchar(50) |
yes |
The ID of the user associated with this promotion code history record. |
u_pchist_alternative_user |
nvarchar(50) |
yes |
The ID of the alternative user associated with this promotion code history record. |
i_pchist_status |
int |
no |
The status of this promotion code history record. |
i_pchist_notvalid_reason |
int |
yes |
The not valid reason of this promotion code history record. |
dt_pchist_changed |
datetime |
no |
The date and time at which this promotion code history record was last changed. |