TCPITMAP

Deprecated. 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 IBM internal use.
ORDERITEMS_ID	BIGINT NOT NULL	Reserved for IBM internal use.
DISCAMT	DECIMAL (20,5) NOT NULL	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CPWALLET_ID+ORDERITEMS_ID	Primary Key
I0000281	ORDERITEMS_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_827	ORDERITEMS_ID	ORDERITEMS	ORDERITEMS_ID	Cascade
F_828	CPWALLET_ID	CPWALLET	CPWALLET_ID	Cascade