MASSOCGPGP

This table holds the merchandising associations that exist between CatalogGroups.

Column Descriptions:

NameTypeDescription
MASSOCGPGP_IDBIGINT NOT NULLThe reference number of this entry.
CATGROUP_ID_TOBIGINT NOT NULLThe CatalogGroup that is the target of the association.
CATGROUP_ID_FROMBIGINT NOT NULLThe CatalogGroup that is the source of the association.
MASSOCTYPE_IDCHAR (32) NOT NULLThe Identifier of the association type. Foreign key to the MASSOCTYPE table.
RANKDECIMAL (20,5)The sequence number used for display order.
MASSOC_IDCHAR (32) NOT NULLThe Identifier of the semantic specifier. Foreign key to the MASSOC table.
QUANTITYDOUBLEThe quantity related to this association.
RULECHAR (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 0 (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>MASSOCGPGP_IDPrimary Key
I0000149 STORE_ID+MASSOCTYPE_ID+MASSOC_ID+CATGROUP_ID_FROM+CATGROUP_ID_TOUnique Index
I0000611CATGROUP_ID_FROMNon-Unique Index
I0000612CATGROUP_ID_TONon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_433MASSOC_IDMASSOCMASSOC_IDCascade
F_434MASSOCTYPE_IDMASSOCTYPEMASSOCTYPE_IDCascade
F_435CATGROUP_ID_TOCATGROUPCATGROUP_IDCascade
F_436CATGROUP_ID_FROMCATGROUPCATGROUP_IDCascade
F_944STORE_IDSTORESTORE_IDCascade