-- 清理单分录业务日期如果为空，赋值为清理单的记账日期
UPDATE T_FA_CLRBILLENTRY_D c SET fbizdate = (SELECT t.FCLEARDATE from T_FA_CLRBILL t where t.fid = c.fid) where fbizdate is null;
-- 清理单新增资产数量赋值默认值为对应实物卡片的数量
update T_FA_CLRBILLENTRY_D d set fassetqty = (select fassetqty from t_fa_card_real t where t.fid = d.FREALCARDID and fassetqty is not null) where exists (select 1 from t_fa_card_real r where r.fid=d.frealcardid);