 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), 

-- small
ALTER TABLE FEES 
MODIFY FEE_AMOUNT DECIMAL(21,4);
-- small
ALTER TABLE CUST_PERF_HISTORY 
MODIFY LAST_LOAN_AMNT DECIMAL(21,4),
MODIFY TOTAL_SAVINGS_AMNT DECIMAL(21,4),
MODIFY DELINQUINT_PORTFOLIO DECIMAL(21,4);
-- medium
ALTER TABLE CUSTOMER_DETAIL 
MODIFY POVERTY_LHOOD_PCT DECIMAL(21,4);
-- small
ALTER TABLE LOAN_OFFERING 
MODIFY MIN_LOAN_AMOUNT DECIMAL(21,4) DEFAULT null,
MODIFY MAX_LOAN_AMNT DECIMAL(21,4) DEFAULT null,
MODIFY DEFAULT_LOAN_AMOUNT DECIMAL(21,4) DEFAULT null;
-- small
ALTER TABLE SAVINGS_OFFERING 
MODIFY RECOMMENDED_AMOUNT DECIMAL(21,4),
MODIFY MAX_AMNT_WITHDRAWL DECIMAL(21,4),
MODIFY MIN_AMNT_FOR_INT DECIMAL(21,4);
-- small
ALTER TABLE CUSTOMER_HISTORICAL_DATA 
MODIFY LOAN_AMOUNT DECIMAL(21,4),
MODIFY TOTAL_AMOUNT_PAID DECIMAL(21,4),
MODIFY INTEREST_PAID DECIMAL(21,4);
-- small
ALTER TABLE ACCOUNT_ACTIVITY 
MODIFY PRINCIPAL DECIMAL(21,4),
MODIFY PRINCIPAL_OUTSTANDING DECIMAL(21,4);
-- medium
ALTER TABLE LOAN_ACCOUNT 
MODIFY LOAN_AMOUNT DECIMAL(21,4),
MODIFY LOAN_BALANCE DECIMAL(21,4);
-- large
ALTER TABLE LOAN_ACTIVITY_DETAILS 
MODIFY PRINCIPAL_AMOUNT DECIMAL(21,4),
MODIFY INTEREST_AMOUNT DECIMAL(21,4),

MODIFY FEES_PAID DECIMAL(21,4),
MODIFY PENALTY_PAID DECIMAL(21,4),
MODIFY RAW_AMOUNT_TOTAL DECIMAL(21,4);

ALTER TABLE CUSTOMER_ACCOUNT_ACTIVITY 
MODIFY AMOUNT DECIMAL(21,4);

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

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);

ALTER TABLE LOAN_SCHEDULE 
MODIFY PRINCIPAL DECIMAL(21,4) NOT NULL,
MODIFY INTEREST DECIMAL(21,4) NOT NULL,
