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 HCL internal use.
ORDERITEMS_IDBIGINT NOT NULLReserved for HCL internal use.
DISCAMTDECIMAL (20,5) NOT NULLReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL 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