Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
||||
| from_financial_account_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to financial_account table. |
|||
| to_financial_account_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to financial_financial_account table. |
|||
| trxn_date | DATETIME | 19 | √ | null |
|
|
date transaction occurred |
|||
| total_amount | DECIMAL | 20,2 | null |
|
|
amount of transaction |
||||
| fee_amount | DECIMAL | 20,2 | √ | null |
|
|
actual processor fee if known - may be 0. |
|||
| net_amount | DECIMAL | 20,2 | √ | null |
|
|
actual funds transfer amount. total less fees. if processor does not report actual fee during transaction, this is set to total_amount. |
|||
| currency | VARCHAR | 3 | √ | null |
|
|
3 character string, value from config setting or input via user. |
|||
| trxn_id | VARCHAR | 255 | √ | null |
|
|
user-specified unique processor transaction id, bank id + trans id,… depending on payment_method |
|||
| trxn_result_code | VARCHAR | 255 | √ | null |
|
|
processor result code |
|||
| status_id | INT UNSIGNED | 10 | √ | null |
|
|
pseudo FK to civicrm_option_value of financial_item status option_group |
|||
| payment_processor_id | INT UNSIGNED | 10 | √ | null |
|
|
Payment Processor for this financial transaction |
|||
| payment_instrument_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to payment_instrument option group values |
|||
| card_type_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to accept_creditcard option group values |
|||
| check_number | VARCHAR | 255 | √ | null |
|
|
Check number |
|||
| pan_truncation | VARCHAR | 4 | √ | null |
|
|
Last 4 digits of credit card |
|||
| is_payment | TINYINT | 3 | √ | 0 |
|
|
Is this entry either a payment or a reversal of a payment? |
|||
| order_reference | VARCHAR | 255 | √ | null |
|
|
Payment Processor external order reference |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_financial_trxn_from_financial_account_id | Performance | Asc | from_financial_account_id |
| FK_civicrm_financial_trxn_payment_processor_id | Performance | Asc | payment_processor_id |
| FK_civicrm_financial_trxn_to_financial_account_id | Performance | Asc | to_financial_account_id |
| index_trxn_id | Performance | Asc | trxn_id |
| UI_ftrxn_check_number | Performance | Asc | check_number |
| UI_ftrxn_payment_instrument_id | Performance | Asc | payment_instrument_id |
Relationships
Close relationships within degrees of separation
