civicrm_financial_type

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_contribution.financial_type_id FK_civicrm_contribution_financial_type_idR
civicrm_contribution_page.financial_type_id FK_civicrm_contribution_page_financial_type_idR
civicrm_contribution_product.financial_type_id FK_civicrm_contribution_product_financial_type_idN
civicrm_contribution_recur.financial_type_id FK_civicrm_contribution_recur_financial_type_idN
civicrm_grant.financial_type_id FK_civicrm_grant_financial_type_idN
civicrm_line_item.financial_type_id FK_civicrm_line_item_financial_type_idN
civicrm_membership_type.financial_type_id FK_civicrm_membership_type_financial_type_idR
civicrm_pledge.financial_type_id FK_civicrm_pledge_financial_type_idR
civicrm_premiums_product.financial_type_id FK_civicrm_premiums_product_financial_type_idN
civicrm_price_field_value.financial_type_id FK_civicrm_price_field_value_financial_type_idN
civicrm_price_set.financial_type_id FK_civicrm_price_set_financial_type_idN
civicrm_product.financial_type_id FK_civicrm_product_financial_type_idN

ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp
name VARCHAR 64 null

Financial Type Name.
description VARCHAR 255 √ null

Financial Type Description.
is_deductible TINYINT 3 √ 1

Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.
is_reserved TINYINT 3 √ null

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

Is this property active?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UI_id Must be unique Asc id

Relationships

Close relationships within degrees of separation