-- 只读排查:关联销售订单但缺少销售明细关联的历史单据,不能按物料自动猜测盘号。 -- 请在目标数据库执行并逐条核对;本脚本不修改数据。 SELECT n.id AS notice_id, n.code AS notice_code, n.sale_order_id, l.id AS notice_line_id, l.item_id, l.quantity, l.sale_order_item_id FROM mes_wm_sales_notice n JOIN mes_wm_sales_notice_line l ON l.notice_id = n.id WHERE n.deleted = b'0' AND l.deleted = b'0' AND n.sale_order_id IS NOT NULL AND l.sale_order_item_id IS NULL ORDER BY n.id, l.id; SELECT s.id AS sales_id, s.code AS sales_code, s.sale_order_id, l.id AS sales_line_id, l.notice_line_id, l.item_id, l.quantity, l.sale_order_item_id FROM mes_wm_product_sales s JOIN mes_wm_product_sales_line l ON l.sales_id = s.id WHERE s.deleted = b'0' AND l.deleted = b'0' AND s.sale_order_id IS NOT NULL AND l.sale_order_item_id IS NULL ORDER BY s.id, l.id;