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

--  酒店订单以及订单总表 是否可抵扣字段为是
update t_er_hotelbill  set FISDEDUCTIBLE=1 ;
update t_er_allorderbill  set FISDEDUCTIBLE=1 where FORDERFORMID='er_hotelbill' and fordernum in (select fordernum from t_er_hotelbill );

--  酒店结算单 是否可抵扣字段为是
update t_er_hotelcheckingbill  set FISDEDUCTIBLE=1;
--  结算单总表 是否可抵扣字段为是
update T_ER_ALLCHECKINGBILL a set FISDEDUCTIBLE=1 where FCHECKINGFORMID='er_hotelcheckingbill' and fordernum in (select fordernum from t_er_hotelcheckingbill );

/* end*/