31 lines
1.6 KiB
MySQL
31 lines
1.6 KiB
MySQL
|
-- 刷还款日
|
||
|
|
update fac_loan_duebill a,fac_loan_duebill_20220426_tmp b set a.rpy_day = b.rpy_day where a.id = b.id;
|
||
|
|
update pay_credit_app a,pay_credit_app_20220426_tmp b set a.rpy_day = b.rpy_day where a.id = b.id;
|
||
|
|
update ctr_loan_cont a,ctr_loan_cont_20220426_tmp b set a.rpy_day = b.rpy_day where a.id = b.id;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- 刷合同编号
|
||
|
|
update fac_loan_repay_plan set cont_no = 'NWLSLC20220424616334375021318144' where id in (select id from fac_loan_repay_plan_20220426_tmp);
|
||
|
|
|
||
|
|
update fac_loan_duebill set cont_no = 'NWLSLC20220424616334375021318144' where id in (select id from fac_loan_duebill_20220426_tmp1);
|
||
|
|
|
||
|
|
update fac_loan_duebill set cont_no = 'NWLSLC20220425616644579998830592' where id in (select id from fac_loan_duebill_20220426_tmp2);
|
||
|
|
|
||
|
|
update pay_payout_app set cont_no = 'NWLSLC20220424616334375021318144' where id in (select id from pay_payout_app_20220426_tmp1);
|
||
|
|
|
||
|
|
update pay_payout_app set cont_no = 'NWLSLC20220425616644579998830592' where id in (select id from pay_payout_app_20220426_tmp2);
|
||
|
|
|
||
|
|
update biz_cus_acct set cont_no = 'NWLSLC20220424616334375021318144' where id in (select id from biz_cus_acct_20220426_tmp1);
|
||
|
|
|
||
|
|
update biz_cus_acct set cont_no = 'NWLSLC20220425616644579998830592' where id in (select id from biz_cus_acct_20220426_tmp2);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- 刷利率方式
|
||
|
|
update pay_credit_app a,pay_credit_app_20220426_tmp3 b set a.rate_type = b.rate_type where a.id = b.id;
|
||
|
|
update ctr_loan_cont a,ctr_loan_cont_20220426_tmp3 b set a.rate_type = b.rate_type where a.id = b.id;
|
||
|
|
update fac_loan_duebill a,fac_loan_duebill_20220426_tmp3 b set a.rate_type = b.rate_type where a.id = b.id;
|