Home Explore Help
Sign In
SupplyChain
/
doc
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: b7dddffbec
Branches Tags
doc
/
DB
/
data
/
date_sys_dict.sql

date_sys_dict.sql 52 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350 
  1. #应用参数
    2. 

  2. 

  3. #阿里短信模板
    4. 

  4. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('阿里短信模板','aliyun_message_code','0', '阿里短信模板');
    5. 

  5. 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_222871777','aliyun_message_code',NULL,NULL,'N','0', '阿里短信模板');
    6. 

  6. 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', '阿里短信模板');
    7. 

  7. 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', '阿里短信模板');
    8. 

  8. 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', '阿里短信模板');
    9. 

  9. 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', '阿里短信模板');
    10. 

  10. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('7','zhucechenggong','SMS_123','aliyun_message_code',NULL,NULL,'N','0','阿里短信模板');
    11. 

  11. 

  12. #文件ftp配置
    13. 

  13. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('文件ftp配置','pub_doc_config','0', '文件ftp配置');
    14. 

  14. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('0','http://huyi.img.minpay.cc/','00','pub_doc_config',NULL,NULL,'N','0', '域名');
    15. 

  15. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','keao','01','pub_doc_config',NULL,NULL,'N','0', 'ftp用户名');
    16. 

  16. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('2','keao','02','pub_doc_config',NULL,NULL,'N','0', 'ftp密码');
    17. 

  17. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('3','123.138.111.28','03','pub_doc_config',NULL,NULL,'N','0', 'ip');
    18. 

  18. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('4','21','04','pub_doc_config',NULL,NULL,'N','0', '端口');
    19. 

  19. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('5','/file/huyi/','05','pub_doc_config',NULL,NULL,'N','0', '文件路径');
    20. 

  20. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('6','http://192.168.0.127:80/','06','pub_doc_config',NULL,NULL,'N','0', '端口');
    21. 

  21. 

  22. #机构性质
    23. 

  23. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('机构性质','ser_scy_organization','0', '机构性质');
    24. 

  24. 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);
    25. 

  25. 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);
    26. 

  26. 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);
    27. 

  27. 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);
    28. 

  28. 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);
    29. 

  29. 

  30. #企业规模
    31. 

  31. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('企业规模','ser_scy_scale','0', '企业规模');
    32. 

  32. 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);
    33. 

  33. 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);
    34. 

  34. 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);
    35. 

  35. 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);
    36. 

  36. 

  37. #企业状态
    38. 

  38. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('企业状态','ser_scy_status','0', '企业状态');
    39. 

  39. 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);
    40. 

  40. 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);
    41. 

  41. 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);
    42. 

  42. 

  43. #企业类型
    44. 

  44. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('企业类型','ser_scy_type','0', '企业类型');
    45. 

  45. 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);
    46. 

  46. 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);
    47. 

  47. 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);
    48. 

  48. 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);
    49. 

  49. 

  50. #费用发票状态
    51. 

  51. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('费用发票状态','ser_zci_invoice_status','0', '费用发票状态');
    52. 

  52. 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);
    53. 

  53. 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);
    54. 

  54. 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);
    55. 

  55. 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);
    56. 

  56. 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);
    57. 

  57. 

  58. #费用状态
    59. 

  59. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('费用状态','ser_zci_status','0', '费用状态');
    60. 

  60. 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);
    61. 

  61. 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);
    62. 

  62. 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);
    63. 

  63. 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);
    64. 

  64. 

  65. #融资状态
    66. 

  66. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资状态','ser_zfr_status','0', '融资状态');
    67. 

  67. 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);
    68. 

  68. 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);
    69. 

  69. 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);
    70. 

  70. 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);
    71. 

  71. 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);
    72. 

  72. 

  73. #合作协议签署
    74. 

  74. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('合作协议签署','sys_agreement_type','0', '合作协议签署');
    75. 

  75. 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);
    76. 

  76. 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);
    77. 

  77. 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);
    78. 

  78. 

  79. #系统开关
    80. 

  80. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('系统开关','sys_normal_disable','0', '系统开关');
    81. 

  81. 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);
    82. 

  82. insert into `sys_dict_data` (`dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `remark`) values('1','停用','1','sys_normal_disable',NULL,NULL,'N','0', NULL);
    83. 

  83. 

  84. #链属公司信息状态
    85. 

  85. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('链属公司信息状态','sys_scp_status','0', '链属公司信息状态');
    86. 

  86. 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);
    87. 

  87. 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);
    88. 

  88. 

  89. #链属状态
    90. 

  90. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('链属状态','sys_scr_status','0', '链属状态');
    91. 

  91. 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);
    92. 

  92. 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);
    93. 

  93. 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);
    94. 

  94. 

  95. #链属关系
    96. 

  96. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('链属关系','sys_scr_type','0', '链属关系');
    97. 

  97. 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);
    98. 

  98. 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);
    99. 

  99. 

  100. #链属关系
    101. 

  101. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('菜单状态','sys_show_hide','0', '菜单状态');
    102. 

  102. 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);
    103. 

  103. 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);
    104. 

  104. 

  105. #资金方类型
    106. 

  106. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('资金方类型','sys_smi_type','0', '资金方类型');
    107. 

  107. 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);
    108. 

  108. 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);
    109. 

  109. 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);
    110. 

  110. 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);
    111. 

  111. 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);
    112. 

  112. 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);
    113. 

  113. 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);
    114. 

  114. 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);
    115. 

  115. 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);
    116. 

  116. 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);
    117. 

  117. 

  118. #代办类型
    119. 

  119. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('代办类型','sys_work_type','0', '代办类型');
    120. 

  120. 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);
    121. 

  121. 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);
    122. 

  122. 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);
    123. 

  123. 

  124. #系统是否
    125. 

  125. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('系统是否','sys_yes_no','0', '系统是否');
    126. 

  126. 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);
    127. 

  127. 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);
    128. 

  128. 

  129. #账款状态
    130. 

  130. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('账款状态','zc_bill_status','0', '账款状态');
    131. 

  131. 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);
    132. 

  132. 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);
    133. 

  133. 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);
    134. 

  134. 

  135. #账款类型
    136. 

  136. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('账款类型','zc_bill_type','0', '账款类型');
    137. 

  137. 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);
    138. 

  138. 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);
    139. 

  139. 

  140. #融信状态
    141. 

  141. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融信状态','zc_finance_state','0', '融信状态');
    142. 

  142. 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);
    143. 

  143. 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);
    144. 

  144. 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);
    145. 

  145. 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);
    146. 

  146. 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);
    147. 

  147. 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);
    148. 

  148. 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);
    149. 

  149. 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', '跑批失效');
    150. 

  150. 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);
    151. 

  151. #发票验真结果
    152. 

  152. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('发票验真结果','zc_invoice_checkStt','0', '发票验真结果');
    153. 

  153. 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);
    154. 

  154. 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);
    155. 

  155. 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);
    156. 

  156. 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);
    157. 

  157. 

  158. #发票类型
    159. 

  159. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('发票类型','zc_invoice_type','0', '发票类型');
    160. 

  160. 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);
    161. 

  161. 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);
    162. 

  162. 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);
    163. 

  163. 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);
    164. 

  164. 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);
    165. 

  165. 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);
    166. 

  166. 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);
    167. 

  167. 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);
    168. 

  168. 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);
    169. 

  169. 

  170. #待还款日期查询
    171. 

  171. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('待还款日期查询','zc_repanyment_day','0', '待还款日期查询');
    172. 

  172. 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);
    173. 

  173. 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);
    174. 

  174. 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);
    175. 

  175. 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);
    176. 

  176. 

  177. #签署节点
    178. 

  178. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('签署节点','zc_zfc_node','0', '签署节点');
    179. 

  179. 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);
    180. 

  180. 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);
    181. 

  181. 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);
    182. 

  182. 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);
    183. 

  183. 

  184. #合同模板状态
    185. 

  185. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('合同模板状态','zc_zfc_status','0', '合同模板状态');
    186. 

  186. 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);
    187. 

  187. 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);
    188. 

  188. 

  189. #合同类型
    190. 

  190. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('合同类型','zc_zfc_type','0', '合同类型');
    191. 

  191. 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);
    192. 

  192. 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);
    193. 

  193. 

  194. #记账簿托管方式
    195. 

  195. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('记账簿托管方式','zc_zfpcr_bookkeeping_type','0', '记账簿托管方式');
    196. 

  196. 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);
    197. 

  197. 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);
    198. 

  198. 

  199. #是否收取手续费
    200. 

  200. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('是否收取手续费','zc_zfpcr_charge','0', '是否收取手续费');
    201. 

  201. 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);
    202. 

  202. 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);
    203. 

  203. 

  204. #授信有效期
    205. 

  205. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('授信有效期','zc_zfpcr_date_type','0', '授信有效期');
    206. 

  206. 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);
    207. 

  207. 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);
    208. 

  208. 

  209. #融资放款方式
    210. 

  210. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资放款方式','zc_zfpcr_loan_type','0', '融资放款方式');
    211. 

  211. 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);
    212. 

  212. 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);
    213. 

  213. 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);
    214. 

  214. 

  215. #授信状态
    216. 

  216. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('授信状态','zc_zfpcr_status','0', '授信状态');
    217. 

  217. 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);
    218. 

  218. 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);
    219. 

  219. 

  220. #授信类型
    221. 

  221. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('授信类型','zc_zfpcr_type','0', '授信类型');
    222. 

  222. 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);
    223. 

  223. 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);
    224. 

  224. 

  225. #签署意愿类型
    226. 

  226. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('签署意愿类型','zc_zfp_auth_type','0', '签署意愿类型');
    227. 

  227. 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);
    228. 

  228. 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);
    229. 

  229. 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);
    230. 

  230. 

  231. #记账簿托管方式
    232. 

  232. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('记账簿托管方式','zc_zfp_bookkeeping','0', '记账簿托管方式');
    233. 

  233. 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);
    234. 

  234. 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);
    235. 

  235. 

  236. #服务费是否可退
    237. 

  237. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('服务费是否可退','zc_zfp_charge','0', '服务费是否可退');
    238. 

  238. 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);
    239. 

  239. 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);
    240. 

  240. 

  241. #融资到期方式
    242. 

  242. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资到期方式','zc_zfp_expire','0', '融资到期方式');
    243. 

  243. 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);
    244. 

  244. 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);
    245. 

  245. 

  246. #资方返佣方式
    247. 

  247. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('资方返佣方式','zc_zfp_profit_type','0', '资方返佣方式');
    248. 

  248. 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);
    249. 

  249. 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);
    250. 

  250. 

  251. #是否有追索权
    252. 

  252. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('是否有追索权','zc_zfp_recourse','0', '是否有追索权');
    253. 

  253. 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);
    254. 

  254. 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);
    255. 

  255. 

  256. #是否拆分
    257. 

  257. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('是否拆分','zc_zfp_split','0', '是否拆分');
    258. 

  258. 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);
    259. 

  259. 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);
    260. 

  260. 

  261. #产品状态
    262. 

  262. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('产品状态','zc_zfp_status','0', '产品状态');
    263. 

  263. 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);
    264. 

  264. 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);
    265. 

  265. 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);
    266. 

  266. 

  267. #融资产品类型
    268. 

  268. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资产品类型','zc_zfp_type','0', '融资产品类型');
    269. 

  269. 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);
    270. 

  270. 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);
    271. 

  271. 

  272. #电子凭证类型
    273. 

  273. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('电子凭证类型','zc_zfp_voucher_type','0', '电子凭证类型');
    274. 

  274. 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);
    275. 

  275. 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);
    276. 

  276. 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);
    277. 

  277. 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);
    278. 

  278. 

  279. #还款状态
    280. 

  280. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('还款状态','zc_zfr_apply_status','0', '还款状态');
    281. 

  281. 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);
    282. 

  282. 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);
    283. 

  283. 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);
    284. 

  284. 

  285. #融资查询条件
    286. 

  286. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资查询条件','zc_zfr_query','0', '融资查询条件');
    287. 

  287. 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);
    288. 

  288. 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);
    289. 

  289. 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);
    290. 

  290. 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);
    291. 

  291. 

  292. #还款查询字段
    293. 

  293. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('还款查询字段','zc_zfr_type','0', '还款查询字段');
    294. 

  294. 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);
    295. 

  295. 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);
    296. 

  296. 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);
    297. 

  297. 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);
    298. 

  298. 

  299. #融资签收开立
    300. 

  300. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融资签收开立','zc_zfr_types','0', '融资签收开立');
    301. 

  301. 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);
    302. 

  302. 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);
    303. 

  303. 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);
    304. 

  304. 

  305. #融信类型
    306. 

  306. insert into `sys_dict_type` (`dict_name`, `dict_type`, `status`, `remark`) values('融信类型','zfi_create_type','0', '融信类型');
    307. 

  307. 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);
    308. 

  308. 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);
    309. 

  309. 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);
    310. 

  310. 

  311. #融信平台审批状态
    312. 

  312. 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);
    313. 

  313. 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);
    314. 

  314. 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);
    315. 

  315. 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);
    316. 

  316. 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);
    317. 

  317. 

  318. #融信核心审批状态
    319. 

  319. 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);
    320. 

  320. 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);
    321. 

  321. 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);
    322. 

  322. 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);
    323. 

  323. 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);
    324. 

  324. 

  325. #融信融资方审批状态
    326. 

  326. 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);
    327. 

  327. 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);
    328. 

  328. 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);
    329. 

  329. 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);
    330. 

  330. 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);
    331. 

  331. 

  332. 

  333. #四要素审核状态
    334. 

  334. 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);
    335. 

  335. 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);
    336. 

  336. 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);
    337. 

  337. 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);
    338. 

  338. 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);
    339. 

  339. 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);
    340. 

  340. 

  341. #融资内部审批状态
    342. 

  342. 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);
    343. 

  343. 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);
    344. 

  344. 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);
    345. 

  345. 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);
    346. 

  346. 

  347. #供应商授信状态
    348. 

  348. 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);
    349. 

  349. 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);
    350. 

  350. 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);
    351.