CPPMN

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.
CPPMNVAL_IDINTEGERReserved for HCL internal use.
STOREENT_IDINTEGER NOT NULLReserved for HCL internal use.
INITIATIVE_IDINTEGERReserved for HCL internal use.
SETCCURRCHAR (3)Reserved for HCL internal use.
TOTALNUMOFFERINTEGER NOT NULLReserved for HCL internal use.
NUMOFFEREDINTEGER NOT NULLReserved for HCL internal use.
EARLYBIRDLIMITINTEGERReserved for HCL internal use.
CREATIONTIMETIMESTAMPReserved for HCL internal use.
PURCHASECONDTYPECHAR (4) NOT NULLReserved for HCL internal use.
NUMSEENALLOWEDINTEGER NOT NULLReserved for HCL internal use.
FIELD1VARCHAR (64)Reserved for HCL internal use.
PROMODISPTYPECHAR (4) NOT NULLReserved for HCL internal use.
NUMUSEALLOWEDINTEGER NOT NULLReserved for HCL internal use.
STATUSCHAR (1) NOT NULLReserved for HCL internal use.
CPPMNNAMECHAR (64) NOT NULLReserved for HCL internal use.
CPPMNDESCCHAR (254)Reserved for HCL internal use.
STARTDATETIMESTAMP NOT NULLReserved for HCL internal use.
ENDDATETIMESTAMPReserved for HCL internal use.
NUMACPALLOWEDINTEGER NOT NULL DEFAULT 1Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CPPMN_IDPrimary Key
I0000289CPPMNNAME+STOREENT_IDUnique Index
I0000302ENDDATENon-Unique Index
I0000546STOREENT_IDNon-Unique Index
I0001251INITIATIVE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_265STOREENT_IDSTOREENTSTOREENT_IDCascade
F_266INITIATIVE_IDINITIATIVEINITIATIVE_IDCascade
F_267CPPMNVAL_IDCPPMNVALCPPMNVAL_IDCascade
F_268SETCCURRSETCURRSETCCURRCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_264CPPMN_IDCPOFFERCPPMN_IDCascade
F_270CPPMN_IDCPPMNDESCCPPMN_IDCascade
F_271CPPMN_IDCPPMNDISCCPPMN_IDCascade
F_273CPPMN_IDCPPMNORDCPPMN_IDCascade
F_275CPPMN_IDCPPMNPRODCPPMN_IDCascade
F_277CPPMN_IDCPWALLETCPPMN_IDCascade
F_975CPPMN_IDCPPMNACCCPPMN_IDCascade
F_976CPPMN_IDCPPMNCATCPPMN_IDCascade