#应用参数 #阿里短信模板 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('阿里短信模板','aliyun_message_code','0', '阿里短信模板'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('0','zhuce','SMS_224351973','aliyun_message_code',NULL,NULL,'N','0', '您本次操作的验证码:${code};有效期5分钟。请务转告他人,如非分本人操作,请忽略本短信。'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','chongzhi','SMS_223170174','aliyun_message_code',NULL,NULL,'N','0', '您尾号${account}的账户,于${dateTime}充值${amt}已到账,当前余额${totalAmt},如果您对此次充值有疑问,请联系平台客服:${ptPhone}'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','zhifu','SMS_222871809','aliyun_message_code',NULL,NULL,'N','0', '您尾号${account}的账户,于${dateTime}支付平台手续费${amt},当前余额${totalAmt},如果您对此次支付有疑问,请联系平台客服:${ptPhone}'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','tixian','SMS_223170183','aliyun_message_code',NULL,NULL,'N','0', '您尾号${account}的账户,于${dateTime}平台提现${amt},当前余额${totalAmt},如果您对此次支付有疑问,请联系平台客服:${ptPhone}'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','yaoqing','SMS_222871823','aliyun_message_code',NULL,NULL,'N','0', '您的供应链企业${companyName}诚挚邀请您入驻招采云链供应链金融服务平台; 平台注册地址:manage.zcylian.com(如遇无法打开情况,请在PC端浏览器中登录注册)'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','zhucechenggong','SMS_224341912','aliyun_message_code',NULL,NULL,'N','0','您已成功的注册平台账号,初始默认密码为:${password},请登录后,第一时间修改,已保障账号安全;'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('6','rongxindaoqi','SMS_224347065','aliyun_message_code',NULL,NULL,'N','0','您持有的一笔${amount}(大写:${amountCN})的融信${number}将于${date}失效,请尽快处理;'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('7','huankuantixing','SMS_224347072','aliyun_message_code',NULL,NULL,'N','0','您开立给${companyName}的一笔${amount}(大写:${amountCN})的融信${number},将于${date}还款,请尽快处理'); #文件ftp配置 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('文件ftp配置','pub_doc_config','0', '文件ftp配置'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('0','http://file.keao.tech/','00','pub_doc_config',NULL,NULL,'N','0','',NULL,'admin','2021-09-07 16:46:31','域名'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','zcyl','01','pub_doc_config',NULL,NULL,'N','0','',NULL,'admin','2021-09-07 16:46:46','ftp用户名'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','zcyl','02','pub_doc_config',NULL,NULL,'N','0','',NULL,'admin','2021-09-07 16:46:53','ftp密码'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','47.94.205.3','03','pub_doc_config',NULL,NULL,'N','0','',NULL,'admin','2021-09-07 16:47:00','ip'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('4','21','04','pub_doc_config',NULL,NULL,'N','0','',NULL,'',NULL,'端口'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('5','/home/zcyl/','05','pub_doc_config',NULL,NULL,'N','0','',NULL,'admin','2021-09-07 16:45:50','文件路径'); insert into `sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('6','http://manage.zcylian.com/','06','pub_doc_config',NULL,NULL,'N','0','',NULL,'admin','2021-09-07 16:47:28','端口'); #机构性质 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('机构性质','ser_scy_organization','0', '机构性质'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','内资','00','ser_scy_organization',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','国有','01','ser_scy_organization',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','民营','02','ser_scy_organization',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','股份','03','ser_scy_organization',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','其他','04','ser_scy_organization',NULL,NULL,'N','0', NULL); #企业规模 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('企业规模','ser_scy_scale','0', '企业规模'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','大型','00','ser_scy_scale',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','中型','01','ser_scy_scale',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','小型','02','ser_scy_scale',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','微型','03','ser_scy_scale',NULL,NULL,'N','0', NULL); #企业状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('企业状态','ser_scy_status','0', '企业状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','正常','00','ser_scy_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','已冻结','01','ser_scy_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','认证中','02','ser_scy_status',NULL,NULL,'N','0', NULL); #企业类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('企业类型','ser_scy_type','0', '企业类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','平台','00','ser_scy_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','核心企业','01','ser_scy_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','供应商','02','ser_scy_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','资方','03','ser_scy_type',NULL,NULL,'N','0', NULL); #费用发票状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('费用发票状态','ser_zci_invoice_status','0', '费用发票状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','未开票','0','ser_zci_invoice_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','申请开票','1','ser_zci_invoice_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','已开票','2','ser_zci_invoice_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','已作废','3','ser_zci_invoice_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','已冲红','4','ser_zci_invoice_status',NULL,NULL,'N','0', NULL); #费用状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('费用状态','ser_zci_status','0', '费用状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','待缴费','00','ser_zci_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','缴费中','01','ser_zci_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','已缴费','02','ser_zci_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','已退款','03','ser_zci_status',NULL,NULL,'N','0', NULL); #融资状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资状态','ser_zfr_status','0', '融资状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','融资中','00','ser_zfr_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','已放款','01','ser_zfr_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','融资失败','02','ser_zfr_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','已结算','03','ser_zfr_status',NULL,NULL,'N','0', NULL); INSERT INTO `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) VALUES('4', '合同待签署', '04', 'ser_zfr_status', NULL, NULL, 'N', '0', NULL); #合作协议签署 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('合作协议签署','sys_agreement_type','0', '合作协议签署'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','已签署','00','sys_agreement_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','无需签署','01','sys_agreement_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','未签署','02','sys_agreement_type',NULL,NULL,'N','0', NULL); #系统开关 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('系统开关','sys_normal_disable','0', '系统开关'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','正常','0','sys_normal_disable',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','冻结','2','sys_normal_disable',NULL,NULL,'N','0', NULL); #链属公司信息状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('链属公司信息状态','sys_scp_status','0', '链属公司信息状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','未认证','00','sys_scp_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','已认证','01','sys_scp_status',NULL,NULL,'N','0', NULL); #链属状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('链属状态','sys_scr_status','0', '链属状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','待链属','00','sys_scr_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','正常','01','sys_scr_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','拒绝链属','02','sys_scr_status',NULL,NULL,'N','0', NULL); #链属关系 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('链属关系','sys_scr_type','0', '链属关系'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','上游','00','sys_scr_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','下游','01','sys_scr_type',NULL,NULL,'N','0', NULL); #链属关系 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('菜单状态','sys_show_hide','0', '菜单状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','显示','0','sys_show_hide',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','隐藏','1','sys_show_hide',NULL,NULL,'N','0', NULL); #资金方类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('资金方类型','sys_smi_type','0', '资金方类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','国有银行','00','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','股份制银行','01','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','城商行','02','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','保理机构','03','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','证券公司','04','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('6','信托投资公司','05','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('7','基金管理公司','06','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('8','地方资产交易所','07','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('9','小贷公司','08','sys_smi_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('10','城投公司','09','sys_smi_type',NULL,NULL,'N','0', NULL); #代办类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('代办类型','sys_work_type','0', '代办类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','审批','00','sys_work_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','链属企业申请','01','sys_work_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','融信失效','02','sys_work_type',NULL,NULL,'N','0', NULL); #系统是否 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('系统是否','sys_yes_no','0', '系统是否'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','是','Y','sys_yes_no',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','否','N','sys_yes_no',NULL,NULL,'N','0', NULL); #账款状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('账款状态','zc_bill_status','0', '账款状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','正常','00','zc_bill_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','信息未完善','80','zc_bill_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','已融资','05','zc_bill_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','已质押','01','zc_bill_status',NULL,NULL,'N','0',NULL); #账款类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('账款类型','zc_bill_type','0', '账款类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','应付资产','00','zc_bill_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','应收资产','01','zc_bill_type',NULL,NULL,'N','0', NULL); #融信状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融信状态','zc_finance_state','0', '融信状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','待确权','00','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','待签收','01','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','已生效','02','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','已失效','03','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','融资中','04','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('6','已融资','05','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('7','平台退回','06','zc_finance_state',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('7','已失效','07','zc_finance_state',NULL,NULL,'N','0', '跑批失效'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('8','已失效(还款成功失效)','08','zc_finance_state',NULL,NULL,'N','0',NULL); #发票验真结果 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('发票验真结果','zc_invoice_checkStt','0', '发票验真结果'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','未验证','0','zc_invoice_checkStt',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','验证成功','1','zc_invoice_checkStt',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','验证失败','2','zc_invoice_checkStt',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','重复存在','3','zc_invoice_checkStt',NULL,NULL,'N','0', NULL); #发票类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('发票类型','zc_invoice_type','0', '发票类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','专用发票','special_vat_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','电子专用发票','elec_special_vat_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','普通发票','normal_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','电子普通发票','elec_normal_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','增值税普通发票(卷式)','roll_normal_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('6','通行费电子普票','toll_elec_normal_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('7','货运运输业增值税专用发票','special_freight_transport_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('8','机动车销售发票','motor_vehicle_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('9','二手车销售发票','used_vehicle_invoice','zc_invoice_type',NULL,NULL,'N','0', NULL); #待还款日期查询 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('待还款日期查询','zc_repanyment_day','0', '待还款日期查询'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','7天之内','00','zc_repanyment_day',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','30天之内','01','zc_repanyment_day',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','60天之内','02','zc_repanyment_day',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','90天之内','03','zc_repanyment_day',NULL,NULL,'N','0', NULL); #签署节点 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('签署节点','zc_zfc_node','0', '签署节点'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','融资企业融资签收','00','zc_zfc_node',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','融资企业申请融资','01','zc_zfc_node',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','核心企业融信开立确权','02','zc_zfc_node',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','融资企业开立','03','zc_zfc_node',NULL,NULL,'N','0', NULL); #合同模板状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('合同模板状态','zc_zfc_status','0', '合同模板状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','启用','00','zc_zfc_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','停用','01','zc_zfc_status',NULL,NULL,'N','0', NULL); #合同类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('合同类型','zc_zfc_type','0', '合同类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','框架合同','00','zc_zfc_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','业务合同','01','zc_zfc_type',NULL,NULL,'N','0', NULL); #记账簿托管方式 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('记账簿托管方式','zc_zfpcr_bookkeeping_type','0', '记账簿托管方式'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','资金渠道银行','0','zc_zfpcr_bookkeeping_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','平台默认托管行','1','zc_zfpcr_bookkeeping_type',NULL,NULL,'N','0', NULL); #是否收取手续费 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('是否收取手续费','zc_zfpcr_charge','0', '是否收取手续费'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','不收取','0','zc_zfpcr_charge',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','收取','1','zc_zfpcr_charge',NULL,NULL,'N','0', NULL); #授信有效期 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('授信有效期','zc_zfpcr_date_type','0', '授信有效期'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','长期','0','zc_zfpcr_date_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','定期','1','zc_zfpcr_date_type',NULL,NULL,'N','0', NULL); #融资放款方式 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资放款方式','zc_zfpcr_loan_type','0', '融资放款方式'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','平台电子记账簿','0','zc_zfpcr_loan_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','供应商指定账户','1','zc_zfpcr_loan_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','供应商线下面签','2','zc_zfpcr_loan_type',NULL,NULL,'N','0', NULL); #授信状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('授信状态','zc_zfpcr_status','0', '授信状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','有效','00','zc_zfpcr_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','失效','01','zc_zfpcr_status',NULL,NULL,'N','0', NULL); #授信类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('授信类型','zc_zfpcr_type','0', '授信类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','融资方','0','zc_zfpcr_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','核心方','1','zc_zfpcr_type',NULL,NULL,'N','0', NULL); #签署意愿类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('签署意愿类型','zc_zfp_auth_type','0', '签署意愿类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','全部','00','zc_zfp_auth_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','人脸识别','01','zc_zfp_auth_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','短信','02','zc_zfp_auth_type',NULL,NULL,'N','0', NULL); #记账簿托管方式 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('记账簿托管方式','zc_zfp_bookkeeping','0', '记账簿托管方式'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','供应商指定账户','00','zc_zfp_bookkeeping',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','平台电子对账簿','01','zc_zfp_bookkeeping',NULL,NULL,'N','0', NULL); #服务费是否可退 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('服务费是否可退','zc_zfp_charge','0', '服务费是否可退'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','否','0','zc_zfp_charge',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','是','1','zc_zfp_charge',NULL,NULL,'N','0', NULL); #融资到期方式 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资到期方式','zc_zfp_expire','0', '融资到期方式'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','资方分账结算','00','zc_zfp_expire',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','平台分账结算','01','zc_zfp_expire',NULL,NULL,'N','0', NULL); #资方返佣方式 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('资方返佣方式','zc_zfp_profit_type','0', '资方返佣方式'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','线上','00','zc_zfp_profit_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','线下','01','zc_zfp_profit_type',NULL,NULL,'N','0', NULL); #是否有追索权 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('是否有追索权','zc_zfp_recourse','0', '是否有追索权'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','无追索权','0','zc_zfp_recourse',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','有追索权','1','zc_zfp_recourse',NULL,NULL,'N','0', NULL); #是否拆分 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('是否拆分','zc_zfp_split','0', '是否拆分'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','不可拆分','0','zc_zfp_split',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','可拆分','1','zc_zfp_split',NULL,NULL,'N','0', NULL); #产品状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('产品状态','zc_zfp_status','0', '产品状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','停用','00','zc_zfp_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','启用','01','zc_zfp_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','删除','02','zc_zfp_status',NULL,NULL,'N','0', NULL); #融资产品类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资产品类型','zc_zfp_type','0', '融资产品类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','正向','0','zc_zfp_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','反向','1','zc_zfp_type',NULL,NULL,'N','0', NULL); #电子凭证类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('电子凭证类型','zc_zfp_voucher_type','0', '电子凭证类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','平台融信','00','zc_zfp_voucher_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','资方银信','01','zc_zfp_voucher_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','无电子凭证','02','zc_zfp_voucher_type',NULL,NULL,'N','0', NULL); #还款状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('还款状态','zc_zfr_apply_status','0', '还款状态'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','待还款','00','zc_zfr_apply_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','已还款','01','zc_zfr_apply_status',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','已逾期','02','zc_zfr_apply_status',NULL,NULL,'N','0', NULL); #融资查询条件 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资查询条件','zc_zfr_query','0', '融资查询条件'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','按开立企业名称查询','00','zc_zfr_query',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','按融信编号查询','01','zc_zfr_query',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','按融资编号查询','02','zc_zfr_query',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','按融资状态查询','03','zc_zfr_query',NULL,NULL,'N','0', NULL); #还款查询字段 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('还款查询字段','zc_zfr_type','0', '还款查询字段'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','按资金方名称查询','00','zc_zfr_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','按融资编号查询','01','zc_zfr_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','按融信编号查询','02','zc_zfr_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','按融资方名称查询','03','zc_zfr_type',NULL,NULL,'N','0', NULL); #融资签收开立 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资签收开立','zc_zfr_types','0', '融资签收开立'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','全部','00','zc_zfr_types',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','我签收的','01','zc_zfr_types',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','我开立的','02','zc_zfr_types',NULL,NULL,'N','0', NULL); #融信类型 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融信类型','zfi_create_type','0', '融信类型'); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','供应商申请','0','zfi_create_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','核心开立','1','zfi_create_type',NULL,NULL,'N','0', NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','供应商开立','2','zfi_create_type',NULL,NULL,'N','0', NULL); #融信平台审批状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融信平台审批状态','finance_platform_status','0','admin','2021-09-09 18:03:18','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('0','审批中','00','finance_platform_status',NULL,NULL,'N','0','admin','2021-09-09 18:03:49','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','审批通过','01','finance_platform_status',NULL,NULL,'N','0','admin','2021-09-09 18:04:19','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','审批拒绝','02','finance_platform_status',NULL,NULL,'N','0','admin','2021-09-09 18:04:45','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','暂存','03','finance_platform_status',NULL,NULL,'N','0','admin','2021-09-09 18:05:01','',NULL,NULL); #融信核心审批状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融资核心审批状态','finance_core_status','0','admin','2021-09-09 18:07:11','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('0','审批中','00','finance_core_status',NULL,NULL,'N','0','admin','2021-09-09 18:07:34','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','审批通过','01','finance_core_status',NULL,NULL,'N','0','admin','2021-09-09 18:07:51','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','审批拒绝','02','finance_core_status',NULL,NULL,'N','0','admin','2021-09-09 18:08:11','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','暂存','03','finance_core_status',NULL,NULL,'N','0','admin','2021-09-09 18:08:24','',NULL,NULL); #融信融资方审批状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融信融资方审批状态','finance_supplier_status','0','admin','2021-09-09 18:09:31','admin','2021-09-09 18:09:46',NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('0','审批中','00','finance_supplier_status',NULL,NULL,'N','0','admin','2021-09-09 18:10:00','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','审批通过','01','finance_supplier_status',NULL,NULL,'N','0','admin','2021-09-09 18:10:18','admin','2021-09-09 18:10:59',NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','审批拒绝','02','finance_supplier_status',NULL,NULL,'N','0','admin','2021-09-09 18:10:32','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','审批拒绝','03','finance_supplier_status',NULL,NULL,'N','0','admin','2021-09-09 18:11:20','',NULL,NULL); #四要素审核状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('四要素审核状态','ser_scy_authStatus','0','admin','2021-09-09 21:02:57','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('0','未认证','00','ser_scy_authStatus',NULL,NULL,'N','0','admin','2021-09-09 21:03:21','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','认证通过','01','ser_scy_authStatus',NULL,NULL,'N','0','admin','2021-09-09 21:03:32','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','认证未通过','02','ser_scy_authStatus',NULL,NULL,'N','0','admin','2021-09-09 21:03:42','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','人工审批通过','03','ser_scy_authStatus',NULL,NULL,'N','0','admin','2021-09-09 21:03:57','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('4','人工审批不通过','04','ser_scy_authStatus',NULL,NULL,'N','0','admin','2021-09-09 21:04:33','',NULL,NULL); #融资内部审批状态 insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('293','融资内部审批状态','zc_zfr_approve_stt','0','admin','2021-09-15 10:13:43','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('683','0','审核中','00','zc_zfr_approve_stt',NULL,NULL,'N','0','admin','2021-09-15 10:14:32','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('684','1','审批通过','01','zc_zfr_approve_stt',NULL,NULL,'N','0','admin','2021-09-15 10:14:53','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('685','0','审批拒绝','02','zc_zfr_approve_stt',NULL,NULL,'N','0','admin','2021-09-15 10:15:29','',NULL,NULL); #供应商授信状态 insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('294','供应商授信状态','zc_zfsq_status','0','admin','2021-09-16 16:38:31','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('686','0','有效','00','zc_zfsq_status',NULL,NULL,'N','0','admin','2021-09-16 16:41:39','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('687','1','失效','01','zc_zfsq_status',NULL,NULL,'N','0','admin','2021-09-16 16:41:54','',NULL,NULL); #发票状态搜索栏 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('发票状态搜索栏','ser_invoice_status','0','admin','2021-09-22 17:23:59','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','未开票','0','ser_invoice_status',NULL,NULL,'N','0','admin','2021-09-22 17:24:34','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','已开票','2','ser_invoice_status',NULL,NULL,'N','0','admin','2021-09-22 17:24:53','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','已作废','3','ser_invoice_status',NULL,NULL,'N','0','admin','2021-09-22 17:25:13','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('4','已冲红','4','ser_invoice_status',NULL,NULL,'N','0','admin','2021-09-22 17:25:30','',NULL,NULL); #融资选择查询条件(平台) insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融资选择查询条件(平台)','ser_zfr_query','0','admin','2021-09-24 14:05:34','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','按开立企业名称查询','00','ser_zfr_query',NULL,NULL,'N','0','admin','2021-09-24 14:06:48','admin','2021-09-24 14:07:13',NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','按融信编号查询','01','ser_zfr_query',NULL,NULL,'N','0','admin','2021-09-24 14:07:04','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','按融资编号查询','02','ser_zfr_query',NULL,NULL,'N','0','admin','2021-09-24 14:07:28','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('4','按融资状态查询','03','ser_zfr_query',NULL,NULL,'N','0','admin','2021-09-24 14:07:43','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('5','按接收企业名称查询','04','ser_zfr_query',NULL,NULL,'N','0','admin','2021-09-24 14:07:56','',NULL,NULL); #角色状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('角色状态','role_state','0','admin','2021-09-26 10:36:16','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','正常','0','role_state',NULL,NULL,'N','0','admin','2021-09-26 10:36:37','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','停用','1','role_state',NULL,NULL,'N','0','admin','2021-09-26 10:36:51','',NULL,NULL); #融信查询条件 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('融信查询条件','zc_zfi_query','0','admin','2021-09-27 11:08:48','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('0','按开立方企业查询','00','zc_zfi_query',NULL,NULL,'N','0','admin','2021-09-27 11:11:06','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','按融资方企业查询','01','zc_zfi_query',NULL,NULL,'N','0','admin','2021-09-27 11:11:34','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','按融信编号查询','02','zc_zfi_query',NULL,NULL,'N','0','admin','2021-09-27 11:11:52','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('3','按融信产品管理查询','03','zc_zfi_query',NULL,NULL,'N','0','admin','2021-09-27 11:12:20','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('4','按融信利率查询','04','zc_zfi_query',NULL,NULL,'N','0','admin','2021-09-27 11:12:54','admin','2021-09-27 13:50:36',NULL); #链属确认状态 insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('链属同意或拒绝','ser_rel_state','0','admin','2021-09-27 09:19:31','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('1','确认链属','01','ser_rel_state',NULL,NULL,'N','0','admin','2021-09-27 09:20:00','admin','2021-09-27 09:20:28',NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('2','拒绝链属','02','ser_rel_state',NULL,NULL,'N','0','admin','2021-09-27 09:20:20','',NULL,NULL); insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('299','账户类型','pay_pai_acctype','0','admin','2021-10-13 08:51:10','admin','2021-10-13 08:55:14',NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('720','0','企业实体卡','00','pay_pai_acctype',NULL,NULL,'N','0','admin','2021-10-13 08:52:32','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('721','0','企业实体卡','01','pay_pai_acctype',NULL,NULL,'N','0','admin','2021-10-13 08:52:50','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('722','0','电子记账簿','06','pay_pai_acctype',NULL,NULL,'N','0','admin','2021-10-13 08:53:23','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('723','0','电子记账簿','07','pay_pai_acctype',NULL,NULL,'N','0','admin','2021-10-13 08:53:37','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('724','0','电子记账簿','08','pay_pai_acctype',NULL,NULL,'N','0','admin','2021-10-13 08:53:56','',NULL,NULL); insert into `sys_dict_type` (`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('300','账户状态','pay_pai_status','0','admin','2021-10-13 08:55:03','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('725','0','未开通','0','pay_pai_status',NULL,NULL,'N','0','admin','2021-10-13 08:55:36','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('726','0','冻结','1','pay_pai_status',NULL,NULL,'N','0','admin','2021-10-13 08:55:48','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('727','0','已开通','2','pay_pai_status',NULL,NULL,'N','0','admin','2021-10-13 08:56:08','',NULL,NULL); insert into `sys_dict_data` (`dict_code`, `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('728','0','待激活','3','pay_pai_status',NULL,NULL,'N','0','admin','2021-10-13 08:56:24','',NULL,NULL); #费用状态新增 insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('5','退款中','04','ser_zci_status',NULL,NULL,'N','0','admin','2021-10-18 16:40:29','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('6','缴费失败','05','ser_zci_status',NULL,NULL,'N','0','admin','2021-10-18 16:40:48','',NULL,NULL); insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) values('7','退款失败','06','ser_zci_status',NULL,NULL,'N','0','admin','2021-10-18 16:41:06','',NULL,NULL);