IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_INTEREST_DETAIL' AND KSQL_COL_NAME ='FDAILYRATE') 
 ALTER TABLE T_FA_INTEREST_DETAIL ADD (FDAILYRATE DECIMAL(19,6) );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FA_LEASE_RENT_SETTLE' AND KSQL_COL_NAME ='FINTERESTDAYS') 
 ALTER TABLE T_FA_LEASE_RENT_SETTLE ADD (FINTERESTDAYS INT DEFAULT 0 NOT NULL );