--没有核销过，核销记录的未核销金额不等于原币金额
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';
