
/************根据变更原因更新变更单来源方式************/
update  t_fa_changebill set fsourcetype ='2' where fid not in(select fid from t_fa_changebillentry_d where freason like '%移交%' or freason like '%领用%');

update  t_fa_changebill set fsourcetype ='1' where fid in(select fid from t_fa_changebillentry_d where freason like '%移交%' or freason like '%领用%');