Entity Definition

Logical Name : MerchandiseHierarchyGroupColorPalette
Physical Name : CO_MRGP_PLTE_CLR

A cross reference of ColorPalettes 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)
ColorPaletteID (FK)(PK) A unique retailer assigned identifier for the ColorPalette. ID_PLTE_CLR Identity integer ColorPalette(CO_PLTE_CLR)


Parent Entity Verb Phrase Child Entity
ColorPalette defines MerchandiseHierarchyGroupColorPalette
MerchandiseHierarchyGroup includes MerchandiseHierarchyGroupColorPalette

Logical Views containing MerchandiseHierarchyGroupColorPalette

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