Entity Definition

Logical Name : Color
Physical Name : CO_CLR

A standard store reference for ApparelItem color. Certain apparel retailers will record data at this level, specifically for replenishment.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ColorCode (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)
Name The individual names of the associated colors that are encompassed by the respective color code. For example, color code 201 may include both chocolate and kola nut. NM_CLR Name varchar(40)
Description A full description of the individual color, designated by the respective code and name. DE_CLR DescriptionShort varchar(255)
ColorPaletteID (FK) A unique retailer assigned identifier for the ColorPalette. ID_PLTE_CLR Identity integer ColorPalette(CO_PLTE_CLR)
ColorListAgencyID (FK) A unique retailer assigned identifier for the ColorListAgency that provides Color definitions to the retailer. ID_AGY_CLR_LST Identity integer ColorListAgency(PA_AGY_CLR_LST)
Modification Changes the main color description (e.g. Green) to include Avocado or Dinosaur to convey a marketing message. May also contain other color-based Style modifiers, e.g. for Milk Chocolate the modifier could be White vs. Dark; for Ladies' Watches the modifier could be Pink Band vs. Blue Band DE_MDFR DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
ColorPalette categorizes Color
ColorListAgency defines Color
Color defines StockItem
Color defines MerchandiseHierarchyGroupColor

Logical Views containing Color

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 01015 - Item Description - Apparel View