rcs-sys/loan-parent/db/rec_loan/02-网商贷/003-check_rec_loan_yyyymmdd.sql
2025-03-07 16:23:56 +08:00

144 lines
4.4 KiB
SQL

select sys_name from biz_record_result limit 1;
select * from rec_accounting_tmp;
select * from rec_accounting_his;
select * from biz_accounting;
select * from biz_core_keep;
select * from biz_core_keep_obj_map;
select * from rec_accounting_sub_tmp;
select * from rec_accounting_sub_his;
select * from rec_accounting_sub_check;
select * from rec_lending_detail_tmp;
select * from rec_lending_detail_his;
select * from rec_loan_detail_tmp;
select * from rec_loan_detail_his;
select * from rec_repay_plan_tmp;
select * from rec_repay_plan_his;
select * from fac_loan_repay_plan;
select * from rec_repay_loan_detail_tmp;
select * from rec_repay_loan_detail_his;
select * from rec_repay_instmnt_detail_tmp;
select * from rec_repay_instmnt_detail_his;
select * from pls_repay_plan_detail;
select * from rec_exempt_loan_detail_tmp;
select * from rec_exempt_loan_detail_his;
select * from rec_exempt_instmnt_detail_tmp;
select * from rec_exempt_instmnt_detail_his;
select * from rec_loan_fin_tmp;
select * from rec_loan_fin_his;
select * from rec_instmnt_fin_tmp;
select * from rec_instmnt_fin_his;
select * from rec_ar_status_change_tmp;
select * from rec_ar_status_change_his;
select * from rec_fund_detail_tmp;
select * from rec_fund_detail_his;
select * from rec_loan_int_calc_tmp;
select * from rec_loan_int_calc_his;
select * from rec_charge_detail_tmp;
select * from rec_charge_detail_his;
select * from rec_fund_title_bal_tmp;
select * from rec_fund_title_bal_his;
select * from rec_file_check;
select * from rec_fund_file_check;
select * from rec_supv_contract_tmp;
select * from rec_supv_contract_his;
select * from rec_supv_cust_tmp;
select * from rec_supv_cust_his;
select * from rec_client_info_tmp;
select * from rec_client_info_his;
select * from rec_check_client_info;
select * from rec_credit_detail_his;
select * from rec_credit_detail_check;
select * from biz_return_code_map;
select * from rec_wd_credit_lmt_tmp;
select * from rec_wd_credit_lmt_his;
select * from lmt_ext_used_lmt_his;
select * from lmt_ext_used_biz_rel;
select * from lmt_ext_used_lmt;
select * from rec_credit_detail_tmp;
select * from rec_fund_bal_tmp;
select * from rec_fund_bal_his;
select * from finsih_limit;
select * from finsih_limit_list;
select * from lmt_first_audit;
select * from lmt_last_audit;
select * from bam_image_index;
select * from cus_info;
select * from ob_crd_app_info;
select * from ob_credit_app_info;
select * from ob_final_app_info;
select * from ob_first_app_info;
select * from wsd_loan_detail;
select * from biz_coop_sftp_config;
select * from lmt_change_credit;
select * from cus_file_fail;
select * from cus_file_list;
select * from credit_err;
select retry_times from biz_tran_config limit 1;
select retry_space from biz_tran_config limit 1;
select acct_type from CTR_LMT_CONT limit 1;
select acct_type from CTR_LOAN_CONT limit 1;
select acct_type from CUS_LIST limit 1;
select acct_type from LMT_CRDT_APP limit 1;
select acct_type from LMT_CRDT_LMT limit 1;
select acct_type from LMT_CRDT_RISK limit 1;
select acct_type from PAY_PAYOUT_APP limit 1;
select acct_type from PRD_BASE_INFO limit 1;
select acct_type from LMT_CRDT_AGR limit 1;
select acct_type from PAY_CREDIT_APP limit 1;
select acct_type from FAC_LOAN_DUEBILL limit 1;
select acct_type from BIZ_CUS_ACCT limit 1;
select acct_type from BIZ_CHANNEL limit 1;
select acct_type from GRT_GUAR_CONT limit 1;
select acct_type from BIZ_GRT_CONT_REL limit 1;
select acct_type from GRT_GUARANTEE limit 1;
select acct_type from pls_repay_result limit 1;
select cust_ip_id from lmt_crdt_app limit 1;
select depart from prd_base_info limit 1;
select retry_times from biz_tran_config limit 1;
select retry_space from biz_tran_config limit 1;
select retry from biz_tran_config limit 1;
select wait_end from biz_tran_config limit 1;
select account_id from biz_coop_prd_config limit 1;
select acct_type from lmt_crdt_agr limit 1;
select file_date from lmt_crdt_agr limit 1;
select file_bak from lmt_crdt_agr limit 1;
select acct_type from lmt_crdt_app limit 1;
select ip_addr from lmt_crdt_app limit 1;
select cust_ip_id from lmt_crdt_app limit 1;
select img_no from lmt_crdt_app limit 1;
select file_date from lmt_crdt_app limit 1;
select file_bak from lmt_crdt_app limit 1;
select acct_type from lmt_crdt_lmt limit 1;
select ip_addr from lmt_crdt_lmt limit 1;
select file_date from lmt_crdt_lmt limit 1;
select file_bak from lmt_crdt_lmt limit 1;
select file_date from lmt_cus_addr limit 1;
select file_bak from lmt_cus_addr limit 1;