This table contains promotion policies.
Column Descriptions
| Column Name
| Column Type
| Description
|
| PX_POLICY_ID
| INTEGER NOT NULL
| The policy ID. This is a primary key.
|
| STOREENT_ID
| INTEGER NOT NULL
| Foreign key to the STOREENT table. This is the ID of the store that owns this policy.
|
| STATUS
| SMALLINT NOT NULL DEFAULT 0
| The current status of a policy. Possible values include:
0: active
1: inactive
2: deleted
The default value is 0.
|
| NAME
| VARCHAR(128) NOT NULL
| The name of the policy.
|
| IMPLCLS
| VARCHAR(254) NOT NULL
| The name of the class that implements this policy.
|
| XMLPARAM
| CLOB
| The XML definition of this policy.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|