-- 是否需要影像扫描
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FNEEDIMAGESCAN')
 ALTER TABLE T_ER_DAILYLOANBILL ADD (FNEEDIMAGESCAN CHAR(1) DEFAULT '0' NOT NULL );

-- 是否启用发票云
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FISENABLEINVOICE')
ALTER TABLE T_ER_DAILYLOANBILL ADD (FISENABLEINVOICE CHAR(1) DEFAULT '0' NOT NULL );

-- 是否与发票云交互
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_DAILYLOANBILL' AND KSQL_COL_NAME ='FINVOKEINVOICECLOUD')
ALTER TABLE T_ER_DAILYLOANBILL ADD (FINVOKEINVOICECLOUD CHAR(1) DEFAULT '0' NOT NULL );


