Entity Definition

Logical Name : Size
Physical Name : CO_SZ

This entity type is a further classification of the STOCK ITEM and is typically referred to as an option of style.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
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 SizeFamily(CO_SZ_FMY)
SizeCode (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 NRMA 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)
TableCode The first character of the size code as designated by the NRF (1-9). This first digit refers to the size table, for example 1=adult male clothing, 5=footwear and 7=home decorating accessories. Retailers using proprietary in-house size codes use a "0" size table. ED_TB_SZ Code2 char(2)
TableName The name of the size table code, eg size code 4=infant's and children's clothing. NM_TB_SZ Name varchar(40)
Description A description of the apparel cataegories encompassed within the size table code. DE_TB_SZ DescriptionShort varchar(255)
ActualSizeCode The last four characters of the NRF size code. This code uniquely identifies a particular size, eg dress size 12 or combination of sizes, eg pants, waist size 36, inseam 31. ED_SZ_ACT Code4 char(4)
ActualSizeTypeDescription A description of the industry convention typically used to signify the size to the customer, eg waist used for pants, body for coats, neck for shirts, chest for sweaters, etc. DE_TYP_ACT_SZ Name varchar(40)
ActualSizeProportionDescription The proportions typically used to measure this particular ITEM type, eg 36 (waist) x 31(inseam). DE_PRPTN_ACT_SZ DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
SizeFamily consists of Size
Size converts to SizeConversion
Size defines MerchandiseHierarchyGroupSize
Size defines StockItem
Size converts from SizeConversion

Logical Views containing Size

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