Entity Definition

Logical Name : ICDMerchandiseItemUnit
Physical Name : CO_ICD_MR_ITM_UN

A cross reference of ICD Merchandise Line Items to ItemUnits. This allows for the tracking of multiple lots or serialized units per line item of an inventory control document.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
InventoryControlDocumentID (FK)(PK) The reference number that uniquely identifies the InventoryControlDocument. ID_ICD Identity integer ICDMerchandiseLineItem(DO_LTM_ICD_MR)
InventoryControlDocumentLineItemID (FK)(PK) A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. IC_LTM_ICD LineNumber smallint ICDMerchandiseLineItem(DO_LTM_ICD_MR)
ItemTraceableUnitID (FK)(PK) A universally unique identifier used to identify an instance of a distinguisable instance of a retail item. The item traceable unit ID is similar to a serial number in that it allows each selling unit to be explicitly identified and distinguished from other sellling units of the same Item. ID_ITM_UN_TRC IdentityUUID CHAR(32) ItemTraceableUnit(AS_ITM_TRCBL_UN)


Parent Entity Verb Phrase Child Entity
ICDMerchandiseLineItem references ICDMerchandiseItemUnit
ItemTraceableUnit defines traceability of ICDMerchandiseItemUnit

Logical Views containing ICDMerchandiseItemUnit

Logical View
Logical 02110 - Item Inventory - Location View
Logical 02309 - Retail Transaction Delivery
Logical 21000 - Fresh Item Management Macro View