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