ItemCollectionSubstitution

Entity Definition

Logical Name : ItemCollectionSubstitution
Physical Name : CO_SBST_ITM

A 3-way join of Items, MemberID within CombinedItemID may be substituted with SubstituteID within an ItemCollection.

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) ItemCollection(CO_CLN_ITM)
MemberItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_MBR IdentityUUID char(32) ItemCollection(CO_CLN_ITM)
SubstituteItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM_SBST IdentityUUID char(32) Item(AS_ITM)
Count The number of Substitute Items that constitute a fair replacement of a Member Item within the Combined Item. QU_ITM_SBST QuantityShortCount decimal(3,0)
PriceAdjustment A monetary value being the change in price for the AggregateItem or Kit that occurs when the substitution occurs. MO_PRC_ADJT MoneyShortRetail decimal(7,2)

Relationships

Parent Entity Verb Phrase Child Entity
Item substitutes ItemCollectionSubstitution
ItemCollection allows ItemCollectionSubstitution

Logical Views containing ItemCollectionSubstitution

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