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)