CPWALLET

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

Column Descriptions:

NameTypeDescription
CPWALLET_IDBIGINT NOT NULLReserved for HCL internal use.
CPPMN_IDINTEGER NOT NULLReserved for HCL internal use.
USERS_IDBIGINT NOT NULLReserved for HCL internal use.
NUMUSEINTEGER NOT NULLReserved for HCL internal use.
STATECHAR (4) NOT NULLReserved for HCL internal use.
ACCEPTFROMTYPECHAR (4) NOT NULLReserved for HCL internal use.
TIMEACCEPTTIMESTAMPReserved for HCL internal use.
FIELD1VARCHAR (64)Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0Reserved for HCL internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CPWALLET_IDPrimary Key
I0000283USERS_ID+STATENon-Unique Index
I0000284CPPMN_ID+USERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_276USERS_IDUSERSUSERS_IDCascade
F_277CPPMN_IDCPPMNCPPMN_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_262CPWALLET_IDCPITMAPCPWALLET_IDCascade
F_484CPWALLET_IDORCPMAPCPWALLET_IDCascade
F_828CPWALLET_IDTCPITMAPCPWALLET_IDCascade
F_862CPWALLET_IDTORCPMAPCPWALLET_IDCascade
F_974CPWALLET_IDCPEMAILMAPCPWALLET_IDCascade