-- 全部订单 部门费用清单添加字段
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_ALLORDERBILL' AND KSQL_COL_NAME IN ('FDEPTCONFIRM'))
ALTER TABLE T_ER_ALLORDERBILL ADD (FDEPTCONFIRM varchar(10) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKING_EXP_DETAIL' AND KSQL_COL_NAME IN ('FISCONFIRM'))
ALTER TABLE T_ER_CHECKING_EXP_DETAIL ADD (FISCONFIRM  varchar(10) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_ER_CHECKING_EXP_DETAIL' AND KSQL_COL_NAME IN ('FVEHICLETYPE'))
ALTER TABLE T_ER_CHECKING_EXP_DETAIL ADD (FVEHICLETYPE varchar(100) DEFAULT ' ' NOT NULL  );

