--结算中心扣款扩展表升级
INSERT INTO T_IFM_DEDUCTION_E(FID) SELECT FID FROM T_IFM_DEDUCTION T WHERE NOT EXISTS (SELECT FID FROM T_IFM_DEDUCTION_E E WHERE E.FID=T.FID);
--结算中心扣款-银行扣款-被动付款
UPDATE T_IFM_DEDUCTION_E E SET FPAYMENTIDENTIFYID=1307961752700412928 WHERE EXISTS (SELECT FID FROM T_IFM_DEDUCTION T WHERE FDEDUCTIONTYPE='C' AND T.FID=E.FID);
--结算中心扣款-银行扣款变更为结算中心代付
UPDATE T_IFM_DEDUCTION SET FDEDUCTIONTYPE='E' WHERE FDEDUCTIONTYPE='C';
--付款交易处理-银行扣款>被动付款
UPDATE T_IFM_TRANSHANDLE_E E SET FPAYMENTIDENTIFYID=1307961752700412928 WHERE EXISTS (SELECT FID FROM T_IFM_TRANSHANDLE T WHERE FTRANSTYPE='10' AND T.FID=E.FID);
--付款交易处理-银行扣款>内部代付
UPDATE T_IFM_TRANSHANDLE SET FTRANSTYPE='1' WHERE FTRANSTYPE='10';