ERP Internals/Data Tables/Sales Analysis

From Wikibooks, open books for an open world
Jump to: navigation, 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