ok this is my query select account.account_id,reg.display_name,office.display_name,customer.global_cust_num,customer.display_name,account.global_account_num,account.external_id, loanproduct.prd_offering_short_name,loanproduct.prd_offering_name,la.disbursement_date,loan_summary.orig_principal, loan_schedule.principal,loan_schedule.interest,min(loan_schedule.action_date),loan_schedule.misc_fees,loan_schedule.penalty, (loan_schedule.principal+loan_schedule.interest+loan_schedule.misc_fees +loan_schedule.penalty) saldo_vigente from account join office on account.office_id = office.office_id join office reg on office.parent_office_id = reg.office_id join customer on account.customer_id = customer.customer_id join loan_account la on la.account_id = account.account_id left join prd_offering loanproduct on loanproduct.prd_offering_id = la.prd_offering_id join loan_summary on account.account_id = loan_summary.account_id join loan_schedule on account.account_id = loan_schedule.account_id where loan_schedule.action_date >= '2010-06-18' group by account.account_id order by account.account_id asc
also i need include: principal due, interest due, fees due, penalty due (all due, but by every entry) i really thank you On 27 mayo, 09:44, Adam Monsen <[email protected]> wrote: > > there is any model database documentation > > Yes! > > Seehttp://ci.mifos.org/schema/ > > (http://article.gmane.org/gmane.comp.finance.mifos.devel/8680) > > signature.asc > < 1 KBVerDescargar > > ------------------------------------------------------------------------------ > > _______________________________________________ > Mifos-users mailing list > [email protected]https://lists.sourceforge.net/lists/listinfo/mifos-users ------------------------------------------------------------------------------ _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
