Open main menu

Wikibooks β

ERP Internals/Data Tables/Sales Order/Line

< ERP Internals‎ | Data Tables‎ | Sales Order

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


  • 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)