/*  历史数据升级(4.1日以后)：如果“可抵扣”为是，则“可抵扣税额”默认等于税额；如果“可抵扣”为是，则“可抵扣税额”默认等于0 wenyue_chi */
update t_er_expensedetail set fdeductibletax=FTaxAmount where fid in (select fid from T_ER_DAILYREIMBURSEBILL where FBizDate>={ts'2019-04-01 00:00:00'}) and foffset =1;
update t_er_expensedetail set fdeductibletax=0 where fid in (select fid from T_ER_DAILYREIMBURSEBILL where FBizDate>={ts'2019-04-01 00:00:00'}) and foffset =0;
update T_ER_REIMBURSEENTRY set fdeductibletax=FTaxAmount WHERE fentryid in (select fentryid from T_ER_REIMBURSETRIPENTRY where fid in (select fid from T_ER_REIMBURSEBILL where FBizDate>={ts'2019-04-01 00:00:00'}) )and foffset =1;
update T_ER_REIMBURSEENTRY set fdeductibletax=0 WHERE fentryid in (select fentryid from T_ER_REIMBURSETRIPENTRY where fid in (select fid from T_ER_REIMBURSEBILL where FBizDate>={ts'2019-04-01 00:00:00'}) )and foffset =0;