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

/*增加发票类型字段, 数据升级如果专票字段打开, 就设置为专票, 否则就设置为空*/
update t_er_expensedetail set FINVOICETYPEITEM = '0';
/*专票*/
update t_er_expensedetail set FINVOICETYPEITEM = '4' where fisspecialinvoice = '1';

/*发票明细, 可抵扣字段默认值是否*/
update T_ER_INVOICEITEM set FINVOICEITEMOFFSET = '0';