ERP Internals/Data Tables/Sales Order/Header

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