AiDOPWarehouse/server/Admin.NET.Web.Entry/UpdateScripts/1.0.153.sql

-- ──────────────────────────────────────────────────────────────────────
-- S8-ORDER-CHAIN-ASSEMBLY-DELIVERY-DATA-LINEAGE-AUDIT-1
-- 在 ado_s8_order_flow_final_assembly_gate / _parallel 注入
--   baseline 行（order_id IS NULL, scenario=BASELINE_PPT）+
--   订单级 SEED 行（order_id 非 NULL, scenario=ORDER_LEVEL）。
--
-- 表 A（ado_s8_order_flow_final_assembly_gate）：
--   gate baseline 5 行 + gate order-level 15 单 × 5 门禁 = 75 行 → 80 行。
-- 表 B（ado_s8_order_flow_final_assembly_parallel）：
--   parallel baseline 4 行 + parallel order-level 15 单 × 4 准备项 = 60 行 → 64 行。
-- 合计 INSERT 144 行。pending 5 单（SO-2026-016~020）不生成 ORDER_LEVEL 行。
--
-- 业务口径（拍板）：
--   门禁 planned_offset_days = (0.6, 1.2, 1.8, 2.4, 3.0) 累计里程碑；
--   order-level actual_offset_days = planned × stage.actual_days / 3.0，
--   末位 SHIPMENT_CONFIRMATION 尾差修正 = stage.actual_days；
--   variance_days = actual - planned；status：≤0 green / ≤0.3 yellow / 否则 red。
--   parallel baseline kitting_rate = (0.9500, 0.9700, 0.9200, 0.9600)；
--   order-level：green 单保持 baseline，yellow 单 4 项统一 -0.0500；pending 不生成。
--   status：≥0.95 green / ≥0.85 yellow / 否则 red（seed 时一次固化）。
--
-- data_source='SEED' / scenario_code∈('BASELINE_PPT','ORDER_LEVEL')：
--   未来 IMPORT/AGG 接入后，service 按 (order_code, gate/prep_code) 优先 IMPORT/AGG，SEED 兜底。
-- ──────────────────────────────────────────────────────────────────────

-- 1A. 表 A 建表（条件创建，避免与既有迁移冲突）。
CREATE TABLE IF NOT EXISTS `ado_s8_order_flow_final_assembly_gate` (
  `id` BIGINT NOT NULL,
  `order_id` BIGINT NULL,
  `order_code` VARCHAR(64) NULL,
  `gate_code` VARCHAR(32) NOT NULL,
  `gate_name` VARCHAR(32) NOT NULL,
  `planned_offset_days` DECIMAL(6,3) NOT NULL,
  `actual_offset_days` DECIMAL(6,3) NULL,
  `variance_days` DECIMAL(6,3) NULL,
  `status` VARCHAR(16) NOT NULL,
  `impacted_order_count` INT NULL,
  `risk_order_count` INT NULL,
  `top_risk_type` VARCHAR(64) NULL,
  `top_risk_label` VARCHAR(255) NULL,
  `owner_side_text` VARCHAR(64) NULL,
  `sort_no` INT NOT NULL,
  `scenario_code` VARCHAR(16) NOT NULL,
  `data_source` VARCHAR(16) NOT NULL,
  `tenant_id` BIGINT NOT NULL,
  `factory_id` BIGINT NOT NULL,
  `created_at` DATETIME NOT NULL,
  `updated_at` DATETIME NULL,
  `is_deleted` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_order_flow_fa_gate_baseline` (`tenant_id`, `factory_id`, `gate_code`),
  KEY `idx_order_flow_fa_gate_order` (`tenant_id`, `factory_id`, `order_code`),
  KEY `idx_order_flow_fa_gate_scenario` (`tenant_id`, `factory_id`, `scenario_code`, `is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='S8 订单执行链路总装发货主门禁里程碑';

-- 1B. 表 B 建表。
CREATE TABLE IF NOT EXISTS `ado_s8_order_flow_final_assembly_parallel` (
  `id` BIGINT NOT NULL,
  `order_id` BIGINT NULL,
  `order_code` VARCHAR(64) NULL,
  `prep_code` VARCHAR(32) NOT NULL,
  `prep_name` VARCHAR(32) NOT NULL,
  `kitting_rate` DECIMAL(5,4) NULL,
  `status` VARCHAR(16) NOT NULL,
  `impacted_order_count` INT NULL,
  `risk_order_count` INT NULL,
  `top_risk_type` VARCHAR(64) NULL,
  `top_risk_label` VARCHAR(255) NULL,
  `owner_side_text` VARCHAR(64) NULL,
  `sort_no` INT NOT NULL,
  `scenario_code` VARCHAR(16) NOT NULL,
  `data_source` VARCHAR(16) NOT NULL,
  `tenant_id` BIGINT NOT NULL,
  `factory_id` BIGINT NOT NULL,
  `created_at` DATETIME NOT NULL,
  `updated_at` DATETIME NULL,
  `is_deleted` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_order_flow_fa_parallel_baseline` (`tenant_id`, `factory_id`, `prep_code`),
  KEY `idx_order_flow_fa_parallel_order` (`tenant_id`, `factory_id`, `order_code`),
  KEY `idx_order_flow_fa_parallel_scenario` (`tenant_id`, `factory_id`, `scenario_code`, `is_deleted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='S8 订单执行链路总装发货并行准备';

-- 2A. 表 A 幂等删除（仅 SEED + BASELINE_PPT / ORDER_LEVEL；不触碰未来 IMPORT/AGG 行）。
DELETE FROM `ado_s8_order_flow_final_assembly_gate`
WHERE `tenant_id` = 1
  AND `factory_id` = 1
  AND `is_deleted` = 0
  AND `data_source` = 'SEED'
  AND `scenario_code` IN ('BASELINE_PPT', 'ORDER_LEVEL');

-- 2B. 表 B 幂等删除。
DELETE FROM `ado_s8_order_flow_final_assembly_parallel`
WHERE `tenant_id` = 1
  AND `factory_id` = 1
  AND `is_deleted` = 0
  AND `data_source` = 'SEED'
  AND `scenario_code` IN ('BASELINE_PPT', 'ORDER_LEVEL');

-- 3A. 表 A 插入 5 baseline + 75 order-level = 80 行。
INSERT INTO `ado_s8_order_flow_final_assembly_gate` (
  `id`, `order_id`, `order_code`, `gate_code`, `gate_name`,
  `planned_offset_days`, `actual_offset_days`, `variance_days`, `status`,
  `impacted_order_count`, `risk_order_count`, `top_risk_type`, `top_risk_label`,
  `owner_side_text`, `sort_no`, `scenario_code`, `data_source`,
  `tenant_id`, `factory_id`, `created_at`, `updated_at`, `is_deleted`
) VALUES
(1329909220001, NULL, NULL, 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909220002, NULL, NULL, 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909220003, NULL, NULL, 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909220004, NULL, NULL, 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909220005, NULL, NULL, 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230001, 1329909100001, 'SO-2026-001', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230002, 1329909100001, 'SO-2026-001', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230003, 1329909100001, 'SO-2026-001', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230004, 1329909100001, 'SO-2026-001', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230005, 1329909100001, 'SO-2026-001', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230006, 1329909100002, 'SO-2026-002', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230007, 1329909100002, 'SO-2026-002', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230008, 1329909100002, 'SO-2026-002', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230009, 1329909100002, 'SO-2026-002', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230010, 1329909100002, 'SO-2026-002', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230011, 1329909100003, 'SO-2026-003', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230012, 1329909100003, 'SO-2026-003', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230013, 1329909100003, 'SO-2026-003', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230014, 1329909100003, 'SO-2026-003', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230015, 1329909100003, 'SO-2026-003', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230016, 1329909100004, 'SO-2026-004', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230017, 1329909100004, 'SO-2026-004', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230018, 1329909100004, 'SO-2026-004', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230019, 1329909100004, 'SO-2026-004', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230020, 1329909100004, 'SO-2026-004', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230021, 1329909100005, 'SO-2026-005', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230022, 1329909100005, 'SO-2026-005', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230023, 1329909100005, 'SO-2026-005', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230024, 1329909100005, 'SO-2026-005', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230025, 1329909100005, 'SO-2026-005', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230026, 1329909100006, 'SO-2026-006', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230027, 1329909100006, 'SO-2026-006', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230028, 1329909100006, 'SO-2026-006', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230029, 1329909100006, 'SO-2026-006', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230030, 1329909100006, 'SO-2026-006', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230031, 1329909100007, 'SO-2026-007', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230032, 1329909100007, 'SO-2026-007', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230033, 1329909100007, 'SO-2026-007', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230034, 1329909100007, 'SO-2026-007', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230035, 1329909100007, 'SO-2026-007', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230036, 1329909100008, 'SO-2026-008', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230037, 1329909100008, 'SO-2026-008', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230038, 1329909100008, 'SO-2026-008', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230039, 1329909100008, 'SO-2026-008', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230040, 1329909100008, 'SO-2026-008', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230041, 1329909100009, 'SO-2026-009', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230042, 1329909100009, 'SO-2026-009', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230043, 1329909100009, 'SO-2026-009', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230044, 1329909100009, 'SO-2026-009', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230045, 1329909100009, 'SO-2026-009', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230046, 1329909100010, 'SO-2026-010', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230047, 1329909100010, 'SO-2026-010', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230048, 1329909100010, 'SO-2026-010', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230049, 1329909100010, 'SO-2026-010', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230050, 1329909100010, 'SO-2026-010', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230051, 1329909100011, 'SO-2026-011', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.800, 0.200, 'yellow', 1, 0, 'ASSEMBLY_DELAY', '总装节拍偏差', '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230052, 1329909100011, 'SO-2026-011', 'QUALITY_RELEASE', '质量放行', 1.200, 1.600, 0.400, 'red', 1, 1, 'QUALITY_RELEASE_DELAY', '质量放行等待', '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230053, 1329909100011, 'SO-2026-011', 'PACKAGING_COMPLETION', '包装完成', 1.800, 2.400, 0.600, 'red', 1, 1, 'PACKAGING_DELAY', '包装完成偏差', '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230054, 1329909100011, 'SO-2026-011', 'GOODS_HANDOVER', '成品交接', 2.400, 3.200, 0.800, 'red', 1, 1, 'HANDOVER_DELAY', '成品交接等待', '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230055, 1329909100011, 'SO-2026-011', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 4.000, 1.000, 'red', 1, 1, 'SHIPMENT_DELAY', '发运确认等待', '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230056, 1329909100012, 'SO-2026-012', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230057, 1329909100012, 'SO-2026-012', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230058, 1329909100012, 'SO-2026-012', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230059, 1329909100012, 'SO-2026-012', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230060, 1329909100012, 'SO-2026-012', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230061, 1329909100013, 'SO-2026-013', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230062, 1329909100013, 'SO-2026-013', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230063, 1329909100013, 'SO-2026-013', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230064, 1329909100013, 'SO-2026-013', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230065, 1329909100013, 'SO-2026-013', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230066, 1329909100014, 'SO-2026-014', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230067, 1329909100014, 'SO-2026-014', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230068, 1329909100014, 'SO-2026-014', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230069, 1329909100014, 'SO-2026-014', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230070, 1329909100014, 'SO-2026-014', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230071, 1329909100015, 'SO-2026-015', 'ASSEMBLY_COMPLETION', '总装完工', 0.600, 0.600, 0.000, 'green', 0, 0, NULL, NULL, '总装线', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230072, 1329909100015, 'SO-2026-015', 'QUALITY_RELEASE', '质量放行', 1.200, 1.200, 0.000, 'green', 0, 0, NULL, NULL, '质量·终检', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230073, 1329909100015, 'SO-2026-015', 'PACKAGING_COMPLETION', '包装完成', 1.800, 1.800, 0.000, 'green', 0, 0, NULL, NULL, '包装线', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230074, 1329909100015, 'SO-2026-015', 'GOODS_HANDOVER', '成品交接', 2.400, 2.400, 0.000, 'green', 0, 0, NULL, NULL, '成品库', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909230075, 1329909100015, 'SO-2026-015', 'SHIPMENT_CONFIRMATION', '发运确认', 3.000, 3.000, 0.000, 'green', 0, 0, NULL, NULL, '发运协调', 50, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0);

-- 3B. 表 B 插入 4 baseline + 60 order-level = 64 行。
INSERT INTO `ado_s8_order_flow_final_assembly_parallel` (
  `id`, `order_id`, `order_code`, `prep_code`, `prep_name`,
  `kitting_rate`, `status`,
  `impacted_order_count`, `risk_order_count`, `top_risk_type`, `top_risk_label`,
  `owner_side_text`, `sort_no`, `scenario_code`, `data_source`,
  `tenant_id`, `factory_id`, `created_at`, `updated_at`, `is_deleted`
) VALUES
(1329909240001, NULL, NULL, 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909240002, NULL, NULL, 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909240003, NULL, NULL, 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 0, 0, NULL, NULL, '发运协调', 30, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909240004, NULL, NULL, 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'BASELINE_PPT', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250001, 1329909100001, 'SO-2026-001', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250002, 1329909100001, 'SO-2026-001', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250003, 1329909100001, 'SO-2026-001', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250004, 1329909100001, 'SO-2026-001', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250005, 1329909100002, 'SO-2026-002', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250006, 1329909100002, 'SO-2026-002', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250007, 1329909100002, 'SO-2026-002', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250008, 1329909100002, 'SO-2026-002', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250009, 1329909100003, 'SO-2026-003', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250010, 1329909100003, 'SO-2026-003', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250011, 1329909100003, 'SO-2026-003', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250012, 1329909100003, 'SO-2026-003', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250013, 1329909100004, 'SO-2026-004', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250014, 1329909100004, 'SO-2026-004', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250015, 1329909100004, 'SO-2026-004', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250016, 1329909100004, 'SO-2026-004', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250017, 1329909100005, 'SO-2026-005', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250018, 1329909100005, 'SO-2026-005', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250019, 1329909100005, 'SO-2026-005', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250020, 1329909100005, 'SO-2026-005', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250021, 1329909100006, 'SO-2026-006', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250022, 1329909100006, 'SO-2026-006', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250023, 1329909100006, 'SO-2026-006', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250024, 1329909100006, 'SO-2026-006', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250025, 1329909100007, 'SO-2026-007', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250026, 1329909100007, 'SO-2026-007', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250027, 1329909100007, 'SO-2026-007', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250028, 1329909100007, 'SO-2026-007', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250029, 1329909100008, 'SO-2026-008', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250030, 1329909100008, 'SO-2026-008', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250031, 1329909100008, 'SO-2026-008', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250032, 1329909100008, 'SO-2026-008', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250033, 1329909100009, 'SO-2026-009', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250034, 1329909100009, 'SO-2026-009', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250035, 1329909100009, 'SO-2026-009', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250036, 1329909100009, 'SO-2026-009', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250037, 1329909100010, 'SO-2026-010', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250038, 1329909100010, 'SO-2026-010', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250039, 1329909100010, 'SO-2026-010', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250040, 1329909100010, 'SO-2026-010', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250041, 1329909100011, 'SO-2026-011', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9000, 'yellow', 1, 0, 'PACKAGING_MATERIAL_SHORTAGE', '包装材料齐套', '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250042, 1329909100011, 'SO-2026-011', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9200, 'yellow', 1, 0, 'LABEL_DOC_PENDING', '标签随箱资料齐套', '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250043, 1329909100011, 'SO-2026-011', 'SHIPPING_PLAN', '发运计划准备', 0.8700, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250044, 1329909100011, 'SO-2026-011', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9100, 'yellow', 1, 0, 'SHIPPING_DOC_PENDING', '出货单据齐套', '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250045, 1329909100012, 'SO-2026-012', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250046, 1329909100012, 'SO-2026-012', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250047, 1329909100012, 'SO-2026-012', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250048, 1329909100012, 'SO-2026-012', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250049, 1329909100013, 'SO-2026-013', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250050, 1329909100013, 'SO-2026-013', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250051, 1329909100013, 'SO-2026-013', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250052, 1329909100013, 'SO-2026-013', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250053, 1329909100014, 'SO-2026-014', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250054, 1329909100014, 'SO-2026-014', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250055, 1329909100014, 'SO-2026-014', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250056, 1329909100014, 'SO-2026-014', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250057, 1329909100015, 'SO-2026-015', 'PACKAGING_MATERIAL_PREP', '包装材料准备', 0.9500, 'green', 0, 0, NULL, NULL, '包装线·物料', 10, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250058, 1329909100015, 'SO-2026-015', 'LABEL_DOC_PREP', '标签随箱资料准备', 0.9700, 'green', 0, 0, NULL, NULL, '技术·质量', 20, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250059, 1329909100015, 'SO-2026-015', 'SHIPPING_PLAN', '发运计划准备', 0.9200, 'yellow', 1, 0, 'SHIPPING_PLAN_PENDING', '发运计划齐套', '发运协调', 30, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0),
(1329909250060, 1329909100015, 'SO-2026-015', 'SHIPPING_DOC_PREP', '出货单据准备', 0.9600, 'green', 0, 0, NULL, NULL, '计划·商务', 40, 'ORDER_LEVEL', 'SEED', 1, 1, '2026-05-12 00:00:00', NULL, 0);