 MODIFY BALANCE_INTEREST_AMOUNT DECIMAL(21,4),
 MODIFY BALANCE_PENALTY_AMOUNT DECIMAL(21,4),
 MODIFY BALANCE_FEE_AMOUNT DECIMAL(21,4);
--- medium
+
 ALTER TABLE LOAN_SUMMARY 
 MODIFY ORIG_PRINCIPAL DECIMAL(21,4), 
 MODIFY ORIG_INTEREST DECIMAL(21,4), 

MODIFY FEES_PAID DECIMAL(21,4),
MODIFY PENALTY_PAID DECIMAL(21,4),
MODIFY RAW_AMOUNT_TOTAL DECIMAL(21,4);
-- medium
ALTER TABLE CUSTOMER_ACCOUNT_ACTIVITY 
MODIFY AMOUNT DECIMAL(21,4);
-- large
ALTER TABLE ACCOUNT_PAYMENT 
MODIFY AMOUNT DECIMAL(21,4) NOT NULL;
-- large
ALTER TABLE CUSTOMER_SCHEDULE
MODIFY MISC_FEES DECIMAL(21,4),
MODIFY MISC_FEES_PAID DECIMAL(21,4), 
MODIFY MISC_PENALTY DECIMAL(21,4),
MODIFY MISC_PENALTY_PAID DECIMAL(21,4);
-- large
ALTER TABLE LOAN_SCHEDULE 
MODIFY PRINCIPAL DECIMAL(21,4) NOT NULL,
MODIFY INTEREST DECIMAL(21,4) NOT NULL,

MODIFY PRINCIPAL_PAID DECIMAL(21,4),
MODIFY INTEREST_PAID DECIMAL(21,4),
MODIFY PENALTY_PAID DECIMAL(21,4);

ALTER TABLE SAVING_SCHEDULE 
MODIFY DEPOSIT DECIMAL(21,4) NOT NULL,
MODIFY DEPOSIT_PAID DECIMAL(21,4);

ALTER TABLE ACCOUNT_FEES 
MODIFY ACCOUNT_FEE_AMNT DECIMAL(21,4) NOT NULL,
MODIFY FEE_AMNT DECIMAL(21,4) NOT NULL;

ALTER TABLE SAVINGS_ACCOUNT 
MODIFY SAVINGS_BALANCE DECIMAL(21,4),
MODIFY RECOMMENDED_AMOUNT DECIMAL(21,4),
MODIFY INT_TO_BE_POSTED DECIMAL(21,4),
MODIFY MIN_AMNT_FOR_INT DECIMAL(21,4);

ALTER TABLE SAVINGS_ACTIVITY_DETAILS 
MODIFY AMOUNT DECIMAL(21,4) NOT NULL,
MODIFY BALANCE_AMOUNT DECIMAL(21,4) NOT NULL;

ALTER TABLE SAVINGS_PERFORMANCE 
MODIFY TOTAL_DEPOSITS DECIMAL(21,4),
MODIFY TOTAL_WITHDRAWALS DECIMAL(21,4),
MODIFY TOTAL_INTEREST_EARNED DECIMAL(21,4);

ALTER TABLE ACCOUNT_TRXN 
MODIFY AMOUNT DECIMAL(21,4) NOT NULL;

ALTER TABLE FEE_TRXN_DETAIL
MODIFY FEE_AMOUNT DECIMAL(21,4) NOT NULL;

ALTER TABLE LOAN_FEE_SCHEDULE 
MODIFY AMOUNT DECIMAL(21,4),
MODIFY AMOUNT_PAID DECIMAL(21,4) NOT NULL;

ALTER TABLE CUSTOMER_FEE_SCHEDULE
MODIFY AMOUNT DECIMAL(21,4),
MODIFY AMOUNT_PAID DECIMAL(21,4);

ALTER TABLE SAVINGS_TRXN_DETAIL
MODIFY DEPOSIT_AMOUNT DECIMAL(21,4) ,
MODIFY WITHDRAWAL_AMOUNT DECIMAL(21,4) ,
MODIFY INTEREST_AMOUNT DECIMAL(21,4) ,
MODIFY BALANCE DECIMAL(21,4);

ALTER TABLE LOAN_TRXN_DETAIL
MODIFY PRINCIPAL_AMOUNT DECIMAL(21,4),
MODIFY INTEREST_AMOUNT DECIMAL(21,4),
MODIFY PENALTY_AMOUNT DECIMAL(21,4),
MODIFY MISC_FEE_AMOUNT DECIMAL(21,4),
MODIFY MISC_PENALTY_AMOUNT DECIMAL(21,4);

ALTER TABLE CUSTOMER_TRXN_DETAIL
MODIFY TOTAL_AMOUNT DECIMAL(21,4),
MODIFY MISC_FEE_AMOUNT DECIMAL(21,4),
MODIFY MISC_PENALTY_AMOUNT DECIMAL(21,4);

ALTER TABLE CUSTOMER_LOAN_ACCOUNT_DETAIL
MODIFY PRINCIPAL DECIMAL(21,4) NOT NULL,
MODIFY INTEREST DECIMAL(21,4) NOT NULL,
MODIFY PENALTY DECIMAL(21,4) NOT NULL;

ALTER TABLE FINANCIAL_TRXN
MODIFY POSTED_AMOUNT DECIMAL(21,4) NOT NULL,
MODIFY BALANCE_AMOUNT DECIMAL(21,4) NOT NULL;
