-- 差旅报销单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ReimburseBill' AND KSQL_COL_NAME ='finvokeinvoicecloud')
ALTER TABLE T_ER_ReimburseBill ADD (finvokeinvoicecloud CHAR(1) DEFAULT '0' NOT NULL);
-- 费用报销单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_dailyreimbursebill' AND KSQL_COL_NAME ='finvokeinvoicecloud')
ALTER TABLE t_er_dailyreimbursebill ADD (finvokeinvoicecloud CHAR(1) DEFAULT '0' NOT NULL);
-- 对公报销单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_pubreimbill' AND KSQL_COL_NAME ='finvokeinvoicecloud')
ALTER TABLE t_er_pubreimbill ADD (finvokeinvoicecloud CHAR(1) DEFAULT '0' NOT NULL);
-- 商旅付款申请单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_checkingpay' AND KSQL_COL_NAME ='finvokeinvoicecloud')
ALTER TABLE t_er_checkingpay ADD (finvokeinvoicecloud CHAR(1) DEFAULT '0' NOT NULL);