Share via


mktg_promocode_defn Table

The mktg_promocode_defn table in the marketing database contains information about promotion code definitions in the Marketing System.

The following table describes the columns in the mktg_promocode_defn table.

Column name

Type

Allow null

Description

i_pcdef_id

int

no

The ID of this promotion code definition.

This is the primary key.

u_pcdef_name

nvarchar(50)

no

The name of this promotion code definition.

u_pcdef_public_code

nvarchar(50)

yes

The actual promotion code for public promotion codes.

i_pcdef_recent_batch_status

int

yes

The status associated with the most recent batch generation of this promotion code.

i_pcdef_usage_type

int

no

The usage type of the associated promotion code(s).

i_pcdef_usage_limit

int

no

The usage limit of the associated promotion code(s).

i_pcdef_numcodes

int

no

The number of promotion codes associated with this definition.

dt_pcdef_created

datetime

no

The date and time at which this promotion code definition was created.

dt_pcdef_modified

datetime

yes

The date and time at which this promotion code definition was last modified.

u_pcdef_modified_by

nvarchar(50)

yes

The name of the user who created or last modified this promotion code definition.

See Also

Other Resources

Marketing Database Tables

Marketing Lists Database Tables