-- 清理单数据升级，分录增加资产编码，以对应按引入模板引入资产编码为空(当前平台不支持该操作插件，以变通处理)
update  t_fa_clrbillentry_d AS A set FASSETNUMBER = (select isnull(fnumber,' ') from t_fa_card_real where A.frealcardid = t_fa_card_real.fid) where exists (select 1 from t_fa_card_real r where r.fid=A.frealcardid);