This table holds the merchandising associations that exist between CatalogGroups.
Column Descriptions
| Column Name
| Column Type
| Description |
| MASSOCGPGP_ID
| BIGINT NOT NULL
| The reference number of this entry.
|
| CATGROUP_ID_TO
| BIGINT NOT NULL
| The CatalogGroup that is the target of the association.
|
| CATGROUP_ID_FROM
| BIGINT NOT NULL
| The CatalogGroup that is the source of the association.
|
| MASSOCTYPE_ID
| CHAR(32) NOT NULL
| The Identifier of the association type. Foreign key to the MASSOCTYPE table.
|
| RANK
| DECIMAL (20,5)
| The sequence number used for display order.
|
| MASSOC_ID
| CHAR(32) NOT NULL
| The Identifier of the semantic specifier. Foreign key to the MASSOC table.
|
| QUANTITY
| DOUBLE
| The quantity related to this association.
|
| RULE
| CHAR(254)
| Reserved for IBM internal use.
|
| GROUPNAME
| VARCHAR(254)
| Reserved for IBM internal use.
|
| FIELD1
| VARCHAR(254)
| Customizable.
|
| FIELD2
| INTEGER
| Customizable.
|
| FIELD3
| DECIMAL (20,5)
| Customizable.
|
| OID
| VARCHAR(64)
| Reserved for IBM internal use.
|
| DATE1
| TIMESTAMP
| Customizable.
|
| STORE_ID
| INTEGER NOT NULL DEFAULT 0
| The store in which this merchandising association applies. A value of 0 (zero) indicates that this relationship is valid in all stores.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|