Jump to content

ERP Internals/Data Tables/Accounts Payable Invoice/Line

From Wikibooks, open books for an open world

This table contains one record for every line on every invoice.

Used by: Accounts Payable

Key: Supplier Number, Invoice Number, Line Number

Fields:

  • Supplier Number
  • Invoice Number
  • Line Number (a unique number assigned by the ERP package)
  • Item Number
  • Description
  • Quantity
  • Price
  • Tax Code
  • Tax Amount
  • Extended Amount (Price x Quantity - Tax)
  • Job Number
  • General Ledger Account Number
  • Notes
  • UDF