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 IBM internal use.
CATENTRY_IDBIGINT NOT NULLReserved for IBM internal use.
QTYMEASURECHAR (16) NOT NULLReserved for IBM internal use.
QUANTITYDOUBLE NOT NULLReserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM 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