defective.md 19.3 KB

Edit Raw Blame History



item_text
item_value


外观不良-黑线
100


外观不良-线痕
101


外观不良-挤压纹
102


外观不良-拉伤/拉毛
103


外观不良-碰划伤
104


外观不良-油污/脏污
105


外观不良-砂薄
106


外观不良-漏喷砂
107


外观不良-腐蚀斑
108


外观不良-水渍
109


外观不良-封孔灰
110


外观不良-色差/色变
111


外观不良-锈渍
112


外观不良-气泡
113


外观不良-裂纹
114


外观不良-变形
115


尺寸不良-型腔尺寸大
116


尺寸不良-型腔尺寸小
117


尺寸不良-卡槽大
118


尺寸不良-卡槽小
119


尺寸不良-B面壁厚大
120


尺寸不良-B面壁厚小
121


尺寸不良-C面壁厚大
122


尺寸不良-C面壁厚小
123


尺寸不良-D面壁厚大
124


尺寸不良-D面壁厚小
125


尺寸不良-定尺长
126


尺寸不良-定尺短
127


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


性能不良-硬度不良
129


性能不良-膜厚不良
130


性能不良-封孔不良
131


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


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


性能不良-力学性能不良
134


规格不良-型号混料
135


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


包装不良-COA报告有误
137


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


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


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


包装不良-超保质期
141


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


要删除的记录

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, '外观不良-黑线', '100', '', 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, '外观不良-线痕', '101', '', 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, '外观不良-挤压纹', '102', '', 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, '外观不良-拉伤/拉毛', '103', '', 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, '外观不良-碰划伤', '104', '', 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, '外观不良-油污/脏污', '105', '', 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, '外观不良-砂薄', '106', '', 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, '外观不良-漏喷砂', '107', '', 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, '外观不良-腐蚀斑', '108', '', 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, '外观不良-水渍', '109', '', 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, '外观不良-封孔灰', '110', '', 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, '外观不良-色差/色变', '111', '', 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, '外观不良-锈渍', '112', '', 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, '外观不良-气泡', '113', '', 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, '外观不良-裂纹', '114', '', 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, '外观不良-变形', '115', '', 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, '尺寸不良-型腔尺寸大', '116', '', 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, '尺寸不良-型腔尺寸小', '117', '', 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, '尺寸不良-卡槽大', '118', '', 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, '尺寸不良-卡槽小', '119', '', 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面壁厚大', '120', '', 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面壁厚小', '121', '', 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面壁厚大', '122', '', 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面壁厚小', '123', '', 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面壁厚大', '124', '', 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面壁厚小', '125', '', 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, '尺寸不良-定尺长', '126', '', 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, '尺寸不良-定尺短', '127', '', 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面宽度（大小）', '128', '', 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, '性能不良-硬度不良', '129', '', 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, '性能不良-膜厚不良', '130', '', 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, '性能不良-封孔不良', '131', '', 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, '性能不良-卡槽/溢胶槽拉伤/缺失', '132', '', 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, '性能不良-加强筋拉伤/缺失', '133', '', 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, '性能不良-力学性能不良', '134', '', 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, '规格不良-型号混料', '135', '', 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, '规格不良-系统与实物不符', '136', '', 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报告有误', '137', '', 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, '包装不良-包装破损/变形/脏污', '138', '', 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, '包装不良-打包方式错误', '139', '', 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, '包装不良-标签/标识问题', '140', '', 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, '包装不良-超保质期', '141', '', 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, '包装不良-标签与实物不符', '142', '', 43, 1, '生产', '2025-11-27 10:51:48', NULL, NULL);