故障现象:连锁版总部出现付款单里包含重复单据,同一张单据号出现两次,三次及以上

解决办法:总部数据库执行语句
delete f
from ac_payrec_flow f
inner join (select voucher_no, min_no=min(flow_id)
from ac_payrec_flow
group by voucher_no, sheet_amt, paid_amt
having count(1) > 1) b on b.voucher_no=f.voucher_no and b.min_no<>f.flow_id