CPPMNPROD

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

Column Descriptions:

NameTypeDescription
CPPMN_IDINTEGER NOT NULLReserved for HCL internal use.
CATENTRY_IDBIGINT NOT NULLReserved for HCL internal use.
QTYMEASURECHAR (16) NOT NULLReserved for HCL internal use.
QUANTITYDOUBLE NOT NULLReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CPPMN_ID+CATENTRY_IDPrimary Key
I0000282CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_274CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_275CPPMN_IDCPPMNCPPMN_IDCascade