ERP Internals/Data Tables/Item Analysis

This table contains one record for every receipt into Inventory. It is optimized for quick access and updated once a day from the live data.

Used by: Inventory

Key: Transaction ID
 * Transaction ID (a unique number assigned by the ERP package)
 * Item ID
 * Supplier ID
 * Date
 * Quantity