/** 费用、差旅报销单 采集顺序 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoiceinfo' AND KSQL_COL_NAME ='FUPLOADSEQ')
ALTER TABLE t_er_invoiceinfo
    ADD (FUPLOADSEQ bigint DEFAULT 0 NOT NULL);

/** 对公报销单 采集顺序 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_pubreiminvoiceinfo' AND KSQL_COL_NAME ='FUPLOADSEQ')
ALTER TABLE t_er_pubreiminvoiceinfo
    ADD (FUPLOADSEQ bigint DEFAULT 0 NOT NULL);

/** 商旅付款申请单 采集顺序 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoiceinfocp' AND KSQL_COL_NAME ='FUPLOADSEQ')
ALTER TABLE t_er_invoiceinfocp
    ADD (FUPLOADSEQ bigint DEFAULT 0 NOT NULL);

/** 费用池 采集顺序 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 't_er_invoicepoolinfo' AND KSQL_COL_NAME ='FUPLOADSEQ')
ALTER TABLE t_er_invoicepoolinfo
    ADD (FUPLOADSEQ bigint DEFAULT 0 NOT NULL);