update t_ifm_transhandle t set fsourcebilltype = 'ifm_payacceptancebill' where  t.fsourcebillid >0 and (t.fsourcebilltype=' ' or t.fsourcebilltype is null or t.fsourcebilltype='')
and exists (select b.fid from t_ifm_payacceptance as  b where b.fid= t.fsourcebillid);
update t_ifm_transhandle t set fsourcebilltype = 'ifm_interestbill' where  t.fsourcebillid >0 and (t.fsourcebilltype=' ' or t.fsourcebilltype is null or t.fsourcebilltype='')
and exists (select b.fid from t_cfm_interestbill as  b where b.fid= t.fsourcebillid);
update t_ifm_transhandle t set fsourcebilltype = 'ifm_repaymentbill' where  t.fsourcebillid >0 and (t.fsourcebilltype=' ' or t.fsourcebilltype is null or t.fsourcebilltype='')
and exists (select b.fid from t_cfm_repaymentbill as  b where b.fid= t.fsourcebillid);
update t_ifm_rectransbill t set fsourcebilltype = 'ifm_loanbill'  where t.fsourcebillid >0 and (t.fsourcebilltype=' ' or t.fsourcebilltype is null or t.fsourcebilltype='')
and exists (select b.fid from t_cfm_loanbill  b where b.fid= t.fsourcebillid);
update t_ifm_rectransbill t set fsourcebilltype = 'ifm_currentintbill'  where t.fsourcebillid >0 and (t.fsourcebilltype=' ' or t.fsourcebilltype is null or t.fsourcebilltype='')
and exists (select b.fid from t_ifm_currentintbill  b where b.fid= t.fsourcebillid);