|
Vishwas, any ideas on best way to resolve this issue musoni are seeing.
Basically they want to be able to get at the details on the m_payment_detail from their journal entries screen.
The entity_id, entity_type_enum and transaction_id (a varchar and not BIGINT) columns can identify what type of portfolio transaction this journal entry came from. So in case of loan you would need to join onto the m_loan_transactions table and from there join onto m_payment_detail table.
Would something like the following not work Sander?
SELECT
gl.entity_id as entityId,
gl.entity_type_enum as entityType,
gl.transaction_id as trxnId,
pd.account_number as accNo
FROM `mifostenant-default`.acc_gl_journal_entry gl
left join m_loan_transaction lt on gl.transaction_id = lt.id
left join m_payment_detail pd on lt.payment_detail_id = pd.id;
|