Share via


mktg_promocode_transactions Table

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.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables