/**增加可抵扣条件字段**/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FISEINVOICE')
ALTER TABLE T_ER_INVOICETYPE ADD (FISEINVOICE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FISTRANSPORTINVOICE')
ALTER TABLE T_ER_INVOICETYPE ADD (FISTRANSPORTINVOICE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FISVATINVOICE')
ALTER TABLE T_ER_INVOICETYPE ADD (FISVATINVOICE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FISSPECIALINVOICE')
ALTER TABLE T_ER_INVOICETYPE ADD (FISSPECIALINVOICE CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FISOFFSET')
ALTER TABLE T_ER_INVOICETYPE ADD (FISOFFSET CHAR(1) DEFAULT '0' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FUDRDISPLAY')
ALTER TABLE T_ER_INVOICETYPE ADD (FUDRDISPLAY VARCHAR(2000) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FUSERDEFINERULE')
ALTER TABLE T_ER_INVOICETYPE ADD (FUSERDEFINERULE VARCHAR(2000) DEFAULT ' ' NOT NULL);
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICETYPE' AND KSQL_COL_NAME ='FJS')
ALTER TABLE T_ER_INVOICETYPE ADD (FJS VARCHAR(2000) DEFAULT ' ' NOT NULL);
