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_transactions table in the marketing database contains information about transactions that have used promotion codes.
The following table describes the columns in the mktg_promocode_transactions table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_pctrans_id |
int |
no |
The ID of this promotion code transaction. This is the primary key. |
i_pc_id |
int |
no |
The ID of the associated promotion code. |
i_pctrans_used_count |
int |
no |
The number of times this promotion code has been used. |
i_pctrans_reserved_count |
int |
no |
The number of users who currently have the code reserved but have not yet checked out. |
dt_pctrans_changed |
datetime |
no |
The date and time at which this promotion code transaction record was last changed. |