/* 差旅报销单, 差旅明细二级分录历史数据升级, 来源字段 0:手工添加  1: 发票云 2:orc 3:商旅  **/
/*全部默认手动添加*/
update T_ER_REIMBURSEENTRY set FITEMFROM = '0';
/*有发票号码的单来自, 发票云*/
update T_ER_REIMBURSEENTRY set FITEMFROM = '1' where finvoiceno != ' ' and finvoiceno is not NULL;
/*结算方式是月结的单, 来自商旅*/
update T_ER_REIMBURSEENTRY set FITEMFROM = '3' where FSettlementtype = '2';

/*差旅项目二级分录, 增加发票类型字段, 数据升级如果专票字段打开, 就设置为专票, 否则就设置为空*/
update T_ER_REIMBURSEENTRY set FINVOICETYPEITEM = '0';
/*专票*/
update T_ER_REIMBURSEENTRY set FINVOICETYPEITEM = '4' where FIsVACTax = '1';