Linking BTX and Contributions

It's always useful to be able to track back from a contribution to the source BTX it was derived from. In many cases, it's equally useful to store some additional info about the match. For the BTX, we can use the suggestions field and maintain the last suggestion in an executed state, but this is not easily searchable.

An easier way is to have a separate table called civicrm_bank_tx_match, which looks like this :

• bank_tx_id INT(11) FK to civicrm_bank_tx
• contrib_id INT(11) FK to civicrm_contribution
• match_date DATETIME
• bank_pi_id INT(11) FK tp civicrm_bank_plugin_instance
• description TEXT description of what the match was about