civicrm_entity_financial_trxn

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

INT UNSIGNED

10

√

null

ID

entity_table

VARCHAR

64

null

May contain civicrm_financial_item, civicrm_contribution, civicrm_financial_trxn, civicrm_grant, etc

entity_id

INT UNSIGNED

10

null

financial_trxn_id

INT UNSIGNED

10

√

null

FK_civicrm_entity_financial_trxn_financial_trxn_idN

amount

DECIMAL

20,2

null

allocated amount of transaction to this entity

Showing 1 to 5 of 5 entries

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
FK_civicrm_entity_financial_trxn_financial_trxn_id	Performance	Asc	financial_trxn_id
UI_entity_financial_trxn_entity_id	Performance	Asc	entity_id
UI_entity_financial_trxn_entity_table	Performance	Asc	entity_table

Showing 1 to 4 of 4 entries