
/*字典数据类型*/
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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, '物料状态');
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);
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, '物料类型');
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', '供应商状态');
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-出库');
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, '仓库类型');

/*字典数据*/
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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);
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', '禁用');
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', '启用且合格');
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, '启用不合格');
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, '入库');
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, '出库');
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);
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);

/*系统配置数据*/
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');
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');
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');
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关闭）');
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关闭）');
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任务类型对应库区选择');
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);

/*物料类型测试数据*/
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);
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, '成品');

/*库区测试数据*/
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, '测试');
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');
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');

/*库位测试数据*/
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);
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);
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);

/*sys_menu数据*/
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', '');
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, '仓库菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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', '');
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, '库区菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '流程配置头菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '库位菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '物料种类菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '物料信息菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '客户菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '供应商菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '路径规划菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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', '');
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, '库位库存信息菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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', '');
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', '');
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, '');
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, '库存事务菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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', '');
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, '入库单菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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', '');
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, '出库单菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '分配查询菜单');
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, '');
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, '');
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, '容器管理菜单');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '');
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, '');
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', '');
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', '');

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;
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;
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;
DELETE FROM sys_menu WHERE menu_id = 4

/*批次配置数据*/
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
INSERT INTO `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);
