/* 发票日期默认等于单据日期 */
update T_AR_FINARBILL_E a set FINVOICEDATE = (select b.fbizdate from t_ar_finarbill b where b.fid = a.fid) where exists(select 1 from t_ar_finarbill b where a.fid=b.fid and b.FBIZDATE is not null and a.FINVOICEDATE is null);