/**Begin D:\PDM_UPGRADE\PDM1\IFM_table.sql **/

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_INTBILL_BATCH_INT' AND KSQL_COL_NAME IN ('FLOANCURRENCYID')) 
 ALTER TABLE T_IFM_INTBILL_BATCH_INT ADD (FLOANCURRENCYID BIGINT DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_INTBILL_BATCH_INT' AND KSQL_COL_NAME IN ('FCONVERTINTAMT')) 
 ALTER TABLE T_IFM_INTBILL_BATCH_INT ADD (FCONVERTINTAMT DECIMAL(23,10) DEFAULT 0 NOT NULL );
 
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_INTBILL_BATCH_INT' AND KSQL_COL_NAME IN ('FCONVERTRATE')) 
 ALTER TABLE T_IFM_INTBILL_BATCH_INT ADD (FCONVERTRATE DECIMAL(23,10) DEFAULT 1 NOT NULL );
 
/**End D:\PDM_UPGRADE\PDM1\IFM_table.sql **/
