civicrm_financial_item


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
created_date TIMESTAMP 19 CURRENT_TIMESTAMP

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
civicrm_contact.id 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
civicrm_financial_account.id 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

Indexes

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

Relationships