CPITMAP

This table is deprecated and is provided for backward compatibility only. This table is replaced by px_promotion related tables.

Column Descriptions:

NameTypeDescription
CPWALLET_IDBIGINT NOT NULLReserved for IBM internal use.
ORDERITEMS_IDBIGINT NOT NULLReserved for IBM internal use.
DISCAMTDECIMAL (20,5) NOT NULLReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CPWALLET_ID+ORDERITEMS_IDPrimary Key
I0000280ORDERITEMS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_261ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_262CPWALLET_IDCPWALLETCPWALLET_IDCascade