ERP Internals/Data Tables/Sales Order/Line

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)