Entity Definition

Logical Name : MerchandiseHierarchyGroupColor
Physical Name : CO_MRGP_CLR

A cross reference of Colors that are available for a specific group of Items as denoted by the MerchandiseHierarchyGroup .

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
ColorCode (FK)(PK) A code to identify the color. The assumption is that the retailer will adopt the standards as designated by the NRF, created to facilitate the exchange of data between vendors and retailers CD_CLR Code4 char(4) Color(CO_CLR)


Parent Entity Verb Phrase Child Entity
Color defines MerchandiseHierarchyGroupColor
MerchandiseHierarchyGroup includes MerchandiseHierarchyGroupColor

Logical Views containing MerchandiseHierarchyGroupColor

Logical View
Logical 01010 - Item Description - Subtype View
Logical 01015 - Item Description - Apparel View
Logical 10200 - Enterprise - Merchandise View