411 REFERENCE · Wikibooks
ERP Internals/Data Tables/Sales Order/Line
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
This table contains one record for every line on every sales order. The table layout is virtually identical to the Accounts Receivable Invoice Detail.
Used by: Accounts Receivable, Order Entry/Invoicing, Time Billing, Service Management
Key: Sales Order Number, Line Number
Fields:
Sales Order Number
Line Number (a unique number assigned by the ERP package)
Item Number
Description (this can be multi-line)
Quantity
Back Order
UOM
Price
Tax Code
Tax Amount
Extended Amount (Price x Quantity - Tax)
General Ledger Account Number (Sales)