/** 费用、差旅报销单 连号信息 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoiceinfo' AND KSQL_COL_NAME ='FSEQUENCENUMINFO')
ALTER TABLE t_er_invoiceinfo
    ADD (FSEQUENCENUMINFO NVARCHAR(255) DEFAULT ' ' NOT NULL);

/** 对公报销单 连号信息 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_pubreiminvoiceinfo' AND KSQL_COL_NAME ='FSEQUENCENUMINFO')
ALTER TABLE t_er_pubreiminvoiceinfo
    ADD (FSEQUENCENUMINFO NVARCHAR(255) DEFAULT ' ' NOT NULL);

/** 商旅付款申请单 连号信息 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoiceinfocp' AND KSQL_COL_NAME ='FSEQUENCENUMINFO')
ALTER TABLE t_er_invoiceinfocp
    ADD (FSEQUENCENUMINFO NVARCHAR(255) DEFAULT ' ' NOT NULL);

/** 商旅付款申请单 是否连号 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoiceinfocp' AND KSQL_COL_NAME ='FSEQUENCENUM')
ALTER TABLE t_er_invoiceinfocp
    ADD (FSEQUENCENUM VARCHAR(30) DEFAULT ' ' NOT NULL);

/** 记费用/差旅 连号信息 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoicepoolinfo' AND KSQL_COL_NAME ='FSEQUENCENUMINFO')
ALTER TABLE t_er_invoicepoolinfo
    ADD (FSEQUENCENUMINFO NVARCHAR(255) DEFAULT ' ' NOT NULL);