CEDISPCTX

This table holds the contextual information related to the catalog entry display property configuration.

Column Descriptions:

NameTypeDescription
CEDISPCTX_IDBIGINT NOT NULLThe internal reference number of the catalog entry display property contextual information.
CATGROUP_IDBIGINT NOT NULLThe internal reference number of the catalog entry display property contextual information. Catalog group for which the catalog entry display configuration is defined. 
STOREENT_IDINTEGER NOT NULLStore for which the catalog entry display configuration is defined.
STARTTIMETIMESTAMPThe start time of the display configuration. The configuration with NULL start time is effective immediately.
DISPLAYMODEVARCHAR (64) NOT NULL DEFAULT 'plain'This field defines UI preferences. Two values are defined, so far: "plain" and "showPins". - "showPins" enables highlighting of products whose position in the display order is fixed. This benefits people who edit display sequencing rules. It alerts them to the fact that these products aren't being positioned by the rules. - "plain" disables this highlighting. This is our old display style. It is simpler. This is preferable when the business user has merely fixed one or more products to a specific position in the sort order, and used no rules.
FIELDIDVARCHAR (256)Reserved for HCL internal use.
LASTUPDATETIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMPReserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
P_0036CEDISPCTX_IDPrimary Key
I0001529CATGROUP_ID+STOREENT_ID+STARTTIMENon-Unique Index
I0001530STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3775CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_3776STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3774CEDISPCTX_IDCEDISPCONFCEDISPCTX_IDCascade