Standard Views | Financial Transaction

View name: rpt.std_financial_transaction

Description: Financial Transactions, one row for each Invoice, Credit or Debit Note

Field	Data Type	Notes
financial_transaction_type	text	"Invoice", "Debit Note", "Credit", "Payment", "Return" or "Recovery"
debit_note_id	integer	References debit_note_id in rpt.debit_note
invoice_id	integer	References invoice_id in rpt.invoice
credit_id	integer	References credit_id in rpt.credit
account_type_id	integer
account_type	text	"Individual" or "Funder"
individual_id	integer	References individual_id in rpt.individual
funder_id	integer	References funder_id in rpt.funder
transaction_date	date
transaction_sub_total	numeric
transaction_tax_total	numeric
transaction_total	numeric	transaction_sub_total + transaction_tax_total

Views and Standard Views