You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@fineract.apache.org by Ippez Robert <ip...@gmail.com> on 2017/05/12 09:59:44 UTC
Fwd: Query savings account linked to a loan account - column name and
which table is it found
Which table and column do i get the savings account linked to a loan during
loan creation when Create Standing Instruction at Disbursement is checked?
Am designing a report and i need this field (linked account)
--
Ippez Roberts
Tel: +256788725408 <+256%20788%20725408>/789643284
Skype ID: ippez.robert1
Email: ippezrobert@gmail.com
Re: Query savings account linked to a loan account - column name and
which table is it found
Posted by Ippez Robert <ip...@gmail.com>.
Hi Sampath,
I have got it, Thanks, It solved my issue as below, hope am correct
*select l.account_no as loanAccount, sa.account_no as linkedAccount,
sa.account_no as surplusAccount from m_loan lleft join
m_portfolio_account_associations mp on mp.loan_account_id = l.id
<http://l.id> left join m_savings_account sa on sa.id <http://sa.id> =
mp.linked_savings_account_id*
*where l.account_no=${accountNo}*
Thanks
Regards
On Fri, May 12, 2017 at 2:25 PM, Sampath Kumar G <
sampath@confluxtechnologies.com> wrote:
> Hi Ippez,
>
> In m_portfolio_account_associations table, you will get those details.
>
>
>
> Regards,
> Sampath
>
>
>
> *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> *#304,
> 2nd Floor, 7th Main Road
>
> HRBR Layout 1st Block
>
> Bengaluru, Karnataka, 560043 INDIA
>
>
> Disclaimer: The information contained in this e-mail message and any
> files/attachment transmitted with it is confidential and for the sole use
> of the intended recipient(s) or entity identified. If you are not the
> intended recipient, please email: support@confluxtechnologies.com and
> destroy/delete all copies and attachment thereto along with the original
> message. Any unauthorised review, use, disclosure, dissemination,
> forwarding, printing or copying of this email or any action taken in
> reliance on this e-mail is strictly prohibited and is unlawful. The
> recipient acknowledges that Conflux Technologies Private Limited or its
> subsidiaries and associated companies are unable to exercise control or
> ensure or guarantee the integrity of/over the contents of the information
> contained in e-mail transmissions. Before opening any attachments, please
> check.
>
>
> On Fri, May 12, 2017 at 3:29 PM, Ippez Robert <ip...@gmail.com>
> wrote:
>
> > Which table and column do i get the savings account linked to a loan
> during
> > loan creation when Create Standing Instruction at Disbursement is
> checked?
> >
> > Am designing a report and i need this field (linked account)
> > --
> > Ippez Roberts
> >
> > Tel: +256788725408 <+256%20788%20725408>/789643284
> > Skype ID: ippez.robert1
> > Email: ippezrobert@gmail.com
> >
>
--
Ippez Roberts
Director & Founder - Skyline Technologies Uganda
"IT Consultants & Engineers"
P.O.Box 155, Moyo
UGANDA.
Tel: +256788725408/789643284
Skype ID: ippez.robert1
Email: ippezrobert@gmail.com
Re: Query savings account linked to a loan account - column name and
which table is it found
Posted by Sampath Kumar G <sa...@confluxtechnologies.com>.
Hi Ippez,
In m_portfolio_account_associations table, you will get those details.
Regards,
Sampath
*Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/> *#304,
2nd Floor, 7th Main Road
HRBR Layout 1st Block
Bengaluru, Karnataka, 560043 INDIA
Disclaimer: The information contained in this e-mail message and any
files/attachment transmitted with it is confidential and for the sole use
of the intended recipient(s) or entity identified. If you are not the
intended recipient, please email: support@confluxtechnologies.com and
destroy/delete all copies and attachment thereto along with the original
message. Any unauthorised review, use, disclosure, dissemination,
forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and is unlawful. The
recipient acknowledges that Conflux Technologies Private Limited or its
subsidiaries and associated companies are unable to exercise control or
ensure or guarantee the integrity of/over the contents of the information
contained in e-mail transmissions. Before opening any attachments, please
check.
On Fri, May 12, 2017 at 3:29 PM, Ippez Robert <ip...@gmail.com> wrote:
> Which table and column do i get the savings account linked to a loan during
> loan creation when Create Standing Instruction at Disbursement is checked?
>
> Am designing a report and i need this field (linked account)
> --
> Ippez Roberts
>
> Tel: +256788725408 <+256%20788%20725408>/789643284
> Skype ID: ippez.robert1
> Email: ippezrobert@gmail.com
>