defective.md 19.3 KB

Edit Raw Blame History



item_text
item_value


外观不良-黑线
1


外观不良-线痕
2


外观不良-挤压纹
3


外观不良-拉伤/拉毛
4


外观不良-碰划伤
5


外观不良-油污/脏污
6


外观不良-砂薄
7


外观不良-漏喷砂
8


外观不良-腐蚀斑
9


外观不良-水渍
10


外观不良-封孔灰
11


外观不良-色差/色变
12


外观不良-锈渍
13


外观不良-气泡
14


外观不良-裂纹
15


外观不良-变形
16


尺寸不良-型腔尺寸大
17


尺寸不良-型腔尺寸小
18


尺寸不良-卡槽大
19


尺寸不良-卡槽小
20


尺寸不良-B面壁厚大
21


尺寸不良-B面壁厚小
22


尺寸不良-C面壁厚大
23


尺寸不良-C面壁厚小
24


尺寸不良-D面壁厚大
25


尺寸不良-D面壁厚小
26


尺寸不良-定尺长
27


尺寸不良-定尺短
28


尺寸不良-ABC面宽度（大小）
29


性能不良-硬度不良
30


性能不良-膜厚不良
31


性能不良-封孔不良
32


性能不良-卡槽/溢胶槽拉伤/缺失
33


性能不良-加强筋拉伤/缺失
34


性能不良-力学性能不良
35


规格不良-型号混料
36


规格不良-系统与实物不符
37


包装不良-COA报告有误
38


包装不良-包装破损/变形/脏污
39


包装不良-打包方式错误
40


包装不良-标签/标识问题
41


包装不良-超保质期
42


包装不良-标签与实物不符
43


### 要删除的记录
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (460, 112, '赃污', '1', '', 1, 1, '管理员', '2025-03-10 15:00:50', '管理员', '2025-03-10 15:03:41');
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (461, 112, '划伤/擦伤', '2', '', 2, 1, '管理员', '2025-03-10 15:01:07', '管理员', '2025-03-10 15:03:45');
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (462, 112, '色变/色差', '3', '', 3, 1, '管理员', '2025-03-10 15:01:17', '管理员', '2025-03-10 15:03:50');
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (463, 112, '变形', '4', '', 4, 1, '管理员', '2025-03-10 15:01:51', '管理员', '2025-03-10 15:03:53');
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (464, 112, '气泡', '5', '', 5, 1, '管理员', '2025-03-10 15:04:08', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (465, 112, '水波纹', '6', '', 6, 1, '管理员', '2025-03-10 15:04:18', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (466, 112, '裂纹', '7', '', 7, 1, '管理员', '2025-03-10 15:04:28', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (467, 112, '滚轮纹', '8', '', 8, 1, '管理员', '2025-03-10 15:04:43', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (468, 112, '油污', '9', '', 9, 1, '管理员', '2025-03-10 15:04:52', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (469, 112, '翘曲', '10', '', 10, 1, '管理员', '2025-03-10 15:05:06', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (470, 112, '超上限', '11', '', 11, 1, '管理员', '2025-03-10 15:05:14', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (471, 112, '超下限', '12', '', 12, 1, '管理员', '2025-03-10 15:05:29', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (472, 112, 'CPK不达标', '13', '', 13, 1, '管理员', '2025-03-10 15:05:42', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (473, 112, '物料有误', '14', '', 14, 1, '管理员', '2025-03-18 15:17:52', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (487, 112, '原材侧翻', '15', '', 1, 1, '设备', '2025-08-08 20:46:46', '设备', '2025-08-08 20:49:29');
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (488, 112, '混料', '16', '', 1, 1, '设备', '2025-08-08 20:48:03', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`id`, `dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (489, 112, '卡槽小', '17', '', 1, 1, '生产', '2025-08-12 10:51:48', NULL, NULL);


INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-黑线', '1', '', 1, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-线痕', '2', '', 2, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-挤压纹', '3', '', 3, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-拉伤/拉毛', '4', '', 4, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-碰划伤', '5', '', 5, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-油污/脏污', '6', '', 6, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-砂薄', '7', '', 7, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-漏喷砂', '8', '', 8, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-腐蚀斑', '9', '', 9, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-水渍', '10', '', 10, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-封孔灰', '11', '', 11, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-色差/色变', '12', '', 12, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-锈渍', '13', '', 13, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-气泡', '14', '', 14, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-裂纹', '15', '', 15, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '外观不良-变形', '16', '', 16, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-型腔尺寸大', '17', '', 17, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-型腔尺寸小', '18', '', 18, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-卡槽大', '19', '', 19, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-卡槽小', '20', '', 20, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-B面壁厚大', '21', '', 21, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-B面壁厚小', '22', '', 22, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-C面壁厚大', '23', '', 23, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-C面壁厚小', '24', '', 24, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-D面壁厚大', '25', '', 25, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-D面壁厚小', '26', '', 26, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-定尺长', '27', '', 27, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-定尺短', '28', '', 28, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '尺寸不良-ABC面宽度（大小）', '29', '', 29, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '性能不良-硬度不良', '30', '', 30, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '性能不良-膜厚不良', '31', '', 31, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '性能不良-封孔不良', '32', '', 32, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '性能不良-卡槽/溢胶槽拉伤/缺失', '33', '', 33, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '性能不良-加强筋拉伤/缺失', '34', '', 34, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '性能不良-力学性能不良', '35', '', 35, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '规格不良-型号混料', '36', '', 36, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '规格不良-系统与实物不符', '37', '', 37, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '包装不良-COA报告有误', '38', '', 38, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '包装不良-包装破损/变形/脏污', '39', '', 39, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '包装不良-打包方式错误', '40', '', 40, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '包装不良-标签/标识问题', '41', '', 41, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '包装不良-超保质期', '42', '', 42, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);
INSERT INTO `wms4_hefeijingke`.`sys_dict_item` (`dict_id`, `item_text`, `item_value`, `description`, `sort_order`, `status`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (112, '包装不良-标签与实物不符', '43', '', 43, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);