-- 更新来源为科目的结息、预提数据
update t_ifm_currentintbill tic set fscorgid = (select faccountorgid from t_ifm_intobject tii 
where tic.fintobjectid = tii.fid) where fscorgid = 0 and fintsource = 'accountview' and exists (select faccountorgid from t_ifm_intobject tii where tic.fintobjectid = tii.fid);

-- 更新银行计息数据
update t_ifm_currentintbill_bank tic set fscorgid = (select faccountorgid from t_ifm_intobject tii 
where tic.fintobjectid = tii.fid) where fscorgid = 0 and exists (select faccountorgid from t_ifm_intobject tii where tic.fintobjectid = tii.fid);