/*修改费用报销单、差旅报销单、对公报销单历史数据升级，分摊规则默认部门分摊，分摊方法默认比例分摊*/
UPDATE T_ER_PUBREIMBILL SET fsharerule='orgrule' WHERE fsharerule=' ';
UPDATE T_ER_PUBREIMBILL SET fsharemethod='rate' WHERE fsharemethod=' ';

UPDATE T_ER_REIMBURSEBILL SET fsharerule='orgrule' WHERE fsharerule=' ';
UPDATE T_ER_REIMBURSEBILL SET fsharemethod='rate' WHERE fsharemethod=' ';

UPDATE T_ER_DAILYREIMBURSEBILL_A SET fsharerule='orgrule' WHERE fsharerule=' ';
UPDATE T_ER_DAILYREIMBURSEBILL_A SET fsharemethod='rate' WHERE fsharemethod=' ';

/*修改费用报销单、差旅报销单、对公报销单费用分摊字段初始值为0*/
UPDATE T_ER_PUBREIMBILL SET FISBEFORESHARE='0' WHERE FISBEFORESHARE=' ';

UPDATE T_ER_REIMBURSEBILL SET FISBEFORESHARE='0' WHERE FISBEFORESHARE=' ';

UPDATE T_ER_DAILYREIMBURSEBILL_A SET FISBEFORESHARE='0' WHERE FISBEFORESHARE=' ';