CEDYNDISPCTX

Reserved for HCL internal use. This table holds the contextual information related to the configuration of the product dynamic sequence rule.

Column Descriptions:

Name	Type	Description
CEDYNDISPCTX_ID	BIGINT NOT NULL	The internal reference number of the catalog entry dynamic sequencing contextual information.
CATGROUP_ID	BIGINT NOT NULL	Catalog group for which the catalog entry dynamic sequencing configuration is defined.
STOREENT_ID	INTEGER NOT NULL	Foreign key to STOREENT table that represents the store for which this configuration is defined.
STARTTIME	TIMESTAMP	The start time of this configuration. The configuration with NULL start time is effective immediately.
LASTUPDATE	TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP	The time of the last update.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
P_0041	CEDYNDISPCTX_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3779	CATGROUP_ID	CATGROUP	CATGROUP_ID	Cascade
F_3780	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3781	CEDYNDISPCTX_ID	CEDYNDISPCONF	CEDYNDISPCTX_ID	Cascade