civicrm_financial_account

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_entity_financial_account.financial_account_id FK_civicrm_entity_financial_account_financial_account_idR
civicrm_financial_account.parent_id FK_civicrm_financial_account_parent_idR
civicrm_financial_item.financial_account_id FK_civicrm_financial_item_financial_account_idR
civicrm_financial_trxn.from_financial_account_id FK_civicrm_financial_trxn_from_financial_account_idR
civicrm_financial_trxn.to_financial_account_id FK_civicrm_financial_trxn_to_financial_account_idR

ID
name VARCHAR 255 null

Financial Account Name.
contact_id INT UNSIGNED 10 √ null
civicrm_contact.id FK_civicrm_financial_account_contact_idN

FK to Contact ID that is responsible for the funds in this account
financial_account_type_id INT UNSIGNED 10 3

pseudo FK into civicrm_option_value.
accounting_code VARCHAR 64 √ null

Optional value for mapping monies owed and received to accounting system codes.
account_type_code VARCHAR 64 √ null

Optional value for mapping account types to accounting system account categories (QuickBooks Account Type Codes for example).
description VARCHAR 255 √ null

Financial Type Description.
parent_id INT UNSIGNED 10 √ null
civicrm_financial_account.id FK_civicrm_financial_account_parent_idR

Parent ID in account hierarchy
is_header_account TINYINT 3 √ 0

Is this a header account which does not allow transactions to be posted against it directly, but only to its sub-accounts?
is_deductible TINYINT 3 √ 1

Is this account tax-deductible?
is_tax TINYINT 3 √ 0

Is this account for taxes?
tax_rate DECIMAL 10,8 √ null

The percentage of the total_amount that is due for this tax.
is_reserved TINYINT 3 √ null

Is this a predefined system object?
is_active TINYINT 3 √ null

Is this property active?
is_default TINYINT 3 √ null

Is this account the default one (or default tax one) for its financial_account_type?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_financial_account_contact_id Performance Asc contact_id
FK_civicrm_financial_account_parent_id Performance Asc parent_id
UI_name Must be unique Asc name

Relationships

Close relationships within degrees of separation