例: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 (‘随便一个当天对账的缴款码就行’, ‘’, ‘’))