Shekko, Pretty big area and if you have a specific 'query' I might be able to help.
Otherwise. for loans... table loan_schedule hold installment details (and amounts paid) for principal, interest, miscellaneous charges and penalties, field payment_status = 0 (unpaid), 1 (paid) and action_date is the 'due date'. table loan_fee_schedule (joined to loan_schedule on 'id' to 'id') holds period fees for the installment. loan_summary holds some derived information such as the original and paid amounts account_payments holds details of payments. The starting point is usually with the tables below: customer --1:M-> account --1:1-> loan_account then on to summaries, schedules, payments John On Thu, May 27, 2010 at 11:36 AM, Shekko <[email protected]>wrote: > hi > > how/from where can i retrieve(field, table) the actual amount to > pay(actual principal, actual, interest, fees,...) > > and the total amount arrear(principal, interes, fees, ...). > > so, there is any model database documentation updated?, i cannot find > any. > > thankyou > > > ------------------------------------------------------------------------------ > > _______________________________________________ > 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
