411 REFERENCE · Wikibooks
ERP Internals/Data Tables/Sales Analysis
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
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