Entity Definition

Logical Name : MerchandiseHierarchyGroupSize
Physical Name : CO_MRGP_SZ

A cross reference of Sizes 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)
SizeCode (FK)(PK) A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRF to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. CD_SZ Code6 char(6) Size(CO_SZ)
SizeFamilyID (FK)(PK) A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. ID_SZ_FMY Identity integer Size(CO_SZ)


Parent Entity Verb Phrase Child Entity
Size defines MerchandiseHierarchyGroupSize
MerchandiseHierarchyGroup includes MerchandiseHierarchyGroupSize

Logical Views containing MerchandiseHierarchyGroupSize

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