-- 各个结算单添加字段 结算子批次号
-- 火车结算单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_TRAINCHECKINGBILL' AND KSQL_COL_NAME IN ('FSUBBATCHNO'))
ALTER TABLE T_ER_TRAINCHECKINGBILL ADD (FSUBBATCHNO  VARCHAR(100) DEFAULT ' ' NOT NULL );
-- 用车结算单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_VEHICLECHECKINGBILL' AND KSQL_COL_NAME IN ('FSUBBATCHNO'))
ALTER TABLE T_ER_VEHICLECHECKINGBILL ADD (FSUBBATCHNO  VARCHAR(100) DEFAULT ' ' NOT NULL );
-- 酒店结算单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_HOTELCHECKINGBILL' AND KSQL_COL_NAME IN ('FSUBBATCHNO'))
ALTER TABLE T_ER_HOTELCHECKINGBILL ADD (FSUBBATCHNO  VARCHAR(100) DEFAULT ' ' NOT NULL );
-- 机票结算单
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_PLANECHECKINGBILL' AND KSQL_COL_NAME IN ('FSUBBATCHNO'))
ALTER TABLE T_ER_PLANECHECKINGBILL ADD (FSUBBATCHNO  VARCHAR(100) DEFAULT ' ' NOT NULL );

