This table is deprecated and is provided for
backward compatibility only. This table is replaced by PX_PROMOTION
related tables.
Column Descriptions:
Name | Type | Description |
CPWALLET_ID | BIGINT NOT NULL | Reserved for HCL internal use. |
ORDERITEMS_ID | BIGINT NOT NULL | Reserved for HCL internal use. |
DISCAMT | DECIMAL (20,5) NOT NULL | Reserved for HCL internal use. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | Reserved for HCL internal use. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | CPWALLET_ID+ORDERITEMS_ID | Primary Key |
I0000280 | ORDERITEMS_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_261 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_262 | CPWALLET_ID | CPWALLET | CPWALLET_ID | Cascade |