Jump to content

ERP Internals/Data Tables/Accounts Receivable Payment/Line

From Wikibooks, open books for an open world

This table contains one record for every invoice paid by a Customer payment. Each payment pays one or more customer invoices. Payments can be a deposit, a regular payment (full or partial) or a holdback payment.

Used by: Accounts Receivable

Key: Bank Account Number, Deposit Date, Customer Number, Payment Number, Invoice Number

Fields:

  • Bank Account Number
  • Deposit Date
  • Customer Number
  • Payment Number
  • Invoice
  • Amount
  • Type (Deposit/Regular/Holdback)