Logical 02130 - Item Inventory - Receiving View

Top  Previous  Next

Subject Area Concepts

The Logical 02130 – Item Inventory Receiving View subject area shows that the ICDMerchandiseLineItem from a ReceivingDocument is "posted" to the ItemInventoryJournalEntry, which in turn informs the ItemInventory to update the current inventory on hand.

The entity diagram incorporates the entities ShipmentContainer and ShipmentContainerLineItem, which describe the contents of a multi-item shipment. Entities SupplierItemReceivingUnit, ContainerType and SupplierItemReceivingUnitConversionRule describe how the receiving units are measured and counted for receiving, stocking, marking, presentation and selling.  A core function of a business unit in retail is to break bulk packages of merchandise down into retail-sale-units for presentation to customers. The number of levels required to break an item down from its bulk receiving units into its retail sale units varies by stock item type.  The data model allows a retailer to specify from one to n breakdown levels.  As a practical matter, however, managing more than four levels is very difficult and complex.

The model assumes that all deliveries to a BusinessUnit are made in a ShipmentContainer.  This generic entity includes a type code attribute that relates to the UCC guidelines.  Examples include pallets, totes, cartons, etc.  Each container is identified through its unique shipment ID and container type code. The model contains a conversion rule that is able, also from the type code, to expand the ShipmentContainer into its constituent components. The number of ShipmentContainers will be referenced on the FreightBill.  An InboundInventoryCondition entity is used to record the condition of each container using a lookup code table.