| | |
| | | ('2046', 'MES 维修工单状态', 'mes_dv_repair_status', '0', 'MES 设备管理 - 维修工单状态(10=待维修,20=维修中,30=已完成,40=已验收)', '1', '2026-02-20 10:56:24', '1', '2026-02-20 10:56:24', X'00', NULL), |
| | | ('2047', 'MES 维修结果', 'mes_dv_repair_result', '0', 'MES 设备管理 - 维修结果(1=修复成功,2=报废)', '1', '2026-02-20 10:56:24', '1', '2026-02-20 10:56:24', X'00', NULL), |
| | | ('2049', 'MES 检测结果', 'mes_qc_check_result', '0', '来料检验的最终结果判定', '1', '2026-02-20 11:23:35', '1', '2026-02-20 11:23:35', X'00', NULL), |
| | | ('1065400', 'MES 出货检验检测结果', 'mes_oqc_check_result', '0', '出货检验单(OQC)判定结果:1型/2型为可发货等级,废品不放行', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00', NULL), |
| | | ('2050', 'MES 来源单据类型', 'mes_qc_source_doc_type', '0', 'IQC 来料检验的来源单据类型', '1', '2026-02-20 11:23:35', '1', '2026-02-20 11:23:35', X'00', NULL), |
| | | ('2051', 'MES 安灯处置状态', 'mes_pro_andon_status', '0', 'MES 生产管理 - 安灯处置状态(0=未处置,1=已处置)', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00', NULL), |
| | | ('2052', 'MES 安灯级别', 'mes_pro_andon_level', '0', 'MES 生产管理 - 安灯级别(1=一级,2=二级,3=三级)', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00', NULL), |
| | |
| | | ('3158', '2', '报废', '2', 'mes_dv_repair_result', '0', 'danger', '', '', '1', '2026-02-20 10:56:24', '1', '2026-02-20 10:56:24', X'00'), |
| | | ('3161', '1', '校验通过', '1', 'mes_qc_check_result', '0', 'success', '', '', '1', '2026-02-20 11:23:35', '1', '2026-02-20 16:15:54', X'00'), |
| | | ('3162', '2', '校验不通过', '2', 'mes_qc_check_result', '0', 'danger', '', '', '1', '2026-02-20 11:23:35', '1', '2026-02-20 16:15:52', X'00'), |
| | | ('1065401', '1', '1型', '1', 'mes_oqc_check_result', '0', 'success', '', '', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00'), |
| | | ('1065402', '2', '2型', '2', 'mes_oqc_check_result', '0', 'primary', '', '', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00'), |
| | | ('1065403', '3', '废品', '3', 'mes_oqc_check_result', '0', 'danger', '', '', '1', '2026-09-22 00:00:00', '1', '2026-09-22 00:00:00', X'00'), |
| | | ('3166', '0', '未处置', '0', 'mes_pro_andon_status', '0', 'danger', '', '', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00'), |
| | | ('3167', '1', '已处置', '1', 'mes_pro_andon_status', '0', 'success', '', '', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00'), |
| | | ('3168', '1', '一级', '1', 'mes_pro_andon_level', '0', 'danger', '', '', '1', '2026-02-21 00:08:38', '1', '2026-02-21 00:08:38', X'00'), |
| | |
| | | `source_doc_id` bigint DEFAULT NULL COMMENT '来源单据编号', |
| | | `source_line_id` bigint DEFAULT NULL COMMENT '来源单据行编号', |
| | | `source_doc_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '来源单据编号', |
| | | `work_order_id` bigint DEFAULT NULL COMMENT '生产工单编号', |
| | | `task_id` bigint DEFAULT NULL COMMENT '生产任务编号', |
| | | `workstation_id` bigint DEFAULT NULL COMMENT '工位编号', |
| | | `process_id` bigint DEFAULT NULL COMMENT '工序编号', |
| | | `batch_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '批号', |
| | | `item_id` bigint DEFAULT NULL COMMENT '产品物料编号', |
| | | `check_quantity` decimal(24,6) DEFAULT NULL COMMENT '检测数量', |
| | | `qualified_quantity` decimal(24,6) DEFAULT NULL COMMENT '合格品数量', |