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