ERP Internals/Data Tables/Sales Order/Line

From Wikibooks, open books for an open world
Jump to navigation Jump to search

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)