ERP Internals/Data Tables/Item Analysis

From Wikibooks, open books for an open world
Jump to navigation Jump to search

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