123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368 |
- #应用参数
- #阿里短信模板
- 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_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_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','供应商原结算账户','03','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);
|