IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYBANKACCOUNTID'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYBANKACCOUNTID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYBANKID'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYBANKID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYEENAME'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYEENAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYEEBANKNUM'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYEEBANKNUM NVARCHAR(80) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYEEBANKNAME'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYEEBANKNAME NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYEEBANKID'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYEEBANKID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FOPENORGID'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FOPENORGID BIGINT DEFAULT 0 NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FBEIBANKCHECKFLAG'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FBEIBANKCHECKFLAG NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FPAYEETYPE'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FPAYEETYPE NVARCHAR(30) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_IFM_DEDUCTION' AND KSQL_COL_NAME IN ('FISVOUCHER'))
 ALTER TABLE T_IFM_DEDUCTION ADD (FISVOUCHER CHAR(1) DEFAULT '0' NOT NULL );
