IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_PAYACCEPTANCE_E' AND KSQL_COL_NAME IN ('FFEEPAYER'))
 ALTER TABLE T_IFM_PAYACCEPTANCE_E ADD (FFEEPAYER NVARCHAR(30) DEFAULT '01' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_PAYACCEPTANCE_E' AND KSQL_COL_NAME IN ('FFEEACTBANKID'))
 ALTER TABLE T_IFM_PAYACCEPTANCE_E ADD (FFEEACTBANKID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_PAYACCEPTANCE_E' AND KSQL_COL_NAME IN ('FFEECURRENCYID'))
 ALTER TABLE T_IFM_PAYACCEPTANCE_E ADD (FFEECURRENCYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_PAYACCEPTANCE_E' AND KSQL_COL_NAME IN ('FSINGLESTREAM'))
 ALTER TABLE T_IFM_PAYACCEPTANCE_E ADD (FSINGLESTREAM CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_PAYACCEPTANCE_E' AND KSQL_COL_NAME IN ('FFEE'))
 ALTER TABLE T_IFM_PAYACCEPTANCE_E ADD (FFEE DECIMAL(23,10) DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_TRANSHANDLE_E' AND KSQL_COL_NAME IN ('FFEEPAYER'))
 ALTER TABLE T_IFM_TRANSHANDLE_E ADD (FFEEPAYER NVARCHAR(30) DEFAULT '01' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_TRANSHANDLE_E' AND KSQL_COL_NAME IN ('FFEEACTBANKID'))
 ALTER TABLE T_IFM_TRANSHANDLE_E ADD (FFEEACTBANKID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_TRANSHANDLE_E' AND KSQL_COL_NAME IN ('FFEECURRENCYID'))
 ALTER TABLE T_IFM_TRANSHANDLE_E ADD (FFEECURRENCYID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_TRANSHANDLE_E' AND KSQL_COL_NAME IN ('FSINGLESTREAM'))
 ALTER TABLE T_IFM_TRANSHANDLE_E ADD (FSINGLESTREAM CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_TRANSHANDLE_E' AND KSQL_COL_NAME IN ('FFEE'))
 ALTER TABLE T_IFM_TRANSHANDLE_E ADD (FFEE DECIMAL(23,10) DEFAULT 0 NOT NULL );