mktg_promocode_transactions Table
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. |