CiviCRM Community Forums (archive)

Could someone confirm the correct relationship of financial_trxn, entity_financial_trxn, participant_payment, financial_item, line_item, contribution, and participant in 4.5.1? dgg explained pretty clearly, and I think I've got it now:

For a participant, there is one contribution and one financial_item, and then there is one entry in entity_financial_trxn linking the financial_item to a trxn from null to accounts receivable if a “pay later” method has been selected, otherwise from null to a payment processor or deposit account, and an entity_financial_trxn linking the same trxn to the contribution. Then further payments (or in the event of a “pay later” method, the first payment and then further payments) made to the same contribution are recorded against it in entity_financial_trxn, as trxn's linked to the contribution. If any of the trxn's have fees associated with them, that information is recorded in the “fee” column of the main trxn, and then an additional trxn is created, linked to a special “Fee” financial_item via entity_financial_trxn, and also linked to the main contribution via entity_financial_trxn. Also, although it's a legacy table, an entry gets added to participant_payment linking the participant to the contribution (this information is also available in line_item, but there are parts of Civi's code that still use participant_payment). Is that correct?

It also seems that, at least upon upgrade of a civi 4.1 database with various payments in it, that the fee_amount of the contribution gets the fee of the first payment made, and then if it's not the full payment (e.g. I manually update line_item to a different fee amount), 4.5.1 treats additional transactions, even cash ones, as though they have the same processor fee. Those fees are not reflected in the interface but are reflected in the database. Is that a bug?