Title: Message Title
|
|
|
|
Implementation details : Adding script to insert 'fundType' code name to m_code table.
Introducing new column in m_loan table called 'fund_type_cv_id' is the foreign key which capture m_code_value primary key data and column funding_date capture the date of funding.
Creating new table called m_fund_loan_mapping_history which has fields loan_id, fund_id, fund_type_cv_id, start_date, end_date to capture the history of fund, fundType associated with loan.
In this feature get loans new/edit loan application 'Fund type' eg.. hypothication, buyout, etc... and 'Funding date' will be added, both fields are optional.
When 'fundType' is associated with loan and 'fundingDate' is not entered then current date is stored in 'funding_date' field in m_loan table.
When first time combination of 'fund', 'fundType' associate with loan while create/edit at that time 'loan_id', 'fund_id', 'fund_type_cv_id', 'start_date' is captured in m_loan_fund_mapping_history.
Whenever 'fund' or 'fundType' or both changes then 'loan_id', 'fund_id', 'fund_type_cv_id', 'end_date' is captured in m_loan_fund_mapping_history.
To associate loan a/c's fetch loan a/c's based on the attributes parameters like loan status, product, office, loan outstanding percentage, loan outstanding amount etc e . t . and based on the c. Then ' fund type, the fund source ' and 'fundType' is associated with loan accounts loans in bulk manner fashion .
|
|
|
|
|
|
|
|
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues