--发票信息增加订单号
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_INVOICEINFO' AND KSQL_COL_NAME ='FINVOICEORDERNUM')
ALTER TABLE T_ER_INVOICEINFO ADD (FINVOICEORDERNUM NVARCHAR(500) DEFAULT ' ' NOT NULL );
