civicrm_financial_type - civicrm Database

Columns

Related columns Constraint Comments

Search:

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?

Showing 1 to 6 of 6 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees