Entity Definition

Logical Name : AggregateItem
Physical Name : AS_ITM_AGGT

A sub-type of Item that is an aggregation or collection of one or more constituent Items. The constituent items may be sold individually or as an identified set with its own itemID. ARTS only supports a single level of decomposition of an aggregate item.

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)
TypeCode How are the items combined? Choices are Blend & Kit. If items are combined in a Blend, then the PerAssemblyCount attribute of ItemCollection denotes the percentage of the blend. TY_ITM_AGGT Code2 char(2)


Parent Entity Verb Phrase Child Entity
AggregateItem is a collection of ItemCollection
Item can be a AggregateItem

Logical Views containing AggregateItem

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