9 lines
791 B
MySQL
9 lines
791 B
MySQL
|
update prd_base_info set acct_type = 'LH' where prd_code = 'RXX110001';
|
||
|
|
update pay_credit_app set acct_type = 'LH' where prd_code = 'RXX110001' and acct_type = 'ZY';
|
||
|
|
update biz_cus_acct set acct_type = 'LH' where cont_no in (select cont_no from ctr_loan_cont where prd_code = 'RXX110001') and acct_type = 'ZY';
|
||
|
|
update pay_payout_app set acct_type = 'LH' where prd_code = 'RXX110001' and acct_type = 'ZY';
|
||
|
|
update biz_cus_acct set open_org_no = '310290000013',open_org_name = '上海浦东发展银行',mobile_phone = '18508492959' where acct_no = '6217922671530666' and open_org_no is null;
|
||
|
|
delete from fac_loan_duebill where prd_code = 'RXX110001';
|
||
|
|
|
||
|
|
update biz_accounting_record set accounting_stats ='0';
|
||
|
|
delete biz_accounting_detail where id in ('616666160875839488','616667171132678144');
|