Entity Definition

Logical Name : ItemCollection
Physical Name : CO_CLN_ITM

An optional relationship between an item and its components and affiliates where the components consist of other ITEMs. Note that this data structure is intended to support one and only one level of decomposition and/or affiliation between an ITEM parent and its ITEM children.

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) AggregateItem(AS_ITM_AGGT)
MemberItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_MBR IdentityUUID char(32) Item(AS_ITM)
SequenceNumber Assigns a sequence / sorting order for the items in the collection. AI_ITM_CLN LineNumber smallint
PerAssemblyCount The number of individual member Items that are assembled into the AggregateItem or Kit. QU_ITM_PR_ASMB Quantity DECIMAL(9,3)
BlendPercent The percentage of the parent item that comes from the child item. PE_BLD Percent decimal(7,4)


Parent Entity Verb Phrase Child Entity
AggregateItem is a collection of ItemCollection
Item is part of ItemCollection
ItemCollection allows ItemCollectionSubstitution

Logical Views containing ItemCollection

Logical View
Logical 01000 - Item Description - Macro View
Logical 01004 - Item Description - Branding
Logical 01010 - Item Description - Subtype View
Logical 02311 - Retail Transaction Item KIT Sale View