Entity Definition

Logical Name : ApparelItem
Physical Name : AS_ITM_APR

A dress, skirt, blouse, pair of trousers or any other item of clothing that can be related to other APPAREL ITEMS by way of SIZE, COLOR or STYLE.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) StockItem(AS_ITM_STK)
SilhouetteDescription Describes the cut or fit of the APPARELL ITEM. For example, shirts may be sold as slim or standard fit. DE_SLH DescriptionShort varchar(255)
FabricDescription Describes the material used to make the APPAREL ITEM DE_FBRC DescriptionShort varchar(255)
GenderCode A code designating the gender orientation for a particular apparel item. Valid values: MALE FEMALE UNISEX OTHER CD_GND Code varchar(20)
PatternDescription A description that designates the print or pattern applied to an apparel item. Sample values: PAISELY POKADOT STRIPED PINSTRIPED These are determined by the retailer. DE_PTTRN DescriptionShort varchar(255)
ApparelAgeGroupCode Assigns the apparel item to a target consumer age group: Examples include: NEWBORN INFANT TODDLER PRESCHOOL 6-10 TWEENS TEEN YOUNG ADULT ADULT CD_APR_AG_GP Code varchar(20)
ApparelSeasonCode Apparel targeted wearing season: Examples include: SPRING SUMMER FALL WINTER ALLSEASON CD_APR_SN Code varchar(20)
ApparelCareDescription A short narrative that designates specific cleaning and maintenance restrictions and requirements for an apparel item. Example Mchn Wsh Cold Perm Press Tumbl Dry Low No Ironing No DryClean DE_APR_CRE DescriptionShort varchar(255)
FormalityDescription A short description indicating the degree of formality/dress code scenario for this apparel item. Examples include: CASUAL FORMAL SPECIALTY ATHLETIC WEAR SPECIAL PURPOSE DE_FRMLTY DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
StockItem isa ApparelItem

Logical Views containing ApparelItem

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