ERP Internals/Data Tables/Sales Order/Line

From Wikibooks, open books for an open world
< ERP Internals‎ | Data Tables‎ | Sales Order
Jump to: navigation, 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)