Jump to content

ERP Internals/Data Tables/Sales Order/Header

From Wikibooks, open books for an open world

This table contains one record for each invoice. This table layout is almost identical to the Accounts Receivable Invoice Header

Used by: Accounts Receivable, Order Entry/Invoicing, Time Billing, Service Management

Key: Sales Order Number

Fields:

  • Sales Order Number
  • Customer Number
  • Invoice Type
  • Invoice Date
  • Terms
  • FOB
  • Ship Via
  • Bill To
  • Ship To
  • Price List
  • Invoice Amount
  • Tax Amount
  • Freight Amount
  • Currency
  • Purchase Order
  • Status
  • Hold Date
  • Hold Authorization (User and Date/Time, encrypted)
  • Hold Type
  • Comment (unique to this invoice, prints on invoice)
  • General Ledger Account Number (Invoice)
  • General Ledger Account Number (Tax)
  • General Ledger Account Number (Freight)
  • Posted to General Ledger Date/Time