ERP Internals/Data Tables/Sales Analysis

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

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

Used by: Sales Analysis, Order Entry/Invoicing

Key: Transaction Number

  • Transaction Number (a unique number assigned by the ERP package)
  • Customer Number
  • Sales Representative Number
  • Branch Number
  • Division Number
  • Territory Number
  • Item Number
  • Date
  • Quantity
  • Price
  • Currency