CPPMN

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.
CPPMNVAL_ID	INTEGER	Reserved for IBM internal use.
STOREENT_ID	INTEGER NOT NULL	Reserved for IBM internal use.
INITIATIVE_ID	INTEGER	Reserved for IBM internal use.
SETCCURR	CHAR (3)	Reserved for IBM internal use.
TOTALNUMOFFER	INTEGER NOT NULL	Reserved for IBM internal use.
NUMOFFERED	INTEGER NOT NULL	Reserved for IBM internal use.
EARLYBIRDLIMIT	INTEGER	Reserved for IBM internal use.
CREATIONTIME	TIMESTAMP	Reserved for IBM internal use.
PURCHASECONDTYPE	CHAR (4) NOT NULL	Reserved for IBM internal use.
NUMSEENALLOWED	INTEGER NOT NULL	Reserved for IBM internal use.
FIELD1	VARCHAR (64)	Reserved for IBM internal use.
PROMODISPTYPE	CHAR (4) NOT NULL	Reserved for IBM internal use.
NUMUSEALLOWED	INTEGER NOT NULL	Reserved for IBM internal use.
STATUS	CHAR (1) NOT NULL	Reserved for IBM internal use.
CPPMNNAME	CHAR (64) NOT NULL	Reserved for IBM internal use.
CPPMNDESC	CHAR (254)	Reserved for IBM internal use.
STARTDATE	TIMESTAMP NOT NULL	Reserved for IBM internal use.
ENDDATE	TIMESTAMP	Reserved for IBM internal use.
NUMACPALLOWED	INTEGER NOT NULL DEFAULT 1	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	Primary Key
I0000289	CPPMNNAME+STOREENT_ID	Unique Index
I0000302	ENDDATE	Non-Unique Index
I0000546	STOREENT_ID	Non-Unique Index
I0001251	INITIATIVE_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_265	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_266	INITIATIVE_ID	INITIATIVE	INITIATIVE_ID	Cascade
F_267	CPPMNVAL_ID	CPPMNVAL	CPPMNVAL_ID	Cascade
F_268	SETCCURR	SETCURR	SETCCURR	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_264	CPPMN_ID	CPOFFER	CPPMN_ID	Cascade
F_270	CPPMN_ID	CPPMNDESC	CPPMN_ID	Cascade
F_271	CPPMN_ID	CPPMNDISC	CPPMN_ID	Cascade
F_273	CPPMN_ID	CPPMNORD	CPPMN_ID	Cascade
F_275	CPPMN_ID	CPPMNPROD	CPPMN_ID	Cascade
F_277	CPPMN_ID	CPWALLET	CPPMN_ID	Cascade
F_975	CPPMN_ID	CPPMNACC	CPPMN_ID	Cascade
F_976	CPPMN_ID	CPPMNCAT	CPPMN_ID	Cascade