|
Mike's description:
Normal Process: a client pays a Recurring Deposit Amount of 400 NGN daily into his Recurring Deposit Account locally named as Daily Contribution Account
The account is setup as follows:
Period: 12 Months Rate of Interest: 0% Deposit Frequency: Daily
Recurring Deposit Amount: 400 NGN Account ID: 5
What MFI allows:
A client can update only is Recurring Deposit Amount (Up or Down in current value) all other settings remain the same,
A client is allowed to withdraw funds from his account
My Local solution:
I run a SQL query that updates three (3) tables:
M_DEPOSIT_ACCOUNT_RECURRING_DETAIL
M_MANDATORY_SAVINGS_SCHEDULE
M_DEPOSIT_ACCOUNT_TERM_AND_PRECLOSURE
UPDATE m_deposit_account_recurring_detail SET mandatory_recommended_deposit_amount = '400.000000' WHERE id = ‘5’;
UPDATE m_mandatory_savings_schedule SET deposit_amount = '400.000000'
WHERE savings_account_id = '5'
AND duedate > '2014-12-03'
UPDATE m_deposit_account_term_and_preclosure SET maturity_amount =
(Select sum( deposit_amount) as DA from m_mandatory_savings_schedule WHERE savings_account_id='5')
WHERE savings_account_id = '5'
|
