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) |
|