mktg_promocode_history Table

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.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables