30 lines
1.5 KiB
MySQL
30 lines
1.5 KiB
MySQL
|
-- 刷还款日
|
||
|
|
update fac_loan_duebill a,rec_bdfile_loan_his b set a.rpy_day = b.repay_day where a.duebill_no = b.loan_id and b.data_date = '2022-04-24';
|
||
|
|
update pay_credit_app a,rec_bdfile_loan_his b set a.rpy_day = b.repay_day where a.duebill_no = b.loan_id and b.data_date = '2022-04-24';
|
||
|
|
update ctr_loan_cont a, pay_credit_app b set a.rpy_day = b.rpy_day where a.cont_no = b.cont_no and b.prd_code = 'RXX110001' and b.create_date = '2022-04-24';
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- 刷合同编号
|
||
|
|
update `rec_loan`.`fac_loan_repay_plan` set cont_no= '6417466525623861532' where cont_no = 'NWLSLC20220424616334375021318144';
|
||
|
|
|
||
|
|
update `rec_loan`.`fac_loan_duebill` set cont_no = '6417466525623861532' where cont_no = 'NWLSLC20220424616334375021318144';
|
||
|
|
|
||
|
|
update `rec_loan`.`fac_loan_duebill` set cont_no = '6417492913903000694' where cont_no = 'NWLSLC20220425616644579998830592';
|
||
|
|
|
||
|
|
update `rec_loan`.`pay_payout_app` set cont_no = '6417466525623861532' where cont_no = 'NWLSLC20220424616334375021318144';
|
||
|
|
|
||
|
|
update `rec_loan`.`pay_payout_app` set cont_no = '6417492913903000694' where cont_no = 'NWLSLC20220425616644579998830592';
|
||
|
|
|
||
|
|
update `rec_loan`.`biz_cus_acct` set cont_no = '6417466525623861532' where cont_no = 'NWLSLC20220424616334375021318144';
|
||
|
|
|
||
|
|
update `rec_loan`.`biz_cus_acct` set cont_no = '6417492913903000694' where cont_no = 'NWLSLC20220425616644579998830592';
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- 刷利率方式
|
||
|
|
update pay_credit_app set rate_type = '0' where prd_code = 'RXX110001';
|
||
|
|
update ctr_loan_cont set rate_type = '0' where prd_code = 'RXX110001';
|
||
|
|
update fac_loan_duebill set rate_type = '0' where prd_code = 'RXX110001';
|