IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REQBILL'  AND KSQL_COL_NAME IN ('FUNREPAYMENTAMOUNT'))
ALTER TABLE T_ER_REQBILL ADD (FUNREPAYMENTAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_REIMBURSEBILL' AND KSQL_COL_NAME IN ('FUNREPAYMENTAMOUNT'))
ALTER TABLE T_ER_REIMBURSEBILL ADD (FUNREPAYMENTAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYREIMBURSEBILL' AND KSQL_COL_NAME IN ('FUNREPAYMENTAMOUNT'))
ALTER TABLE T_ER_DAILYREIMBURSEBILL ADD (FUNREPAYMENTAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL'  AND KSQL_COL_NAME IN ('FUNREPAYMENTAMOUNT'))
ALTER TABLE T_ER_DAILYLOANBILL ADD (FUNREPAYMENTAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMBILL' AND KSQL_COL_NAME IN ('FUNREPAYMENTAMOUNT'))
ALTER TABLE T_ER_PUBREIMBILL ADD (FUNREPAYMENTAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );



IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PREPAYBILL' AND KSQL_COL_NAME IN ('FBILLPAYERAMOUNT'))
ALTER TABLE T_ER_PREPAYBILL ADD (FBILLPAYERAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );


IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PUBREIMBILL'  AND KSQL_COL_NAME IN ('FBILLPAYERAMOUNT'))
ALTER TABLE T_ER_PUBREIMBILL ADD (FBILLPAYERAMOUNT DECIMAL(23,10) DEFAULT 0 NOT NULL );
