IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_OMINBILL' AND KSQL_COL_NAME ='FINVOICEBIZTYPEID') 
ALTER TABLE T_IM_MDC_OMINBILL ADD (FINVOICEBIZTYPEID BIGINT DEFAULT 0 NOT NULL );

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

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

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

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IM_MDC_OMINBILLENTRY_F' AND KSQL_COL_NAME ='FTAXPAYERTYPE') 
ALTER TABLE T_IM_MDC_OMINBILLENTRY_F ADD (FTAXPAYERTYPE CHAR(1) DEFAULT ' ' NOT NULL );