This table contains promotions.
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000388 | STOREENT_ID+NAME+VERSION+STATUS+REVISION | Unique Index |
SQL050212031301640 | PX_PROMOTION_ID | Primary Key |
I0000398 | PX_GROUP_ID | Non-Unique Index |
I0000399 | CAMPAIGN_ID | Non-Unique Index |
I0000400 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1047 | CAMPAIGN_ID | CAMPAIGN | CAMPAIGN_ID | Cascade |
F_1046 | PX_GROUP_ID | PX_GROUP | PX_GROUP_ID | Cascade |
F_1048 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_1058 | PX_PROMOTION_ID | CLCDPROMO | PX_PROMOTION_ID | Cascade |
F_1049 | PX_PROMOTION_ID | PX_PROMOPOLICY | PX_PROMOTION_ID | Cascade |
F_1079 | PX_PROMO_ID_TO | PX_PROMPROM | PX_PROMOTION_ID | Cascade |
F_1078 | PX_PROMO_ID_FROM | PX_PROMPROM | PX_PROMOTION_ID | Cascade |