Entity Definition

Logical Name : ItemDeletion
Physical Name : MA_DLT_ITM

A type of ItemMaintenanceEvent that deletes an Item entity and its associated supporting attributive entities.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroupItem(AS_BSNGP_ITM)
ItemID (FK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) BusinessUnitGroupItem(AS_BSNGP_ITM)
EffectiveDateTime (FK) The date from which the BusinessUnits in the group carry the Item. TS_EF EffectiveDateTime datetime BusinessUnitGroupItem(AS_BSNGP_ITM)


Parent Entity Verb Phrase Child Entity
BusinessUnitGroupItem is deleted via ItemDeletion
ItemMaintenanceEvent can be a ItemDeletion

Logical Views containing ItemDeletion

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View