|
Keith,
I just checked. The receipt number (column is receipt_number) can be found in mifostenant-default.m_payment_detail
And there is no way one can query it and at the same time query the matching transaction (savings/loans) since there's no references key to any of those transactions tables.
In my opinion, one solution would be to add to the above table, one more column with a reference to a transaction table, for instance mifostenant-default.m_savings_account_transaction table, in order to match a particular transaction to a receipt number.
|
