CPPMNPROD

Deprecated. Provided for backward compatibility only. This table is replaced by PX_PROMOTION related tables.


Column Descriptions:

Name Type Description
CPPMN_ID INTEGER NOT NULL Reserved for IBM internal use.
CATENTRY_ID BIGINT NOT NULL Reserved for IBM internal use.
QTYMEASURE CHAR (16) NOT NULL Reserved for IBM internal use.
QUANTITY DOUBLE 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> CPPMN_ID+CATENTRY_ID Primary Key
I0000282 CATENTRY_ID Non-Unique Index


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_274 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_275 CPPMN_ID CPPMN CPPMN_ID Cascade