MASSOCCECE

This table holds the merchandising associations that exist between CatalogEntries.

Column Descriptions:

NameTypeDescription
MASSOCCECE_IDBIGINT NOT NULLThe reference number of this entry.
MASSOCTYPE_IDCHAR (32) NOT NULLThe Identifier of the association type. Foreign key to the MASSOCTYPE table.
CATENTRY_ID_FROMBIGINT NOT NULLThe CatalogEntry that is the source of the association.
RANKDECIMAL (20,5)The sequence number used for display order.
CATENTRY_ID_TOBIGINT NOT NULLThe CatalogEntry that is the target of the association.
MASSOC_IDCHAR (32) NOT NULLThe Identifier of the semantic specifier. Foreign key to the MASSOC table.
QUANTITYDOUBLEThe quantity related to this association.
RULEVARCHAR (254)Reserved for HCL internal use.
GROUPNAMEVARCHAR (254)Reserved for HCL internal use.
FIELD1VARCHAR (254)Customizable.
FIELD2INTEGERCustomizable.
FIELD3DECIMAL (20,5)Customizable.
OIDVARCHAR (64)Reserved for HCL internal use.
DATE1TIMESTAMPCustomizable.
STORE_IDINTEGER NOT NULL DEFAULT 0The store in which this merchandising association applies. A value of zero indicates that this relationship is valid in all stores.
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
<SYSTEM-GENERATED>MASSOCCECE_IDPrimary Key
I0000148 STORE_ID+MASSOCTYPE_ID+MASSOC_ID+CATENTRY_ID_FROM+CATENTRY_ID_TOUnique Index
I0000370CATENTRY_ID_FROMNon-Unique Index
I0000610CATENTRY_ID_TONon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_429MASSOC_IDMASSOCMASSOC_IDCascade
F_430MASSOCTYPE_IDMASSOCTYPEMASSOCTYPE_IDCascade
F_431CATENTRY_ID_FROMCATENTRYCATENTRY_IDCascade
F_432CATENTRY_ID_TOCATENTRYCATENTRY_IDCascade
F_943STORE_IDSTORESTORE_IDCascade