This table contains promotions.
Column Descriptions
| Column Name
| Column Type
| Description
|
| PX_PROMOTION_ID
| INTEGER NOT NULL
| The promotion ID. This is a primary key.
|
| PRIORITY
| INTEGER NOT NULL
| The priority of the promotion.
|
| STATUS
| INTEGER NOT NULL
| The current status of a promotion. Possible values include:
0: inactive
1: active
2: marked for deletion
3: suspended
4: obsolete
|
| EXCLSVE
| INTEGER NOT NULL
| The exclusivity of a promotion. Possible values include:
0: This promotion may be combined with any other promotions
1: This promotion can not be combined with any other promotions in the same promotion group
2: This promotion can not be combined with any other promotions
|
| TYPE
| INTEGER NOT NULL
| Contains the type of the promotion. Possible values include:
0: This promotion is applicable to people who belong to one or more of the targeted customer profiles. When the targeted profile file list is empty, it applies to everyone
1: This promotion is applicable only to those to whom it has been explicitly granted, that is, this promotion is a coupon promotion
|
| PERORDLMT
| INTEGER NOT NULL DEFAULT -1
| The number of times this promotion can be applied to a single order. A value of -1, which is the default, imposes no limit.
|
| PERSHOPPERLMT
| INTEGER NOT NULL DEFAULT -1
| The number of times a customer can redeem this promotion. A value of -1, which is the default, imposes no limit.
|
| TOTALLMT
| INTEGER NOT NULL DEFAULT -1
| The overall limit on the number of times this promotion can be redeemed. A value of -1, which is the default, imposes no limit.
|
| RSV_INT
| INTEGER
| Reserved for IBM internal use.
|
| PX_GROUP_ID
| INTEGER NOT NULL
| Foreign key to the PX_GROUP table. This identifies the promotion group to which this promotion belongs.
|
| CAMPAIGN_ID
| INTEGER
| Foreign key to CAMPAIGN table. This identifies the campaign with which this promotion is associated.
|
| STOREENT_ID
| INTEGER NOT NULL
| Foreign key to the STOREENT table. This identifies the store to which this promotion belongs.
|
| VERSION
| INTEGER NOT NULL
| The version number of this promotion.
|
| REVISION
| INTEGER NOT NULL
| The revision number of this promotion.
|
| EFFECTIVE
| INTEGER
| If this promotion is a private promotion, this column defines how many days after the coupon is issued the coupon becomes active.
|
| TRANSFER
| INTEGER DEFAULT 0
| If this promotion is a private promotion, the value in this column deterimines whether the coupons generated for this promotion are transferrable or not. A value of 0, which is the default, does not allow the coupon to be transferred among customers.
|
| CDREQUIRED
| INTEGER NOT NULL DEFAULT 0
| A flag that determines whether a promotion code is required to redeem this promotion. A value of 0, which is the default, means that a code is not required.
|
| EXPIRE
| INTEGER
| If this promotion is a private promotion, this column defines how many days, after the coupon becomes active, it expires.
|
| LASTUPDATEBY
| BIGINT
| The ID of the user that last modified the promotion.
|
| LASTUPDATE
| TIMESTAMP
| The timestamp of the most recent update to this promotion.
|
| STARTDATE
| TIMESTAMP NOT NULL
| The overall starting date for this promotion.
|
| ENDDATE
| TIMESTAMP NOT NULL
| The overall end date for this promotion.
|
| RSV_TIME
| TIMESTAMP
| Reserved for IBM internal use.
|
| RSV_REAL
| DECIMAL (20,5)
| Reserved for IBM internal use.
|
| TGTSALES
| DECIMAL (20,5)
| The target sales figure for this promotion.
|
| NAME
| VARCHAR(128) NOT NULL
| The name of the promotion.
|
| CODE
| VARCHAR(128)
| The promotion code for this promotion.
|
| RSV_VCH
| VARCHAR(254)
| Reserved for IBM internal use.
|
| XMLPARAM
| CLOB
| The XML definition of this promotion.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|