IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_bdm_scaninvoice_setting' AND KSQL_COL_NAME ='fqrcodevalidity')
 ALTER TABLE t_bdm_scaninvoice_setting ADD (fqrcodevalidity VARCHAR(50) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_bdm_scaninvoice_setting' AND KSQL_COL_NAME ='fscantype')
 ALTER TABLE t_bdm_scaninvoice_setting ADD (fscantype VARCHAR(4) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_bdm_scaninvoice_setting' AND KSQL_COL_NAME ='fsystemcode')
 ALTER TABLE t_bdm_scaninvoice_setting ADD (fsystemcode VARCHAR(50) DEFAULT ' ' NOT NULL );
