例:2555报文中包含139笔交易,而财政端银行对账单显示为138笔,经过与执收单位确认,确定交易笔数是139笔,单位端显示都已缴款
对比fpf_pay_receipt和fne_paybook表里的数据,找到fne_paybook表里缺少的缴款码
2555未成功:
select from fpf_pay_receipt t where t.fpaycode=’…’;
——根据缴款码的FID 把FISCOMPLETE手动改为0
select t.,t.rowid from fpf_unconfirm_payinfo t where t.fid=’d87ae58c80814b3894387800087363a6’ ;
——FISCLEAR手动改为0
select t.*,t.rowid from fne_reconcile_pay_notice t where t.fdate=’2017-02-03’ and t.fbankcode=’0001’ and t.fpaychnlcode=’21’;
2557未划拨:
———修改FISQUERIED 是否已查询,手动修改为0
select h.*,h.rowid from fpf_service_batch_notice_log h where h.freferenceno in
(select a.freceivereconcilerefno
from fpf_pay_capital_receive a
where a.fpaycode in (‘随便一个当天对账的缴款码就行’, ‘’, ‘’))
