/*金蝶4月1日及以后的机票结算单历史数据升级 wenyue_chi begain*/

--  机票订单以及订单总表 是否可抵扣字段为是
update t_er_planebill  set FISDEDUCTIBLE=1 where ftakeoffTime >{ts'2019-03-31 23:59:59'};
update t_er_allorderbill  set FISDEDUCTIBLE=1 where FORDERFORMID='er_planebill' and fordernum in (select fordernum from t_er_planebill  where ftakeoffTime >{ts'2019-03-31 23:59:59'});

--  机票结算单 是否可抵扣字段为是
update t_er_planecheckingbill  set FISDEDUCTIBLE=1 where ftakeoffTime >{ts'2019-03-31 23:59:59'};
--  结算单总表 是否可抵扣字段为是
update T_ER_ALLCHECKINGBILL a set FISDEDUCTIBLE=1 where FCHECKINGFORMID='er_planecheckingbill' and fordernum in (select fordernum from t_er_planecheckingbill  where ftakeoffTime >{ts'2019-03-31 23:59:59'});

/* end*/