Home Esplora Aiuto
Registrati Accedi
WAREWMS
/
WAREAMS
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 74d0ef7255
Rami (Branch) Tag
WAREAMS
/
base
/
sql
/
bsl_sql
/
bsl_dml_v1.0.0.sql

bsl_dml_v1.0.0.sql 94 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275 
  1. 

  2. /*字典数据类型*/
    3. 

  3. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101, '库位类型', 'location_type', '0', 'admin', '2022-02-18 16:16:51', 'admin', '2022-02-18 16:17:02', NULL);
    4. 

  4. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (102, '库位状态', 'location_status', '0', 'admin', '2022-02-18 16:34:44', 'jwk', '2022-11-16 15:04:04', NULL);
    5. 

  5. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (103, '质量状态', 'ams_inv_quality', '0', 'admin', '2022-03-03 16:33:39', '', NULL, NULL);
    6. 

  6. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (104, '地堆类型', 'floor_type', '0', 'admin', '2022-03-07 14:04:37', '', NULL, NULL);
    7. 

  7. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (105, '事务类型', 'act_transaction_dict', '0', 'admin', '2022-10-11 15:14:52', '', NULL, NULL);
    8. 

  8. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (106, '单据类型', 'doc_type', '0', 'admin', '2022-10-11 15:48:36', '', NULL, NULL);
    9. 

  9. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (107, '入库单类型', 'asn_type', '0', 'admin', '2022-10-11 17:25:45', '', NULL, NULL);
    10. 

  10. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (108, '入库单状态', 'asn_status', '0', 'admin', '2022-10-12 10:17:59', '', NULL, NULL);
    11. 

  11. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (109, '出库单状态', 'so_status', '0', 'admin', '2022-10-18 22:08:12', '', NULL, NULL);
    12. 

  12. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (110, '出库单类型', 'so_type', '0', 'admin', '2022-10-18 22:17:25', 'admin', '2022-10-18 22:21:34', NULL);
    13. 

  13. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (111, '容器类型', 'box_type', '0', 'admin', '2022-11-01 14:28:20', '', NULL, NULL);
    14. 

  14. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (112, '启用状态', 'active_state', '0', 'admin', '2022-11-01 14:31:05', '', NULL, NULL);
    15. 

  15. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (113, '验收单状态', 'qc_status', '0', 'jwk', '2022-11-16 15:02:05', '', NULL, NULL);
    16. 

  16. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (114, 'AGV任务状态', 'task_sts', '0', 'admin', '2023-03-22 09:46:06', 'admin', '2023-03-22 09:48:53', NULL);
    17. 

  17. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (115, '产线目标站', 'pro_line_site', '0', 'admin', '2023-04-11 13:34:20', 'admin', '2023-04-11 15:08:20', NULL);
    18. 

  18. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (116, '破袋机编号', 'bbmId_type', '0', 'admin', '2023-04-11 16:31:22', 'admin', '2023-04-14 11:06:54', NULL);
    19. 

  19. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (117, '物料状态', 'sys_ma_terial', '0', 'admin', '2023-11-09 14:57:36', '', NULL, '物料状态');
    20. 

  20. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (118, '质检周期', 'sys_inspection_cycle', '0', 'admin', '2023-11-09 15:04:57', 'admin', '2023-11-09 15:06:11', NULL);
    21. 

  21. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (119, '物料类型', 'sku_type', '0', 'admin', '2023-11-09 17:50:41', '', NULL, '物料类型');
    22. 

  22. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (120, '供应商状态', 'supplier_status', '0', 'admin', '2023-11-10 09:53:05', 'admin', '2023-11-10 09:53:19', '供应商状态');
    23. 

  23. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (121, '单据业务类型', 'doc_business_type', '0', 'admin', '2023-11-16 13:48:59', '', NULL, '单据业务类型;ASN-入库，ORDER-出库');
    24. 

  24. INSERT INTO `sys_dict_type`(`dict_id`, `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (122, '仓库类型', 'warehouse_type', '0', 'admin', '2023-11-16 13:55:59', '', NULL, '仓库类型');
    25. 

  25. 

  26. /*字典数据*/
    27. 

  27. 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 (100, 1, '货架', '1', 'location_type', NULL, 'default', 'N', '0', 'admin', '2022-02-18 16:18:03', '', NULL, NULL);
    28. 

  28. 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 (101, 2, '地堆', '2', 'location_type', NULL, 'default', 'N', '0', 'admin', '2022-02-18 16:18:19', '', NULL, NULL);
    29. 

  29. 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 (102, 1, '流离货架', '3', 'location_type', NULL, 'default', 'N', '0', 'admin', '2022-02-18 16:18:29', '', NULL, NULL);
    30. 

  30. 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 (103, 1, '空闲', '00', 'location_status', NULL, 'default', 'N', '0', 'admin', '2022-02-18 16:35:13', '', NULL, NULL);
    31. 

  31. 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 (104, 2, '占用', '10', 'location_status', NULL, 'default', 'N', '0', 'admin', '2022-02-18 16:35:26', '', NULL, NULL);
    32. 

  32. 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 (105, 3, '封存', '99', 'location_status', NULL, 'default', 'N', '0', 'admin', '2022-02-18 16:35:46', '', NULL, NULL);
    33. 

  33. 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 (106, 0, '合格', '90', 'ams_inv_quality', NULL, 'default', 'N', '0', 'admin', '2022-03-03 16:33:57', 'admin', '2022-03-03 16:37:26', NULL);
    34. 

  34. 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 (107, 0, '不合格', '99', 'ams_inv_quality', NULL, 'default', 'N', '0', 'admin', '2022-03-03 16:37:17', '', NULL, NULL);
    35. 

  35. 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 (108, 0, '堆叠', '1', 'floor_type', NULL, 'default', 'N', '0', 'admin', '2022-03-07 14:04:58', '', NULL, NULL);
    36. 

  36. 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 (109, 0, '非堆叠', '0', 'floor_type', NULL, 'default', 'N', '0', 'admin', '2022-03-07 14:05:13', '', NULL, NULL);
    37. 

  37. 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 (110, 1, '收货', 'RC', 'act_transaction_dict', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:36:36', '', NULL, NULL);
    38. 

  38. 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 (111, 2, '上架', 'PA', 'act_transaction_dict', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:37:05', '', NULL, NULL);
    39. 

  39. 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 (112, 3, '拣货', 'PK', 'act_transaction_dict', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:38:10', '', NULL, NULL);
    40. 

  40. 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 (113, 4, '调整', 'OB', 'act_transaction_dict', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:38:25', '', NULL, NULL);
    41. 

  41. 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 (114, 5, '盘点', 'CO', 'act_transaction_dict', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:40:03', '', NULL, NULL);
    42. 

  42. 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 (115, 7, '验收', 'QC', 'act_transaction_dict', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:40:27', '', NULL, NULL);
    43. 

  43. 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 (116, 1, '入库单', 'ASN', 'doc_type', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:48:50', '', NULL, NULL);
    44. 

  44. 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 (117, 2, '出库单', 'SO', 'doc_type', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:57:13', '', NULL, NULL);
    45. 

  45. 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 (118, 3, '分配单', 'ALO', 'doc_type', NULL, 'default', 'N', '0', 'admin', '2022-10-11 15:58:04', '', NULL, NULL);
    46. 

  46. 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 (119, 1, '成品入库单', 'FinishedProductReceipt', 'asn_type', NULL, 'default', 'N', '0', 'admin', '2022-10-11 17:34:00', 'admin', '2023-11-13 14:35:28', NULL);
    47. 

  47. 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 (120, 2, '生产退库单', 'ProductionReturnOrder', 'asn_type', NULL, 'default', 'N', '0', 'admin', '2022-10-11 17:34:32', 'admin', '2023-11-13 14:36:11', NULL);
    48. 

  48. 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 (121, 0, '订单创建', '00', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:19:31', '', NULL, NULL);
    49. 

  49. 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 (122, 0, '同步成功', '10', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:21:02', 'admin', '2023-04-03 20:11:56', NULL);
    50. 

  50. 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 (123, 0, '部分收货', '30', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:21:14', '', NULL, NULL);
    51. 

  51. 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 (124, 0, '完全收货', '40', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:21:24', '', NULL, NULL);
    52. 

  52. 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 (125, 0, '部分上架', '50', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:21:34', '', NULL, NULL);
    53. 

  53. 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 (126, 0, '完全上架', '60', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:21:43', '', NULL, NULL);
    54. 

  54. 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 (127, 0, '部分验收', '70', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:21:52', 'admin', '2022-10-12 10:22:04', NULL);
    55. 

  55. 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 (128, 0, '完全验收', '80', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:22:23', '', NULL, NULL);
    56. 

  56. 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 (129, 0, '取消', '97', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:22:48', '', NULL, NULL);
    57. 

  57. 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 (130, 0, '关闭', '98', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:22:56', '', NULL, NULL);
    58. 

  58. 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 (131, 0, '完成', '99', 'asn_status', NULL, 'default', 'N', '0', 'admin', '2022-10-12 10:23:04', '', NULL, NULL);
    59. 

  59. 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 (132, 1, '新建', '00', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:08:46', '', NULL, NULL);
    60. 

  60. 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 (133, 2, '同步完成', '10', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:11:16', 'admin', '2023-04-26 21:49:43', NULL);
    61. 

  61. 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 (135, 4, '部分拣货', '30', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:11:58', '', NULL, NULL);
    62. 

  62. 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 (136, 3, '分配完成', '20', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:12:20', '', NULL, NULL);
    63. 

  63. 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 (137, 5, '拣货完成', '40', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:14:02', '', NULL, NULL);
    64. 

  64. 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 (138, 6, '拣货中', '50', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:14:17', '', NULL, NULL);
    65. 

  65. 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 (139, 7, '订单取消', '90', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:14:32', '', NULL, NULL);
    66. 

  66. 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 (140, 8, '关闭', '98', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:15:52', '', NULL, NULL);
    67. 

  67. 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 (141, 9, '订单完成', '99', 'so_status', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:16:04', '', NULL, NULL);
    68. 

  68. 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 (142, 1, '生产领料单', 'ProductionPickingReceipt', 'so_type', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:18:04', 'admin', '2023-11-13 14:38:08', NULL);
    69. 

  69. 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 (143, 2, '销售出库单', 'SaleOutboundOrder', 'so_type', NULL, 'default', 'N', '0', 'admin', '2022-10-18 22:19:56', 'admin', '2023-11-13 14:38:34', NULL);
    70. 

  70. 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 (144, 1, '托盘', 'pallet', 'box_type', NULL, 'default', 'N', '0', 'admin', '2022-11-01 14:29:14', '', NULL, NULL);
    71. 

  71. 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 (145, 1, '启用', '1', 'active_state', NULL, 'default', 'N', '0', 'admin', '2022-11-01 14:31:32', '', NULL, NULL);
    72. 

  72. 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 (146, 2, '禁用', '0', 'active_state', NULL, 'default', 'N', '0', 'admin', '2022-11-01 14:31:41', '', NULL, NULL);
    73. 

  73. 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 (147, 1, '订单创建', '00', 'qc_status', NULL, 'default', 'N', '0', 'jwk', '2022-11-16 15:27:31', '', NULL, NULL);
    74. 

  74. 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 (148, 2, '部分验收', '70', 'qc_status', NULL, 'default', 'N', '0', 'jwk', '2022-11-16 15:28:22', '', NULL, NULL);
    75. 

  75. 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 (149, 3, '完全验收', '80', 'qc_status', NULL, 'default', 'N', '0', 'jwk', '2022-11-16 15:28:52', '', NULL, NULL);
    76. 

  76. 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 (150, 0, '下发ams', '0', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 09:47:23', '', NULL, NULL);
    77. 

  77. 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 (151, 0, '开始', '1', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:51:08', 'admin', '2023-03-22 17:51:23', NULL);
    78. 

  78. 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 (152, 0, '已下发', '10', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:51:50', '', NULL, NULL);
    79. 

  79. 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 (153, 0, '取消并归于起点', '11', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:52:12', '', NULL, NULL);
    80. 

  80. 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 (154, 0, '取消并归于终点', '12', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:52:27', '', NULL, NULL);
    81. 

  81. 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 (155, 0, '完成', '2', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:52:39', '', NULL, NULL);
    82. 

  82. 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 (156, 0, '开始取货', '3', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:52:53', '', NULL, NULL);
    83. 

  83. 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 (157, 0, '取货完成', '4', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:53:02', 'admin', '2023-03-22 17:53:07', NULL);
    84. 

  84. 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 (158, 0, '开始卸货', '5', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:53:26', '', NULL, NULL);
    85. 

  85. 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 (159, 0, '卸货完成', '6', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:53:35', '', NULL, NULL);
    86. 

  86. 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 (160, 0, '取消', '7', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:53:45', '', NULL, NULL);
    87. 

  87. 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 (161, 0, '空叉等待', '8', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:54:05', '', NULL, NULL);
    88. 

  88. 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 (162, 0, '队列等待', '9', 'task_sts', NULL, 'default', 'N', '0', 'admin', '2023-03-22 17:54:21', '', NULL, NULL);
    89. 

  89. 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 (163, 3, '销售退库单', 'SaleReturnOrder', 'asn_type', NULL, 'default', 'N', '0', 'admin', '2023-04-03 19:51:54', 'admin', '2023-11-13 14:36:34', NULL);
    90. 

  90. 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 (164, 3, '袋装越库', 'YK', 'so_type', NULL, 'default', 'N', '0', 'admin', '2023-04-03 19:59:15', 'admin', '2023-04-03 20:38:01', NULL);
    91. 

  91. 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 (165, 1, '产线1', '1', 'pro_line_site', NULL, 'default', 'N', '0', 'admin', '2023-04-11 13:37:14', 'admin', '2023-05-12 15:02:07', NULL);
    92. 

  92. 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 (166, 2, '产线2', '2', 'pro_line_site', NULL, 'default', 'N', '0', 'admin', '2023-04-11 13:37:25', 'admin', '2023-05-12 15:02:13', NULL);
    93. 

  93. 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 (167, 3, '产线3', '3', 'pro_line_site', NULL, 'default', 'N', '0', 'admin', '2023-04-11 13:37:34', 'admin', '2023-05-12 15:02:20', NULL);
    94. 

  94. 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 (168, 4, '产线4', '4', 'pro_line_site', NULL, 'default', 'N', '0', 'admin', '2023-04-11 13:37:44', 'admin', '2023-05-12 15:02:26', NULL);
    95. 

  95. 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 (169, 5, '产线5', '5', 'pro_line_site', NULL, 'default', 'N', '0', 'admin', '2023-04-11 13:37:54', 'admin', '2023-05-12 15:02:34', NULL);
    96. 

  96. 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 (171, 1, '破袋机1号-碳酸钠', '1', 'bbmId_type', NULL, 'default', 'N', '0', 'admin', '2023-04-11 16:32:48', 'admin', '2023-07-07 18:20:06', NULL);
    97. 

  97. 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 (172, 2, '破袋机2号-丁黄药', '2', 'bbmId_type', NULL, 'default', 'N', '0', 'admin', '2023-04-11 16:33:03', 'admin', '2023-07-07 18:20:25', NULL);
    98. 

  98. 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 (173, 3, '破袋机3号-六偏磷酸钠', '3', 'bbmId_type', NULL, 'default', 'N', '0', 'admin', '2023-04-11 16:33:13', 'admin', '2023-07-07 18:20:41', NULL);
    99. 

  99. 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 (174, 4, '破袋机4号-硫酸铵', '4', 'bbmId_type', NULL, 'default', 'N', '0', 'admin', '2023-04-11 16:33:23', 'admin', '2023-07-07 18:20:56', NULL);
    100. 

  100. 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 (175, 5, '破袋机5号-乙黄药', '5', 'bbmId_type', NULL, 'default', 'N', '0', 'admin', '2023-04-11 16:33:34', 'admin', '2023-07-07 18:21:18', NULL);
    101. 

  101. 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 (176, 0, '采购收货', 'PurchaseReceipt', 'asn_type', NULL, 'default', 'N', '0', 'admin', '2023-05-16 12:15:03', 'admin', '2023-11-13 14:34:53', NULL);
    102. 

  102. 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 (177, 1, '启用', 'Y', 'sys_ma_terial', NULL, 'default', 'N', '0', 'admin', '2023-11-09 14:58:32', 'admin', '2023-11-09 15:02:54', NULL);
    103. 

  103. 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 (178, 2, '禁用', 'N', 'sys_ma_terial', NULL, 'default', 'N', '0', 'admin', '2023-11-09 14:58:50', 'admin', '2023-11-09 15:03:05', NULL);
    104. 

  104. 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 (179, 0, '要质检', 'Y', 'sys_inspection_cycle', NULL, 'default', 'N', '0', 'admin', '2023-11-09 15:05:30', '', NULL, NULL);
    105. 

  105. 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 (180, 1, '不质检', 'N', 'sys_inspection_cycle', NULL, 'default', 'N', '0', 'admin', '2023-11-09 15:05:44', '', NULL, NULL);
    106. 

  106. 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 (181, 0, '成品', '1', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:53:59', '', NULL, NULL);
    107. 

  107. 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 (182, 0, '包材', '2', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:08', '', NULL, NULL);
    108. 

  108. 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 (183, 0, '食品添加剂', '3', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:26', '', NULL, NULL);
    109. 

  109. 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 (184, 0, '食品添加剂过敏原区', '4', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:45', '', NULL, NULL);
    110. 

  110. 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 (185, 0, '原料', '5', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:55:59', '', NULL, NULL);
    111. 

  111. 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 (186, 0, '原料过敏', '6', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:56:13', '', NULL, NULL);
    112. 

  112. 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 (187, 0, '空托', '7', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:56:25', '', NULL, NULL);
    113. 

  113. 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 (188, 0, '低耗', '8', 'sku_type', NULL, 'default', 'N', '0', 'admin', '2023-11-09 17:56:37', '', NULL, NULL);
    114. 

  114. 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 (189, 0, '禁用', '0', 'supplier_status', NULL, 'danger', 'N', '0', 'admin', '2023-11-10 09:54:49', 'admin', '2023-11-10 09:54:55', '禁用');
    115. 

  115. 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 (190, 1, '启用且合格', '1', 'supplier_status', NULL, 'primary', 'N', '0', 'admin', '2023-11-10 09:55:46', 'admin', '2023-11-10 09:59:15', '启用且合格');
    116. 

  116. 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 (191, 2, '启用不合格', '2', 'supplier_status', NULL, 'warning', 'N', '0', 'admin', '2023-11-10 09:59:07', '', NULL, '启用不合格');
    117. 

  117. 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 (192, 0, '入库', 'ASN', 'doc_business_type', NULL, 'default', 'N', '0', 'admin', '2023-11-16 13:50:32', '', NULL, '入库');
    118. 

  118. 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 (193, 1, '出库', 'ORDER', 'doc_business_type', NULL, 'default', 'N', '0', 'admin', '2023-11-16 13:50:45', '', NULL, '出库');
    119. 

  119. 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 (194, 0, '冷冻库', '1', 'warehouse_type', NULL, 'default', 'N', '0', 'admin', '2023-11-16 13:56:38', '', NULL, NULL);
    120. 

  120. 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 (195, 1, '废弃库', '2', 'warehouse_type', NULL, 'default', 'N', '0', 'admin', '2023-11-16 14:06:24', '', NULL, NULL);
    121. 

  121. 

  122. /*系统配置数据*/
    123. 

  123. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
    124. 

  124. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '初始化密码 123456');
    125. 

  125. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '深色主题theme-dark，浅色主题theme-light');
    126. 

  126. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, '账号自助-验证码开关', 'sys.account.captchaOnOff', 'false', 'Y', 'admin', '2022-02-09 15:16:10', 'admin', '2022-02-16 10:55:56', '是否开启验证码功能（true开启，false关闭）');
    127. 

  127. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2022-02-09 15:16:10', '', NULL, '是否开启注册用户功能（true开启，false关闭）');
    128. 

  128. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, 'AMS任务类型对应库区选择', 'sys.docType.corresponding.business', '[{\"docType\":\"SaleOutboundOrder\",\"flowId\":18},\r\n{\"docType\":\"FinishedProductReceipt\",\"flowId\":20},\r\n{\"docType\":\"ProductionReturnOrder\",\"flowId\":21},\r\n{\"docType\":\"PurchaseOrder\",\"flowId\":22},\r\n{\"docType\":\"SaleReturnOrder\",\"flowId\":23}]', 'Y', 'admin', '2023-11-21 15:13:52', 'admin', '2023-11-21 17:24:03', 'AMS任务类型对应库区选择');
    129. 

  129. INSERT INTO `sys_config`(`config_id`, `config_name`, `config_key`, `config_value`, `config_type`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, '单据导出中文字段', 'sys.doc.field.remark', '{\"docNo\":\"单据号\",\"docType\":\"单据类型\",\"businessType\":\"业务类型\",\"remark\":\"备注\",\"docLineNo\":\"明细行号\",\"skuCode\":\"物料编码\",\"skuName\":\"物料名称\",\"skuQty\":\"物料数量\",\"productLotNumber\":\"产品批号\",\"receiver\":\"收货人\",\"warehousePerson\":\"入库人\",\"reviewerNext\":\"复审人\",\"specification\":\"规格\",\"qualityInspectionDoc\":\"质检单号\",\"incomeLotNumber\":\"进厂批号\",\"productLotNumber\":\"产品批号\",\"measureUnit\":\"计量单位\",\"manufactureDate\":\"生产日期\",\"returner\":\"退库人\",\"vendorCode\":\"供应商编码\",\"vendorName\":\"供应商全称\",\"purchaser\":\"采购人\",\"taxRate\":\"税率\",\"originalLotNumber\":\"进厂批号\",\"incomeLotNumber\":\"进厂批号\",\"manufactureDate\":\"生产日期\",\"priceIncludeTax\":\"含税价\",\"customName\":\"客户名称\",\"dept\":\"部门名称\",\"reviewer\":\"审核人\",\"receiveAddress\":\"收货地址\",\"receivePhone\":\"收货人电话\",\"docCreator\":\"制单人\",\"shipper\":\"发货人\",\"receivePhone\":\"收货人电话\",\"saleContract\":\"销售合同\",\"productName\":\"产品名称\",\"saleReturnUnit\":\"销售退货单位\",\"saleReturner\":\"销售退货人\",\"warehouseType\":\"仓库类别\",\"saleReturner\":\"销售退货人\"}', 'Y', '', NULL, '', NULL, NULL);
    130. 

  130. 

  131. /*物料类型测试数据*/
    132. 

  132. INSERT INTO `base_sku_type`(`item_code`, `item_name`, `parent_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, '原料', '0', '0', '', '2023-11-22 11:31:39', '', NULL, NULL);
    133. 

  133. INSERT INTO `base_sku_type`(`item_code`, `item_name`, `parent_code`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, '成品', '0', '0', '', '2023-11-22 13:36:16', '', NULL, '成品');
    134. 

  134. 

  135. /*库区测试数据*/
    136. 

  136. INSERT INTO `base_location_zone`(`zone_id`, `zone_name`, `warehouse_id`, `status`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1, '测试库区1', 1, '0', 'INV', '0', '0', NULL, NULL, '', '2023-11-22 13:26:21', '', NULL, '测试');
    137. 

  137. INSERT INTO `base_location_zone`(`zone_id`, `zone_name`, `warehouse_id`, `status`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, '测试库区2', 1, '0', 'INV', '1', '1', NULL, NULL, '', '2023-11-22 13:33:33', '', NULL, '222');
    138. 

  138. INSERT INTO `base_location_zone`(`zone_id`, `zone_name`, `warehouse_id`, `status`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, '测试库区3', 1, '0', 'INV', '2', '2', NULL, NULL, '', '2023-11-22 13:33:59', '', NULL, '333');
    139. 

  139. 

  140. /*库位测试数据*/
    141. 

  141. INSERT INTO `base_location_info`(`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101337, 1, 1, 'cs001', NULL, '0', 0, '1', 1, '1', 1, '00', 'N', '9', '1', '11', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-11-22 13:30:08', '', '2023-11-22 15:27:06', NULL);
    142. 

  142. INSERT INTO `base_location_info`(`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101338, 1, 2, 'cs002', NULL, '1', 1, '1', 1, '1', 1, '00', 'Y', '9', '1', '1', 2, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-11-22 13:35:11', '', NULL, NULL);
    143. 

  143. INSERT INTO `base_location_info`(`id`, `warehouse_id`, `zone_id`, `location_no`, `location_barcode`, `row_no`, `row_index`, `col_no`, `col_index`, `shift_no`, `shift_index`, `stock_status`, `is_empty`, `bind_sku`, `location_type`, `rack_id`, `agv_station`, `folded_tag`, `folded_count`, `height_limit`, `weight_limit`, `userdefine1`, `userdefine2`, `userdefine3`, `userdefine4`, `userdefine5`, `userdefine6`, `userdefine7`, `userdefine8`, `userdefine9`, `userdefine10`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (101339, 1, 3, 'cs003', NULL, '2', 2, '2', 2, '1', 1, '00', 'Y', '9', '1', '2', 3, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '2023-11-22 13:35:50', '', NULL, NULL);
    144. 

  144. 

  145. /*sys_menu数据*/
    146. 

  146. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2000, '基础信息', 0, 1, 'base', NULL, NULL, 1, 0, 'M', '0', '0', '', 'documentation', 'admin', '2022-02-09 15:57:09', 'admin', '2022-11-08 17:21:09', '');
    147. 

  147. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2001, '仓库', 2000, 1, 'warehouse', 'base/warehouse/index', NULL, 1, 0, 'C', '0', '0', 'base:warehouse:list', '#', 'admin', '2022-02-09 16:44:18', '', NULL, '仓库菜单');
    148. 

  148. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2002, '仓库信息查询', 2001, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:warehouse:query', '#', 'admin', '2022-02-09 16:44:18', '', NULL, '');
    149. 

  149. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2003, '仓库信息新增', 2001, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:warehouse:add', '#', 'admin', '2022-02-09 16:44:18', '', NULL, '');
    150. 

  150. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2004, '仓库信息修改', 2001, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:warehouse:edit', '#', 'admin', '2022-02-09 16:44:18', '', NULL, '');
    151. 

  151. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2005, '仓库信息删除', 2001, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:warehouse:remove', '#', 'admin', '2022-02-09 16:44:18', '', NULL, '');
    152. 

  152. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2006, '仓库信息导出', 2001, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:warehouse:export', '#', 'admin', '2022-02-09 16:44:18', '', NULL, '');
    153. 

  153. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2007, '配置管理', 0, 2, 'config', NULL, NULL, 1, 0, 'M', '0', '0', '', 'swagger', 'admin', '2022-02-14 10:58:30', 'admin', '2022-11-08 17:22:01', '');
    154. 

  154. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2008, '库区', 2000, 2, 'locationZone', 'base/locationZone/index', NULL, 1, 0, 'C', '0', '0', 'base:locationZone:list', '#', 'admin', '2022-02-15 14:50:53', '', NULL, '库区菜单');
    155. 

  155. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2009, '库区查询', 2008, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationZone:query', '#', 'admin', '2022-02-15 14:50:54', '', NULL, '');
    156. 

  156. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2010, '库区新增', 2008, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationZone:add', '#', 'admin', '2022-02-15 14:50:54', '', NULL, '');
    157. 

  157. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2011, '库区修改', 2008, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationZone:edit', '#', 'admin', '2022-02-15 14:50:54', '', NULL, '');
    158. 

  158. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2012, '库区删除', 2008, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationZone:remove', '#', 'admin', '2022-02-15 14:50:54', '', NULL, '');
    159. 

  159. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2013, '库区导出', 2008, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationZone:export', '#', 'admin', '2022-02-15 14:50:54', '', NULL, '');
    160. 

  160. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2014, '批次属性配置', 2007, 1, 'config', 'ams/config/index', NULL, 1, 0, 'C', '0', '0', 'ams:config:list', '#', 'admin', '2022-02-16 10:56:37', '', NULL, 'lotattConfig菜单');
    161. 

  161. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2015, '批次属性配置查询', 2014, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:config:query', '#', 'admin', '2022-02-16 10:56:37', '', NULL, '');
    162. 

  162. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2016, '批次属性配置新增', 2014, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:config:add', '#', 'admin', '2022-02-16 10:56:38', '', NULL, '');
    163. 

  163. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2017, '批次属性配置修改', 2014, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:config:edit', '#', 'admin', '2022-02-16 10:56:38', '', NULL, '');
    164. 

  164. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2018, '批次属性配置删除', 2014, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:config:remove', '#', 'admin', '2022-02-16 10:56:38', '', NULL, '');
    165. 

  165. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2019, '批次属性配置导出', 2014, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:config:export', '#', 'admin', '2022-02-16 10:56:38', '', NULL, '');
    166. 

  166. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2020, '流程配置', 2007, 1, 'flowConfig', 'ams/flowConfig/index', NULL, 1, 0, 'C', '0', '0', 'ams:flowConfig:list', '#', 'admin', '2022-02-16 16:59:24', '', NULL, '流程配置头菜单');
    167. 

  167. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2021, '流程配置查询', 2020, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:flowConfig:query', '#', 'admin', '2022-02-16 16:59:24', '', NULL, '');
    168. 

  168. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2022, '流程配置新增', 2020, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:flowConfig:add', '#', 'admin', '2022-02-16 16:59:24', '', NULL, '');
    169. 

  169. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2023, '流程配置修改', 2020, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:flowConfig:edit', '#', 'admin', '2022-02-16 16:59:24', '', NULL, '');
    170. 

  170. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2024, '流程配置删除', 2020, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:flowConfig:remove', '#', 'admin', '2022-02-16 16:59:24', '', NULL, '');
    171. 

  171. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2025, '流程配置导出', 2020, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:flowConfig:export', '#', 'admin', '2022-02-16 16:59:24', '', NULL, '');
    172. 

  172. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2026, '库位', 2000, 3, 'locationInfo', 'base/locationInfo/index', NULL, 1, 0, 'C', '0', '0', 'base:locationInfo:list', '#', 'admin', '2022-02-18 17:28:48', '', NULL, '库位菜单');
    173. 

  173. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2027, '库位查询', 2026, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationInfo:query', '#', 'admin', '2022-02-18 17:28:48', '', NULL, '');
    174. 

  174. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2028, '库位新增', 2026, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationInfo:add', '#', 'admin', '2022-02-18 17:28:48', '', NULL, '');
    175. 

  175. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2029, '库位修改', 2026, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationInfo:edit', '#', 'admin', '2022-02-18 17:28:48', '', NULL, '');
    176. 

  176. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2030, '库位删除', 2026, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationInfo:remove', '#', 'admin', '2022-02-18 17:28:48', '', NULL, '');
    177. 

  177. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2031, '库位导出', 2026, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:locationInfo:export', '#', 'admin', '2022-02-18 17:28:48', '', NULL, '');
    178. 

  178. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2032, '物料种类', 2000, 5, 'skuType', 'base/skuType/index', '', 1, 0, 'C', '0', '0', 'base:skuType:list', '#', 'admin', '2022-02-21 16:11:07', '', NULL, '物料种类菜单');
    179. 

  179. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2033, '物料分类查询', 2032, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:skuType:query', '#', 'admin', '2022-02-21 16:11:07', '', NULL, '');
    180. 

  180. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2034, '物料分类新增', 2032, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:skuType:add', '#', 'admin', '2022-02-21 16:11:07', '', NULL, '');
    181. 

  181. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2035, '物料分类修改', 2032, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:skuType:edit', '#', 'admin', '2022-02-21 16:11:07', '', NULL, '');
    182. 

  182. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2036, '物料分类删除', 2032, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:skuType:remove', '#', 'admin', '2022-02-21 16:11:07', '', NULL, '');
    183. 

  183. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2037, '物料分类导出', 2032, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:skuType:export', '#', 'admin', '2022-02-21 16:11:07', '', NULL, '');
    184. 

  184. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2038, '物料信息', 2000, 4, 'baseSku', 'base/baseSku/index', NULL, 1, 0, 'C', '0', '0', 'base:baseSku:list', '#', 'admin', '2022-02-21 16:52:06', '', NULL, '物料信息菜单');
    185. 

  185. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2039, '物料信息查询', 2038, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:baseSku:query', '#', 'admin', '2022-02-21 16:52:06', '', NULL, '');
    186. 

  186. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2040, '物料信息新增', 2038, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:baseSku:add', '#', 'admin', '2022-02-21 16:52:06', '', NULL, '');
    187. 

  187. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2041, '物料信息修改', 2038, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:baseSku:edit', '#', 'admin', '2022-02-21 16:52:06', '', NULL, '');
    188. 

  188. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2042, '物料信息删除', 2038, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:baseSku:remove', '#', 'admin', '2022-02-21 16:52:06', '', NULL, '');
    189. 

  189. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2043, '物料信息导出', 2038, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:baseSku:export', '#', 'admin', '2022-02-21 16:52:06', '', NULL, '');
    190. 

  190. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2044, '客户', 2000, 8, 'customer', 'base/customer/index', NULL, 1, 0, 'C', '0', '0', 'base:customer:list', '#', 'admin', '2022-02-21 17:24:04', '', NULL, '客户菜单');
    191. 

  191. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2045, '客户查询', 2044, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:customer:query', '#', 'admin', '2022-02-21 17:24:04', '', NULL, '');
    192. 

  192. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2046, '客户新增', 2044, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:customer:add', '#', 'admin', '2022-02-21 17:24:04', '', NULL, '');
    193. 

  193. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2047, '客户修改', 2044, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:customer:edit', '#', 'admin', '2022-02-21 17:24:04', '', NULL, '');
    194. 

  194. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2048, '客户删除', 2044, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:customer:remove', '#', 'admin', '2022-02-21 17:24:04', '', NULL, '');
    195. 

  195. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2049, '客户导出', 2044, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:customer:export', '#', 'admin', '2022-02-21 17:24:04', '', NULL, '');
    196. 

  196. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2050, '供应商', 2000, 7, 'supplier', 'base/supplier/index', NULL, 1, 0, 'C', '0', '0', 'base:supplier:list', '#', 'admin', '2022-02-21 17:31:08', '', NULL, '供应商菜单');
    197. 

  197. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2051, '供应商查询', 2050, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:supplier:query', '#', 'admin', '2022-02-21 17:31:08', '', NULL, '');
    198. 

  198. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2052, '供应商新增', 2050, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:supplier:add', '#', 'admin', '2022-02-21 17:31:08', '', NULL, '');
    199. 

  199. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2053, '供应商修改', 2050, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:supplier:edit', '#', 'admin', '2022-02-21 17:31:08', '', NULL, '');
    200. 

  200. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2054, '供应商删除', 2050, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:supplier:remove', '#', 'admin', '2022-02-21 17:31:08', '', NULL, '');
    201. 

  201. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2055, '供应商导出', 2050, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'base:supplier:export', '#', 'admin', '2022-02-21 17:31:08', '', NULL, '');
    202. 

  202. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2056, '出入库策略', 2007, 3, 'locationPriority', 'ams/locationPriority/index', NULL, 1, 0, 'C', '0', '0', 'ams:locationPriority:list', '#', 'admin', '2022-02-25 13:57:02', '', NULL, '路径规划菜单');
    203. 

  203. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2057, '出入库策略查询', 2056, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:locationPriority:query', '#', 'admin', '2022-02-25 13:57:02', '', NULL, '');
    204. 

  204. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2058, '出入库策略新增', 2056, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:locationPriority:add', '#', 'admin', '2022-02-25 13:57:02', '', NULL, '');
    205. 

  205. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2059, '出入库策略修改', 2056, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:locationPriority:edit', '#', 'admin', '2022-02-25 13:57:02', '', NULL, '');
    206. 

  206. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2060, '出入库策略删除', 2056, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:locationPriority:remove', '#', 'admin', '2022-02-25 13:57:02', '', NULL, '');
    207. 

  207. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2061, '出入库策略导出', 2056, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:locationPriority:export', '#', 'admin', '2022-02-25 13:57:02', '', NULL, '');
    208. 

  208. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2062, '库存', 0, 6, 'inv', NULL, NULL, 1, 0, 'M', '0', '0', '', 'build', 'admin', '2022-03-03 10:10:37', 'admin', '2022-11-08 17:26:43', '');
    209. 

  209. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2063, '库位库存信息', 2062, 1, 'invLotLocId', 'ams/inv/invLotLocId/index', NULL, 1, 0, 'C', '0', '0', 'ams:invLotLocId:list', '#', 'admin', '2022-03-03 10:44:47', '', NULL, '库位库存信息菜单');
    210. 

  210. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2064, '库位库存信息查询', 2063, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:query', '#', 'admin', '2022-03-03 10:44:47', '', NULL, '');
    211. 

  211. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2065, '库位库存信息新增', 2063, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:add', '#', 'admin', '2022-03-03 10:44:47', '', NULL, '');
    212. 

  212. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2066, '库位库存信息修改', 2063, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:edit', '#', 'admin', '2022-03-03 10:44:47', '', NULL, '');
    213. 

  213. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2067, '库位库存信息删除', 2063, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:remove', '#', 'admin', '2022-03-03 10:44:47', '', NULL, '');
    214. 

  214. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2068, '库位库存信息导出', 2063, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:export', '#', 'admin', '2022-03-03 10:44:47', '', NULL, '');
    215. 

  215. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2069, '物料拉动', 0, 4, 'lineCall', 'ams/lineCall/index', NULL, 1, 0, 'C', '0', '0', '', 'shopping', 'admin', '2022-03-07 15:39:30', 'admin', '2022-11-08 17:23:56', '');
    216. 

  216. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2070, '任务管理', 0, 4, 'task', 'ams/task/index', NULL, 1, 0, 'C', '0', '0', '', 'job', 'admin', '2022-03-10 13:07:31', 'admin', '2022-11-08 17:28:43', '');
    217. 

  217. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2071, '库位视图', 2062, 2, 'locationView', 'ams/inv/locationView/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2022-03-15 11:20:46', '', NULL, '');
    218. 

  218. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2072, '库存事务', 2062, 1, 'transactionLog', 'ams/transactionLog/index', NULL, 1, 0, 'C', '0', '0', 'ams:transactionLog:list', '#', 'admin', '2022-10-11 16:27:09', '', NULL, '库存事务菜单');
    219. 

  219. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2073, '库存事务查询', 2072, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:transactionLog:query', '#', 'admin', '2022-10-11 16:27:09', '', NULL, '');
    220. 

  220. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2074, '库存事务新增', 2072, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:transactionLog:add', '#', 'admin', '2022-10-11 16:27:09', '', NULL, '');
    221. 

  221. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2075, '库存事务修改', 2072, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:transactionLog:edit', '#', 'admin', '2022-10-11 16:27:09', '', NULL, '');
    222. 

  222. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2076, '库存事务删除', 2072, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:transactionLog:remove', '#', 'admin', '2022-10-11 16:27:09', '', NULL, '');
    223. 

  223. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2077, '库存事务导出', 2072, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:transactionLog:export', '#', 'admin', '2022-10-11 16:27:09', '', NULL, '');
    224. 

  224. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2078, '入库', 0, 8, 'docAsn', NULL, NULL, 1, 0, 'M', '0', '0', '', 'edit', 'admin', '2022-10-12 10:43:01', 'admin', '2022-11-08 17:27:43', '');
    225. 

  225. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2079, '入库管理', 2078, 1, 'docAsn', 'wms/docAsn/index', NULL, 1, 0, 'C', '0', '0', 'docAsn:docAsn:list', '#', 'admin', '2022-10-12 13:37:38', '', NULL, '入库单菜单');
    226. 

  226. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2080, '入库单查询', 2079, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'docAsn:docAsn:query', '#', 'admin', '2022-10-12 13:37:38', '', NULL, '');
    227. 

  227. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2081, '入库单新增', 2079, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'docAsn:docAsn:add', '#', 'admin', '2022-10-12 13:37:38', '', NULL, '');
    228. 

  228. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2082, '入库单修改', 2079, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'docAsn:docAsn:edit', '#', 'admin', '2022-10-12 13:37:38', '', NULL, '');
    229. 

  229. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2083, '入库单删除', 2079, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'docAsn:docAsn:remove', '#', 'admin', '2022-10-12 13:37:38', '', NULL, '');
    230. 

  230. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2084, '入库单导出', 2079, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'docAsn:docAsn:export', '#', 'admin', '2022-10-12 13:37:38', '', NULL, '');
    231. 

  231. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2085, '出库', 0, 9, 'docOrder', NULL, NULL, 1, 0, 'M', '0', '0', '', 'tool', 'admin', '2022-10-18 22:29:27', 'admin', '2022-11-08 17:28:06', '');
    232. 

  232. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2086, '出库单', 2085, 1, 'docOrder', 'wms/docOrder/index', NULL, 1, 0, 'C', '0', '0', 'docOrder:docOrder:list', '#', 'admin', '2022-10-18 22:34:07', '', NULL, '出库单菜单');
    233. 

  233. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2087, '出库单查询', 2086, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'docOrder:docOrder:query', '#', 'admin', '2022-10-18 22:34:07', '', NULL, '');
    234. 

  234. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2088, '出库单新增', 2086, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'docOrder:docOrder:add', '#', 'admin', '2022-10-18 22:34:07', '', NULL, '');
    235. 

  235. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2089, '出库单修改', 2086, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'docOrder:docOrder:edit', '#', 'admin', '2022-10-18 22:34:07', '', NULL, '');
    236. 

  236. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2090, '出库单删除', 2086, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'docOrder:docOrder:remove', '#', 'admin', '2022-10-18 22:34:07', '', NULL, '');
    237. 

  237. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2091, '出库单导出', 2086, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'docOrder:docOrder:export', '#', 'admin', '2022-10-18 22:34:07', '', NULL, '');
    238. 

  238. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2092, '分配查询', 2085, 1, 'allocation', 'wms/allocation/index', NULL, 1, 0, 'C', '0', '0', 'ams:allocation:list', '#', 'admin', '2022-10-28 14:00:18', '', NULL, '分配查询菜单');
    239. 

  239. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2093, '分配查询查询', 2092, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:allocation:query', '#', 'admin', '2022-10-28 14:00:18', '', NULL, '');
    240. 

  240. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2094, '分配查询导出', 2092, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'ams:allocation:export', '#', 'admin', '2022-10-28 14:00:18', '', NULL, '');
    241. 

  241. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2095, '容器管理', 2000, 1, 'boxInfo', 'wms/box/index', NULL, 1, 0, 'C', '0', '0', 'box:boxInfo:list', '#', 'admin', '2022-11-01 14:35:12', '', NULL, '容器管理菜单');
    242. 

  242. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2096, '容器管理查询', 2095, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'box:boxInfo:query', '#', 'admin', '2022-11-01 14:35:12', '', NULL, '');
    243. 

  243. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2097, '容器管理新增', 2095, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'box:boxInfo:add', '#', 'admin', '2022-11-01 14:35:13', '', NULL, '');
    244. 

  244. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2098, '容器管理修改', 2095, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'box:boxInfo:edit', '#', 'admin', '2022-11-01 14:35:13', '', NULL, '');
    245. 

  245. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2099, '容器管理删除', 2095, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'box:boxInfo:remove', '#', 'admin', '2022-11-01 14:35:13', '', NULL, '');
    246. 

  246. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2100, '容器管理导出', 2095, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'box:boxInfo:export', '#', 'admin', '2022-11-01 14:35:13', '', NULL, '');
    247. 

  247. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2108, '库存调整', 2063, 6, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:adj', '#', 'admin', '2022-11-08 16:59:48', '', NULL, '');
    248. 

  248. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2109, '库存移动', 2063, 7, '', NULL, NULL, 1, 0, 'F', '0', '0', 'ams:invLotLocId:move', '#', 'jwk', '2022-11-08 17:02:41', '', NULL, '');
    249. 

  249. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2110, '取消', 2086, 7, '', NULL, NULL, 1, 0, 'F', '0', '0', 'docOrder:docOrder:cancel', 'edit', 'admin', '2022-11-29 15:25:43', 'admin', '2022-11-29 15:26:02', '');
    250. 

  250. INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2111, '库存数量', 2062, 3, 'total', 'ams/inv/invLotLocId/total', NULL, 1, 0, 'M', '0', '0', '', 'chart', 'admin', '2023-06-29 16:17:00', 'admin', '2023-06-29 16:17:10', '');
    251. 

  251. 

  252. UPDATE `sys_menu` SET `menu_name` = '系统管理', `parent_id` = 0, `order_num` = 99, `path` = 'system', `component` = NULL, `query` = '', `is_frame` = 1, `is_cache` = 0, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = 'system', `create_by` = 'admin', `create_time` = '2022-02-09 15:16:04', `update_by` = '', `update_time` = NULL, `remark` = '系统管理目录' WHERE `menu_id` = 1;
    253. 

  253. UPDATE `sys_menu` SET `menu_name` = '系统监控', `parent_id` = 0, `order_num` = 100, `path` = 'monitor', `component` = NULL, `query` = '', `is_frame` = 1, `is_cache` = 0, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = 'monitor', `create_by` = 'admin', `create_time` = '2022-02-09 15:16:04', `update_by` = '', `update_time` = NULL, `remark` = '系统监控目录' WHERE `menu_id` = 2;
    254. 

  254. UPDATE `sys_menu` SET `menu_name` = '系统工具', `parent_id` = 0, `order_num` = 101, `path` = 'tool', `component` = NULL, `query` = '', `is_frame` = 1, `is_cache` = 0, `menu_type` = 'M', `visible` = '0', `status` = '0', `perms` = '', `icon` = 'tool', `create_by` = 'admin', `create_time` = '2022-02-09 15:16:04', `update_by` = '', `update_time` = NULL, `remark` = '系统工具目录' WHERE `menu_id` = 3;
    255. 

  255. DELETE FROM sys_menu WHERE menu_id = 4
    256. 

  256. 

  257. /*批次配置数据*/
    258. 

  258. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (2, 'lotatt01', '客户编码', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-04-07 22:05:09', NULL);
    259. 

  259. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (3, 'lotatt02', '原厂批号', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-08-29 17:34:02', NULL);
    260. 

  260. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (4, 'lotatt03', '生产日期', 'Choice', 'DateBox', '', '', '0', '', NULL, '', NULL, NULL);
    261. 

  261. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (5, 'lotatt04', '有效期', 'Choice', 'DateBox', NULL, NULL, '0', '', NULL, '', NULL, NULL);
    262. 

  262. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (6, 'lotatt05', '检验状态', 'Choice', 'ComboBox', 'ams_inv_quality', '90', '0', '', NULL, '', '2022-12-22 16:58:33', NULL);
    263. 

  263. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (7, 'lotatt06', '入库日期', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:58:43', NULL);
    264. 

  264. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (8, 'lotatt07', '进厂批号', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:59:45', NULL);
    265. 

  265. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (9, 'lotatt08', '生产批号', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:59:52', NULL);
    266. 

  266. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (10, 'lotatt09', '入库单号', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:58:55', NULL);
    267. 

  267. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (11, 'lotatt10', '自定义', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 17:00:00', NULL);
    268. 

  268. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (12, 'lotatt11', '自定义', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:58:20', NULL);
    269. 

  269. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (13, 'lotatt12', '自定义', 'Choice', 'ComboBox', 'sys_yes_no', NULL, '0', '', NULL, '', NULL, NULL);
    270. 

  270. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (14, 'lotatt13', '自定义', 'Choice', 'DateBox', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:58:13', NULL);
    271. 

  271. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (15, 'lotatt14', '自定义', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-03-31 15:35:42', NULL);
    272. 

  272. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (16, 'lotatt15', '自定义', 'Choice', 'ComboBox', 'qc_status', NULL, '0', '', NULL, '', '2022-12-16 10:46:53', NULL);
    273. 

  273. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (17, 'lotatt16', '自定义', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:58:03', NULL);
    274. 

  274. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (18, 'lotatt17', '自定义批次17', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-12-22 16:57:54', NULL);
    275. 

  275. INSERT INTO `baisuilai_test`.`lotatt_config`(`id`, `lotatt_id`, `lotatt_name`, `required_tag`, `input_type`, `input_scope`, `default_value`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (19, 'lotatt18', '自定义批次18', 'Choice', 'Text', NULL, NULL, '0', '', NULL, '', '2022-04-12 19:35:11', NULL);
    276.