This table contains addition promotion code
information.
Column Descriptions:
| Name | Type | Description |
| PX_PROMOTION_ID | INTEGER NOT NULL | Primary key. Foreign key to PX_PROMOTION. |
| CODETYPE | SMALLINT NOT NULL DEFAULT 0 | 0: Public code
1: Generated code
2: Imported code
|
| PATTERN | VARCHAR (128) | Pattern for advanced code. |
| COUNT | BIGINT | Number of total codes to be generated. |
| CODESTATUS | SMALLINT NOT NULL DEFAULT 0 | 0: Not populated
1: Populated
2: Processing
3: Canceled
4: Generation failed
5: Importing failed |
| TRANSFERABLE | SMALLINT NOT NULL DEFAULT 0 | 0: Transferring allowed
1: Transferring not allowed |
| VALIDFROM | TIMESTAMP | Currently not in use. |
| VALIDUNTIL | TIMESTAMP | Currently not in use. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | PX_PROMOTION_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3604 | PX_PROMOTION_ID | PX_PROMOTION | PX_PROMOTION_ID | Cascade |