CPPMNCAT

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

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLReserved for HCL internal use.
CATGROUP_IDBIGINT NOT NULLReserved for HCL internal use.
CPPMN_IDINTEGER NOT NULLReserved for HCL internal use.
QTYMEASURECHAR (16) NOT NULLReserved for HCL internal use.
MINQTYDOUBLEReserved for HCL internal use.
MAXQTYDOUBLEReserved for HCL internal use.
MINVALUEDECIMAL (20,5)Reserved for HCL internal use.
MAXVALUEDECIMAL (20,5)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CPPMN_ID+CATALOG_ID+CATGROUP_IDPrimary Key
I0000287CATALOG_ID+CATGROUP_IDNon-Unique Index
I0000547CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_976CPPMN_IDCPPMNCPPMN_IDCascade
F_977CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_978CATALOG_IDCATALOGCATALOG_IDCascade