--没有核销过，核销记录的未核销金额不等于原币金额 drop table his_tmp; SELECT distinct FVOUCHERASSTIDID vsid into his_tmp FROM t_gl_acctcussenthistory where FDC <> 1 and fcompanyid='替换为公司ID'; --需要确保fdc=3的数据是成对的 SELECT * FROM t_gl_acctverify where not exists( select 1 from his_tmp h where h.vsid = FVCHASSISTRECORDID ) and FUNVERIFIEDAMTFOR <> FORIGINALAMOUNT and fcompanyid='替换为公司ID'; update t_gl_acctverify set FUNVERIFIEDAMTFOR = FORIGINALAMOUNT, FUNVERIFIEDQTY = FQUANTITY where not exists( select 1 from his_tmp h where h.vsid = FVCHASSISTRECORDID ) and FUNVERIFIEDAMTFOR <> FORIGINALAMOUNT and fcompanyid='替换为公司ID'; --没有核销过，挂账记录的未核销金额不等于原币金额 drop table his_tmp; SELECT distinct FCUSSENTIDID vsid into his_tmp FROM t_gl_acctcussenthistory where FDC <> 3 and fcompanyid='替换为公司ID'; --需要确保fdc=1的数据是成对的 SELECT * FROM T_GL_ACCTCUSSENT where not exists( select 1 from his_tmp h where h.vsid = fid ) and FUNVERIFIEDAMTFOR <> FORIGINALAMOUNT and fcompanyid='替换为公司ID'; update T_GL_ACCTCUSSENT set FUNVERIFIEDAMTFOR = FORIGINALAMOUNT, FUNVERIFIEDQTY = isnull(FQUANTITY,0) where not exists( select 1 from his_tmp h where h.vsid = fid ) and FUNVERIFIEDAMTFOR <> FORIGINALAMOUNT and fcompanyid='替换为公司ID';