### 0. Summary ###
  ['字段映射对照表 v3 · v5 Master 82 列 → 流程节点']
  ['Aligned with Master_Metadata_v5.xlsx (82 cols, 172 rows)']
  ['⚠️ v3 关键变更 (vs v2)']
  ['  1. Schema 扩展', '81 → 82 列 (新增 Placeholder SN (orig))']
  ['  2. 映射回归', '10 字段从 07 RECEIVED 移回 01 PO_CREATED']
  ['  3. 移除 origin/primary 分离', '简化为单一 primary 节点']
  ['  4. 承认数据现实', 'v4 数据里 67 条在途记录已有 FF SN']
  ['  5. Sherry 跟进路径', '通过 Master 占位行直接跟进每台进度']
  ['字段映射规则 (v3)']
  ['  ★ 主写节点 (primary)', '字段第一次被写入 Master 的地方']
  ['  ○ 只读引用 (read)', '该节点会显示/用到这个字段，但不修改']
  ['  multi (跨节点)', '字段在多个节点都会更新（如 Lifecycle Status）']
  ['  GLOBAL (系统)', '由系统自动维护，不归属任何业务节点']
  ['占位 SN 命名标准']
  ['  推荐格式', '{PO#}-LINE-{NNN}']
  ['  示例', 'PO-2026-Q1-03-LINE-001']
  ['  激活机制', '07 RECEIVED 时系统替换为正式 FF SN，原值存于 Placeholder SN (orig) 列']
  ['  适用范围', '未来按此标准命名的新 PO；现有 172 行的 Placeholder SN (orig) 默认 NULL']
  ['统计']
  ['  Master 字段总数', '82']
  ['  新增字段 (vs v4)', '1 (Placeholder SN (orig))']
  ['  流程节点总数', '29']
  ['  主写聚集点', '16']
  ['  跨节点字段 (multi)', '5']
  ['  系统管理字段 (GLOBAL)', '3']
  ['使用说明']
  ['  Sheet 1. Field → Node', '按字段查：每个 Master 列对应哪个节点']
  ['  Sheet 2. Node → Fields', '按节点查：每个节点 owns 哪些字段']
  ['  Sheet 3. Matrix view', '矩阵图：行=字段，列=节点，★=主写，○=只读引用']
  ['  Sheet 4. 版本演进', 'v1 → v2 → v3 的修正历史']

### 1. Field → Node ###
  ['#', 'Master 列名', '主写节点', '主写节点名称', '只读引用节点', '中文标签', '说明']
  ['1', 'FF SN (key)', '01', 'PO_CREATED', '全节点引用', 'FF 内部序列号(主键)', 'PO 阶段分配 FF SN（占位 SN 可用 {PO#}-LINE-{NNN}）']
  ['2', 'Supplier SN', '07', 'RECEIVED', '全节点引用', '供应商序列号', '收货时扫描供应商物理标签录入（也可能 03 出厂时供应商已分配）']
  ['3', 'FF SN', '01', 'PO_CREATED', '全节点引用', 'FF 内部序列号', 'PO 阶段分配']
  ['4', 'Placeholder SN (orig)', '01', 'PO_CREATED', '07', '占位 SN（历史）', '[v5 NEW] PO 阶段如使用 {PO#}-LINE-{NNN}，激活时正式 SN 存于此列保留追溯']
  ['5', 'Customer', '12', 'RESERVED', '全节点引用', '客户', 'Reserved 时分配（销售订单分配机器人个体给客户）']
  ['6', 'Model (full)', '01', 'PO_CREATED', '全节点引用', '型号', 'PO 时确定，下单后即写入']
  ['7', 'Variant (aux)', '01', 'PO_CREATED', '全节点引用', '型号变体', 'PO 时确定']
  ['8', 'Status (Build)', 'multi', '⚡ 跨节点（多处更新）', '01,02,03,07,FT,10,11,21', '状态(Build)', 'Ordered→WIP→Ready→Received→Hold (随节点变化)']
  ['9', 'Issue', '08', 'AT_W1_PDI', '11,18', '问题(Issue)', '初检发现的问题']
  ['10', 'Notes / Comments', 'multi', '⚡ 跨节点（多处更新）', '全节点引用', '备注', '通用 — 各节点都可能写；07 RECEIVED 激活占位行时记录激活时间']
  ['11', 'Specialist', '11', 'BRANDED_READY', '15', '负责 Specialist', 'W4 入库时分配']
  ['12', 'sticker', '03', 'READY_TO_SHIP', '09,10', '合规贴纸', '预贴部分在 03，剩余在 09 改装']
  ['13', 'Date ready', '03', 'READY_TO_SHIP', '11', '可售日期', '工厂可发运时设置']
  ['14', 'Lifecycle Status', 'multi', '⚡ 跨节点（多处更新）', '全节点引用', '生命周期状态', 'Ordered→In Transit→Bonded→In Stock→Reserved→Delivered→Repair']
  ['15', 'Location', 'multi', '⚡ 跨节点（多处更新）', '全节点引用', '当前位置', 'China→FTZ→HQ→W1/W2/W3→W4→W5/W6→客户处']
  ['16', 'Usage Type', '01', 'PO_CREATED', '16', '用途分类', 'PO 时确定（影响 W2/W3 分流）']
  ['17', 'Issue Tag', '08', 'AT_W1_PDI', '11,18', '问题标签']
  ['18', 'PO (merged)', '01', 'PO_CREATED', '02,03', '采购单号(PO)', '采购单号']
  ['19', 'Purchase Date', '01', 'PO_CREATED', '02,03', '采购日期']
  ['20', 'Partner / Supplier', '01', 'PO_CREATED', '全节点引用', '采购合作方']
  ['21', 'Purchase Price', '01', 'PO_CREATED', '02,03,15', '采购价', '成本核算用']
  ['22', 'Arrival Date', '04', 'IN_TRANSIT', '07', '到货日期']
  ['23', 'Logistics Status', '04', 'IN_TRANSIT', '05,06', '物流状态']
  ['24', 'Sales Order ID', '12', 'RESERVED', '全节点引用', '销售订单号', 'D365 创建 SO 时生成']
  ['25', 'Delivery Number', '14', 'READY_FOR_DELIVERY', '15', '交付单号']
  ['26', 'Sales Price - Hardware', '12', 'RESERVED', '15', '销售价-硬件']
  ['27', 'Sales Price - Software', '12', 'RESERVED', '15', '销售价-软件']
  ['28', 'Mentor', '12', 'RESERVED', '—', '导师(Mentor)']
  ['29', 'Mentee', '12', 'RESERVED', '—', '学员(Mentee)']
  ['30', 'Contract Status', '12', 'RESERVED', '13', '合同状态']
  ['31', 'Payment Method', 'P6.1', 'Payment_Collected', '13,17', '付款方式', 'P6.1 登记 / 17 节点 Lease']
  ['32', 'Payment', 'P6.1', 'Payment_Collected', '13', '收款状态', 'Paid / Not Paid Yet']
  ['33', 'Payment & Contract (PreDel)', '13', 'PAYMENT_VALIDATED', '14', '交付前付款合同状态']
  ['34', 'Physical Product Status', '11', 'BRANDED_READY', '15,RR', '物理状态', 'BRANDED_READY→Stored, DELIVERED→Delivered']
  ['35', 'Days Ready for Delivery', '11', 'BRANDED_READY', '14,15', '可交付天数', '从 Date Ready 自动计算']
  ['36', 'Delivery Request Type', '14', 'READY_FOR_DELIVERY', '15', '交付方式', 'Will Call / 3PL / White Glove']
  ['37', 'Expected Delivery Date', '14', 'READY_FOR_DELIVERY', '15', '预计交付日期']
  ['38', 'Delivery Date', '15', 'DELIVERED', '—', '交付时间']
  ['39', 'Delivery Status', 'multi', '⚡ 跨节点（多处更新）', '14,15,DA', '交付状态', '按节点变化']
  ['40', 'Delivery Signed Form', 'DA', 'Delivery_Approval', '15', '签字表状态']
  ['41', 'Delivery Acceptance Form (Pre-Del)', 'DA', 'Delivery_Approval', '15', '验收表']
  ['42', 'Delivery Acceptance Form Status (Sales)', 'DA', 'Delivery_Approval', '15', '验收表状态(Sales)']
  ['43', 'Deliver Acception Form Hyperlink', 'DA', 'Delivery_Approval', '15', '验收表链接']
  ['44', "Add'l Notes (Shipping)", '04', 'IN_TRANSIT', '15', '运输备注']
  ['45', 'Note (Pre-Del)', 'DA', 'Delivery_Approval', '15', '交付前备注']
  ['46', 'FCC Status', '06', 'CUSTOMS_CLEARED', '09', 'FCC 状态', '清关时核验']
  ['47', 'Import Declaration Type', '04', 'IN_TRANSIT', '06', '进口申报类型', '物流操作填写']
  ['48', 'Tariff Type', '04', 'IN_TRANSIT', '06', '关税类型', '物流操作填写']
  ['49', 'Compliance Notes', '05', 'BONDED', '09', '合规备注', '保税阶段记录']
  ['50', 'Cost', '15', 'DELIVERED', '—', '成本', 'PGI 时确认']
  ['51', 'Gross Margin', '15', 'DELIVERED', '—', '毛利']
  ['52', 'Revenue Recognition', '15', 'DELIVERED', '—', '收入确认']
  ['53', 'Invoice Status', '15', 'DELIVERED', '—', '开票状态']
  ['54', 'Warranty Status', '15', 'DELIVERED', '18,19', '保修状态', 'DELIVERED 时激活']
  ['55', 'Service Records', 'ST', 'Support_Ticket', '18,19', '服务记录']
  ['56', 'Customer Feedback', 'ST', 'Support_Ticket', '—', '客户反馈']
  ['57', 'Robotics Sales Agreement Link', '12', 'RESERVED', '—', '机器人销售协议链接']
  ['58', 'Deposit Transfer Form Link', 'P6.1', 'Payment_Collected', '—', '定金转账单链接']
  ['59', 'Deposit Transfer Contract Link - Car', 'P6.1', 'Payment_Collected', '—', '定金转账合约链接 汽车']
  ['60', 'Superone Cocreation Contract', '12', 'RESERVED', '—', '共创合约 Superone']
  ['61', 'Robotic Cocreation Contract', '12', 'RESERVED', '—', '机器人共创合约']
  ['62', 'Shipping Receipts', '04', 'IN_TRANSIT', '15', '运输收据链接']
  ['63', 'Label, body - FCC', '09', 'UNDER_MODIFICATION', '11', '机身 FCC 标']
  ['64', 'Label, body Made in CN', '09', 'UNDER_MODIFICATION', '11', '机身 Made in CN 标']
  ['65', 'Label, SN Body', '09', 'UNDER_MODIFICATION', '11', '机身 SN 标']
  ['66', 'Label, SN remote', '09', 'UNDER_MODIFICATION', '11', '遥控器 SN 标']
  ['67', 'Label, Battery SN', '09', 'UNDER_MODIFICATION', '11', '电池 SN 标']
  ['68', 'Label, Inspection Sheet', '09', 'UNDER_MODIFICATION', '11', '检验单标']
  ['69', 'Label, Shipping box', '09', 'UNDER_MODIFICATION', '11', '出货箱标']
  ['70', 'Robot', '11', 'BRANDED_READY', '—', '机器人主机', '配件清点']
  ['71', 'Battery', '11', 'BRANDED_READY', '—', '电池', '配件清点']
  ['72', 'Remote', '11', 'BRANDED_READY', '—', '遥控器', '配件清点']
  ['73', 'USA Power cable', '11', 'BRANDED_READY', '—', '美式电源线', '配件清点']
  ['74', 'CN cable w adapter', '11', 'BRANDED_READY', '—', '中式带转接线', '配件清点']
  ['75', 'Power supply', '11', 'BRANDED_READY', '—', '电源', '配件清点']
  ['76', 'Charging dock', '11', 'BRANDED_READY', '—', '充电底座', '配件清点']
  ['77', 'foot pads', '11', 'BRANDED_READY', '—', '脚垫', '配件清点']
  ['78', 'tools/ spare kit', '11', 'BRANDED_READY', '—', '工具/备件包', '配件清点']
  ['79', 'paperwork', '11', 'BRANDED_READY', '—', '文件资料', '配件清点']
  ['80', 'Sources', 'GLOBAL', '🛠 系统全局', '—', '数据来源', '系统自动记录']
  ['81', 'Conflict Count', 'GLOBAL', '🛠 系统全局', '—', '字段冲突计数', '系统自动']
  ['82', 'Record Status', 'GLOBAL', '🛠 系统全局', '—', '记录状态', 'OK / Conflict']

### 2. Node → Fields ###
  ['节点序号', '节点名称', '字段数', '字段列表']
  ['01', 'PO_CREATED', '10', 'FF SN (key), FF SN, Placeholder SN (orig), Model (full), Variant (aux), Usage Type, PO (merged), Purchase Date, Purchase Price, Partner / Supplier']
  ['03', 'READY_TO_SHIP', '2', 'Date ready, sticker']
  ['04', 'IN_TRANSIT', '6', "Arrival Date, Logistics Status, Tariff Type, Import Declaration Type, Add'l Notes (Shipping), Shipping Receipts"]
  ['05', 'BONDED', '1', 'Compliance Notes']
  ['06', 'CUSTOMS_CLEARED', '1', 'FCC Status']
  ['07', 'RECEIVED', '1', 'Supplier SN']
  ['08', 'AT_W1_PDI', '2', 'Issue, Issue Tag']
  ['09', 'UNDER_MODIFICATION', '7', 'Label, body - FCC, Label, body Made in CN, Label, SN Body, Label, SN remote, Label, Battery SN, Label, Inspection Sheet, Label, Shipping box']
  ['11', 'BRANDED_READY', '13', 'Physical Product Status, Specialist, Robot, Battery, Remote, USA Power cable, CN cable w adapter, Power supply, Charging dock, foot pads, tools/ spare kit, paperwork, Days Ready for Delivery']
  ['12', 'RESERVED', '10', 'Customer, Sales Order ID, Contract Status, Mentor, Mentee, Sales Price - Hardware, Sales Price - Software, Robotics Sales Agreement Link, Superone Cocreation Contract, Robotic Cocreation Contract']
  ['13', 'PAYMENT_VALIDATED', '1', 'Payment & Contract (PreDel)']
  ['P6.1', 'Payment_Collected', '4', 'Payment Method, Payment, Deposit Transfer Form Link, Deposit Transfer Contract Link - Car']
  ['14', 'READY_FOR_DELIVERY', '3', 'Delivery Request Type, Delivery Number, Expected Delivery Date']
  ['DA', 'Delivery_Approval', '5', 'Delivery Signed Form, Delivery Acceptance Form (Pre-Del), Delivery Acceptance Form Status (Sales), Deliver Acception Form Hyperlink, Note (Pre-Del)']
  ['15', 'DELIVERED', '6', 'Delivery Date, Cost, Gross Margin, Revenue Recognition, Invoice Status, Warranty Status']
  ['ST', 'Support_Ticket', '2', 'Service Records, Customer Feedback']
  ['multi', '⚡ 跨节点（多处更新）', '5', 'Status (Build), Lifecycle Status, Location, Delivery Status, Notes / Comments']
  ['GLOBAL', '🛠 系统全局', '3', 'Sources, Conflict Count, Record Status']

### 3. Matrix view ###
  ['Master 列名', '01', '02', '03', '04', '05', '06', '07', '08', 'FT', '09', '10', '11', '12', 'P6.1', '13', '14', 'DA', 'DV', '15', '16', '17', 'ST', 'RI', 'RR', 'W6', '18', '19', 'QA', '21', 'multi', 'GLOBAL']
  ['FF SN (key)', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Supplier SN', '○', '○', '○', '○', '○', '○', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['FF SN', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Placeholder SN (orig)', '★', '○']
  ['Customer', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Model (full)', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Variant (aux)', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Status (Build)', '○', '○', '○', '○', '○', '○', '○', '○', '★']
  ['Issue', '★', '○', '○']
  ['Notes / Comments', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '★']
  ['Specialist', '★', '○']
  ['sticker', '★', '○', '○']
  ['Date ready', '★', '○']
  ['Lifecycle Status', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '★']
  ['Location', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '★']
  ['Usage Type', '★', '○']
  ['Issue Tag', '★', '○', '○']
  ['PO (merged)', '★', '○', '○']
  ['Purchase Date', '★', '○', '○']
  ['Partner / Supplier', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Purchase Price', '★', '○', '○', '○']
  ['Arrival Date', '★', '○']
  ['Logistics Status', '★', '○', '○']
  ['Sales Order ID', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '★', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○', '○']
  ['Delivery Number', '★', '○']
  ['Sales Price - Hardware', '★', '○']
  ['Sales Price - Software', '★', '○']
  ['Mentor', '★']
  ['Mentee', '★']
  ['Contract Status', '★', '○']
  ['Payment Method', '★', '○', '○']
  ['Payment', '★', '○']
  ['Payment & Contract (PreDel)', '★', '○']
  ['Physical Product Status', '★', '○', '○']
  ['Days Ready for Delivery', '★', '○', '○']
  ['Delivery Request Type', '★', '○']
  ['Expected Delivery Date', '★', '○']
  ['Delivery Date', '★']
  ['Delivery Status', '○', '○', '○', '★']
  ['Delivery Signed Form', '★', '○']
  ['Delivery Acceptance Form (Pre-Del)', '★', '○']
  ['Delivery Acceptance Form Status (Sales)', '★', '○']
  ['Deliver Acception Form Hyperlink', '★', '○']
  ["Add'l Notes (Shipping)", '★', '○']
  ['Note (Pre-Del)', '★', '○']
  ['FCC Status', '★', '○']
  ['Import Declaration Type', '★', '○']
  ['Tariff Type', '★', '○']
  ['Compliance Notes', '★', '○']
  ['Cost', '★']
  ['Gross Margin', '★']
  ['Revenue Recognition', '★']
  ['Invoice Status', '★']
  ['Warranty Status', '★', '○', '○']
  ['Service Records', '★', '○', '○']
  ['Customer Feedback', '★']
  ['Robotics Sales Agreement Link', '★']
  ['Deposit Transfer Form Link', '★']
  ['Deposit Transfer Contract Link - Car', '★']
  ['Superone Cocreation Contract', '★']
  ['Robotic Cocreation Contract', '★']
  ['Shipping Receipts', '★', '○']
  ['Label, body - FCC', '★', '○']
  ['Label, body Made in CN', '★', '○']
  ['Label, SN Body', '★', '○']
  ['Label, SN remote', '★', '○']
  ['Label, Battery SN', '★', '○']
  ['Label, Inspection Sheet', '★', '○']
  ['Label, Shipping box', '★', '○']
  ['Robot', '★']
  ['Battery', '★']
  ['Remote', '★']
  ['USA Power cable', '★']
  ['CN cable w adapter', '★']
  ['Power supply', '★']
  ['Charging dock', '★']
  ['foot pads', '★']
  ['tools/ spare kit', '★']
  ['paperwork', '★']
  ['Sources', '★']
  ['Conflict Count', '★']
  ['Record Status', '★']

### 4. 版本演进 ###
  ['版本', 'FF SN / Supplier SN 主写', 'PO header 字段主写', '新增列', '记录数', '修正原因']
  ['v1 (初版)', '01 PO_CREATED', '01 PO_CREATED', '—', '—', '基于流程图直观映射']
  ['v2 (用户纠正 1)', '07 RECEIVED', '07 RECEIVED (origin=01)', '—', '—', 'PO 时机器人个体还不存在，Master 行尚未创建']
  ['v3 (当前)', '01 (FF SN) / 07 (Supplier SN)', '01 PO_CREATED', 'Placeholder SN (orig) 🆕', '172 → 172', 'Sherry 需要在 PO 阶段跟进每台进度 → 方案 C (一表到底)；v4 数据现实：67 条在途记录已有 FF SN']