/** 对公报销单 发票币种 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_pubreiminvoiceinfo' AND KSQL_COL_NAME ='FINVOICECURRENCYID')
ALTER TABLE t_er_pubreiminvoiceinfo
    ADD (FINVOICECURRENCYID bigint DEFAULT 0 NOT NULL);

/** 商旅付款申请单 发票币种 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoiceinfocp' AND KSQL_COL_NAME ='FINVOICECURRENCYID')
ALTER TABLE t_er_invoiceinfocp
    ADD (FINVOICECURRENCYID bigint DEFAULT 0 NOT NULL);

/** 费用池 发票币种 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoicepoolinfo' AND KSQL_COL_NAME ='FINVOICECURRENCYID')
ALTER TABLE t_er_invoicepoolinfo
    ADD (FINVOICECURRENCYID bigint DEFAULT 0 NOT NULL);