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 |
|
|
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 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 |
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
Close relationships within degrees of separation
