
INSERT INTO REC_LOAN_LAST.bth_job_pre_rel (id,job_info,pre_job) VALUES
(1,'rec_xwbank_acctflow_tmp','rec_xwbank_loandetail_tmp'),
(2,'rec_xwbank_repay_plan_tmp','rec_xwbank_loandetail_tmp'),
(3,'rec_xwbank_specialbusiness_tmp','rec_xwbank_repay_plan_tmp'),
(4,'rec_xwbank_repay_tmp','rec_xwbank_specialbusiness_tmp'),
(5,'rec_xwbank_rev_trans_tmp','rec_xwbank_repay_tmp'),
(6,'AccrualInfo','rec_xwbank_rev_trans_tmp'),
(7,'LoanDubillInfo','rec_xwbank_rev_trans_tmp'),
(8,'RepayPlan','rec_xwbank_rev_trans_tmp'),
(9,'LoanInfo','rec_xwbank_rev_trans_tmp'),
(10,'LoanStsChg','rec_xwbank_rev_trans_tmp'),
(11,'RepayInfo','rec_xwbank_rev_trans_tmp'),
(12,'ReversalInfo','rec_xwbank_rev_trans_tmp'),
(13,'xwUploadCoreFinishService','AccrualInfo'),
(14,'xwUploadCoreFinishService','LoanDubillInfo'),
(15,'xwUploadCoreFinishService','RepayPlan'),
(16,'xwUploadCoreFinishService','LoanInfo'),
(17,'xwUploadCoreFinishService','LoanStsChg'),
(18,'xwUploadCoreFinishService','RepayInfo'),
(19,'xwUploadCoreFinishService','ReversalInfo'),


(20,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_acct_tmp'),
(21,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_acctflow_tmp'),
(22,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_attach_com_tmp'),
(23,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_bfjflow_tmp'),
(24,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_bfjsum_tmp'),
(25,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_loandetail_tmp'),
(26,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_buis_info_tmp'),
(27,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_car_info_tmp'),
(28,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_coborrower_tmp'),
(29,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_contract_rel_tmp'),
(32,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_enterpriseinfo_tmp'),
(33,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_fee_detail_tmp'),
(34,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_fee_rel_tmp'),
(35,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_fee_stmt_tmp'),
(36,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_file_num_tmp'),
(37,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_houseinfo_tmp'),
(38,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_intr_trans_tmp'),
(39,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_lhd22_tmp'),
(40,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_lhd23_tmp'),
(41,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_loandetail_tmp'),
(42,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_repay_plan_tmp'),
(43,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_repay_tmp'),
(44,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_rev_trans_tmp'),
(45,'rec_xwbank_loandetail_tmp','readerXwFileInputTableTasklet-rec_xwbank_specialbusiness_tmp'),

(46,'rec_xwbank_cus_info_tmp  ','rec_xwbank_loandetail_tmp'),
(47,'rec_xwbank_acct_tmp  ','rec_xwbank_loandetail_tmp');

  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412001','5','随借随还','5',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAYMENT_METHOD' ;

  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412002','6','利随本清','6',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAYMENT_METHOD' ;

   INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412003','7','按月付息，按年还本','7',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAYMENT_METHOD' ;

   INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412004','8','等额本金（按日计息）','8',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAYMENT_METHOD' ;


  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412005','7','非应计','7',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;

  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412006','8','提前结清','8',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;

   INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412007','9','理赔结清','9',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;

   INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412008','17','正常终止','10',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;

    INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412009','47','逾期终止','11',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;


    INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230412010','12','已撤销','12',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;

    INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230530011','10','回购','10',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'BIZ_LOAN_ACC_STS' ;


 INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230413011','7','已取消、已失效','7',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAY_PLAN_STS' ;


  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230413012','8','已抛帐','8',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAY_PLAN_STS' ;


  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230529013','10','已回购结清','10',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAY_PLAN_STS' ;


  INSERT INTO REC_LOAN_LAST.sys_option (id,"option_val","option_txt","option_ord","select_id","create_user","create_org","create_date","create_time")
  SELECT  '20230529014','11','已代偿结清','11',id,'admin','admin' ,'2023-04-12','2023-04-12 14:12:12' FROM "sys_select" WHERE select_key = 'REPAY_PLAN_STS' ;


