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