Financial Views

Financial View: Bank Account

View name: rpt.bank_account

Type: Record

Description: Bank Account Information

Field	Data Type
bank_account_id	integer
bank_account_name	text
bank_account_no	text

Financial View: Site Bank Accounts

View name: rpt.site_bank_accounts

Type: Cross Reference

Description: Site Bank Accounts

Field	Data Type	Notes
bank_account_id	integer	References bank_account_id in rpt.bank_account
site_id	integer	References site_id in rpt.site

Financial View: Invoice Fee Adjustment Reason

View name: rpt.invoice_fee_adjustment_reason

Type: Record

Description: Invoice Fee Adjustment Reason

Field	Data Type
invoice_fee_adjustment_reason_id	integer
invoice_fee_adjustment_reason_name	character varying
invoice_fee_adjustment_category_id	integer
invoice_fee_adjustment_category	character varying

Financial View: Tax Schedule

View name: rpt.tax_schedule

Type: Record

Description: Tax Schedule

Field	Data Type
tax_schedule_id	integer
tax_schedule_name	character varying (30)
tax_schedule_short_name	character varying (4)
tax_schedule_notes	text

Financial View: Tax Rate

View name: rpt.tax_rate

Type: Record

Description: Tax Rate

Field	Data Type
tax_rate_id	integer
tax_rate_name	character varying (30)
tax_rate_short_name	character varying (4)
tax_rate_percent	numeric (6, 5)
tax_rate_registration_no	text
tax_rate_is_active	boolean
tax_rate_notes	text

Financial View: Tax Rate Schedules

View name: rpt.tax_rate_schedules

Type: Cross Reference

Description: Tax Rate Schedules

Field	Data Type	Notes
tax_rate_id	integer	References tax_rate_id in rpt.tax_rate
tax_schedule_id	integer	References tax_schedule_id in rpt.tax_schedule

Financial View: Batch

View name: rpt.batch

Type: Record

Description: Batch

Field	Data Type	Notes
batch_id	integer
batch_name	text
batch_date	date
batch_is_posted	boolean
site_id	integer	References site_id in rpt.site

Financial View: Invoice

View name: rpt.invoice

Type: Record

Description: Invoice

Field	Data Type	Notes
invoice_id	integer
invoice_account_type_id	integer
invoice_account_type	text
individual_id	integer	References individual_id in rpt.individual
funder_id	integer	References funder_id in rpt.funder
invoice_date	date
batch_id	integer	References batch_id in rpt.batch
invoice_bill_to	character varying

Financial View: Invoice Fee

View name: rpt.invoice_fee

Type: Record

Description: Invoice Fee

Field	Data Type	Notes
invoice_fee_id	integer
invoice_id	integer	References invoice_id in rpt.invoice
event_service_item_id	integer	References event_service_item_id in rpt.event_service_item
invoice_fee_qty	numeric (10, 2)
invoice_fee_amt	numeric (10, 2)
adjustment_total	numeric
invoice_fee_sub_total	numeric (10, 2)	(invoice_fee_qty * invoice_fee_amt) - adjustment_total
invoice_fee_tax_total	numeric
invoice_fee_total	numeric	invoice_fee_sub_total + invoice_fee_tax_total

Financial View: Invoice Fee Profile

View name: rpt.invoice_fee_profile

Type: Profile

Description: Invoice Fee Detail Information

Field	Data Type	Notes
invoice_fee_id	integer	References invoice_fee_id in rpt.invoice_fee
invoice_id	integer	References invoice_id in rpt.invoice
event_service_item_id	integer	References event_service_item_id in rpt.event_service_item
invoice_fee_qty	numeric (10, 2)
invoice_fee_amt	numeric (10, 2)
adjustment_total	numeric
invoice_fee_sub_total	numeric (10, 2)	(invoice_fee_qty * invoice_fee_amt) - adjustment_total
invoice_fee_tax_total	numeric
invoice_fee_total	numeric	invoice_fee_sub_total + invoice_fee_tax_total
invoice_fee_type_id	integer
invoice_fee_type	character varying (25)
policy_coverage_id	integer	References policy_coverage_id in rpt.policy_coverage
policy_individuals_individual_id	integer	References individual_id in rpt.individual
funder_department_id	integer	References funder_department_id in rpt.funder_department
credit_id	integer	This column is always NULL and should not be referenced for reporting.
return_invoice_fee_id	integer	This column is always NULL and should not be referenced for reporting. See rpt.event_service_item_profile for information on returned service units.

Financial View: Invoice Fee Adjustments

View name: rpt.invoice_fee_adjustments

Type: Record

Description: Invoice Fee Adjustments

Field	Data Type	Notes
invoice_fee_id	integer	References invoice_fee_id in rpt.invoice_fee
invoice_fee_adjustment_reason_id	integer	References invoice_fee_adjustment_reason_id in rpt.invoice_fee_adjustment_reason
adjustment_amt	numeric (10, 2)

Financial View: Invoice Fee Taxes

View name: rpt.invoice_fee_taxes

Type: Record

Description: Invoice Fee Taxes

Field	Data Type	Notes
invoice_fee_id	integer	References invoice_fee_id in rpt.invoice_fee
tax_rate_id	integer	References tax_rate_id in rpt.tax_rate
invoice_fee_tax_amt	numeric (10, 2)

Financial View: Debit Note

View name: rpt.debit_note

Type: Record

Description: Debit Note

Field	Data Type	Notes
debit_note_id	integer
debit_note_account_type_id	integer
debit_note_account_type	text
individual_id	integer	References individual_id in rpt.individual
funder_id	integer	References funder_id in rpt.funder
debit_note_date	date
debit_note_reference_no	text
debit_note_description	text

Financial View: Debit Note Fee

View name: rpt.debit_note_fee

Type: Record

Description: Debit Note Fee

Field	Data Type	Notes
debit_note_fee_id	integer
debit_note_id	integer	References debit_note_id in rpt.debit_note
debit_note_fee_amt	numeric (10, 2)
debit_note_fee_tax_total	numeric (10, 2)
debit_note_fee_total	numeric (10, 2)	debit_note_fee_amt + debit_note_fee_tax_total
site_id	integer	References site_id in rpt.site
service_id	integer	References service_id in rpt.service
debit_note_fee_reason_id	integer
debit_note_fee_reason	character varying (60)

Financial View: Debit Note Fee Taxes

View name: rpt.debit_note_fee_taxes

Type: Record

Description: Debit Note Fee Taxes

Field	Data Type	Notes
debit_note_fee_id	integer	References debit_note_fee_id in rpt.debit_note_fee
tax_rate_id	integer	References tax_rate_id in rpt.tax_rate
debit_note_fee_tax_amt	numeric (10, 2)

Financial View: Credit

View name: rpt.credit

Type: Record

Description: Credit

Field	Data Type	Notes
credit_id	integer
credit_account_type_id	integer
credit_account_type	text
individual_id	integer	References individual_id in rpt.individual
funder_id	integer	References funder_id in rpt.funder
credit_date	date
financial_transaction_type_id	integer
financial_transaction_type	character varying (10)
credit_cheque_no	character varying
credit_description	text
deposit_id	integer	References deposit_id in rpt.deposit

Financial View: Credit Fee

View name: rpt.credit_fee

Type: Record

Description: Credit Fee

Field	Data Type	Notes
credit_fee_id	integer
credit_id	integer	References credit_id in rpt.credit
credit_fee_amt	numeric (10, 2)
site_id	integer	References site_id in rpt.site
service_id	integer	References service_id in rpt.service
receipt_reason_id	integer
receipt_reason	character varying (60)

Financial View: Deposit

View name: rpt.deposit

Type: Record

Description: Deposit

Field	Data Type	Notes
deposit_id	integer
deposit_date	date
bank_account_id	integer	References bank_account_id in rpt.bank_account
deposit_type_id	integer
deposit_type	character varying (50)
is_deposited	boolean
site_id	integer	References site_id in rpt.site
deposit_note	text

Financial View: Applied Credits

View name: rpt.applied_credits

Type: Record

Description: Applied Credits

Field	Data Type	Notes
credit_fee_id	integer	References credit_fee_id in rpt.credit_fee
invoice_fee_id	integer	References invoice_fee_id in rpt.invoice_fee
debit_note_fee_id	integer	References debit_note_fee_id in rpt.debit_note_fee
applied_credit_amt	numeric (10, 2)

Views and Standard Views