Inventory Variance

The main entities are

• InventoryItem: Inventory details for a product
• InventoryItemDetail: records information details for an item. There may be multiple rows per InventoryItem
• PhysicalInventory: Records that a party interacted(e.g. counted) inventory on a specific date
• InventoryItemVariance: Records variation for InventoryItem