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)