RelatedItemAssociation

Entity Definition

Logical Name : RelatedItemAssociation
Physical Name : CO_ASCTN_RLTD_ITM

An association betwen two items where the two items are commonly sold together. For example a car battery is often sold with an attached core charge which is a kind of refundable fee a customer pays for battery recycleing. Another example is drink container deposits. The deposit item is often linked to the drink itslfe. This also may apply to rental items where the rental item will have a deposit item attached or possibly another consumable item like fuel. For example ABC Outdoor Equipment may rent a chainsaw and along with it include a full tank of fuel ( a linked item). ARTS offers several ways to associate items together when recording their sale. This method builds the association into the item. The others involve linking line items in a retail transaction.

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) Item(AS_ITM)
RelatedItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_RLTD IdentityUUID char(32) Item(AS_ITM)
RelatedItemAssociationTypeCode (FK)(PK) A retailer assigned code defining a type of association between two items that are generally sold together. CD_TYP_RLTD_ITM Code2 char(2) RelatedItemAssociationType(CO_TYP_RLTD_ITM)
RelatedItemAssociationName The name to denote the type of association between the two RELATED ITEMs. NM_ASCTN_RLTD_ITM Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
Item is sold with RelatedItemAssociation
Item has associated with it RelatedItemAssociation
RelatedItemAssociationType classifies RelatedItemAssociation
RelatedItemAssociation is tracked by RelatedItemAssociationSalesSummary

Logical Views containing RelatedItemAssociation

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
Logical 01040 - Item Description - Rental View
Logical 02370 - Retail Transaction - Rental View
Logical 03200 - Reporting - Item Sales View