Jump to content

ERP Internals/Data Tables/Item Transaction

From Wikibooks, open books for an open world

This table contains one record for every Inventory transaction.

Used by: Inventory

Key: Transaction Number

Fields:

  • Transaction Number (a unique number assigned by the ERP package)
  • Item Number
  • Date
  • Type (Issue/Receipt/Count)
  • Quantity
  • Amount
  • Currency
  • From Location
  • To Location
  • Posted to General Ledger Date/Time