Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Date and time the item was created

transaction_date DATETIME 19 null

Date and time of the source transaction

contact_id INT UNSIGNED 10 null FK_civicrm_financial_item_contact_id C

FK to Contact ID of contact the item is from

description VARCHAR 255 null

Human readable description of this item, to ease display without lookup of source item.

amount DECIMAL 20,2 0.00

Total amount of this item

currency VARCHAR 3 null

Currency for the amount

financial_account_id INT UNSIGNED 10 null FK_civicrm_financial_item_financial_account_id R

FK to civicrm_financial_account

status_id INT UNSIGNED 10 null

Payment status: test, paid, part_paid, unpaid (if empty assume unpaid)

entity_table VARCHAR 64 null

The table providing the source of this item such as civicrm_line_item

entity_id INT UNSIGNED 10 null

The specific source item that is responsible for the creation of this financial_item

Table contained 5 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_financial_item_contact_id Performance Asc contact_id
FK_civicrm_financial_item_financial_account_id Performance Asc financial_account_id
index_entity_id_entity_table Performance Asc/Asc entity_id + entity_table
IX_created_date Performance Asc created_date
IX_transaction_date Performance Asc transaction_date