{
  "page": {
    "slug": "ruide-reconciliation-huimao-v1",
    "project_key": "ruide-ai",
    "customer": "瑞德智能",
    "domain": "财务对账 / ODS 业务演示",
    "title": "瑞德智能 · 辉贸客户对账演示",
    "subtitle": "基于瑞德 ODS 的客户销售对账样例，展示从业务表头到差异结论的 SQL 化页面。",
    "version_label": "v1 · 辉贸客户对账",
    "audience": "customer",
    "renderer": "standard_presentation",
    "status": "published",
    "payload": {
      "blocks": [
        {
          "id": 1,
          "props": {
            "badge": "瑞德智能 · ODS 业务演示 · 客户对账",
            "metrics": [
              {
                "label": "演示明细",
                "value": "6 行"
              },
              {
                "label": "未开票数量",
                "value": "602"
              },
              {
                "label": "对账金额",
                "value": "14766.40"
              },
              {
                "label": "差异金额",
                "value": "842.90"
              }
            ],
            "summary": "对账逻辑不写死在 HTML 里，而是由 SQL 表中的字段映射、计算规则和样例行驱动。"
          },
          "title": "从 ODS 销售明细到客户对账结论",
          "subtitle": "把客户给出的 Excel 表头沉淀为可查询、可复算、可渲染的 SQL 页面资产。",
          "block_type": "hero",
          "sort_order": 10
        },
        {
          "id": 2,
          "props": {
            "rows": [
              {
                "remark": "历史遗留",
                "line_no": 1,
                "currency": "RMB",
                "order_no": "2201-20211221019-0001",
                "difference": "18.60",
                "risk_level": "中",
                "unit_price": "23.50",
                "order_month": "202112",
                "price_delta": "0.05",
                "price_issue": "单价不一致",
                "product_code": "122741070000",
                "product_name": "风扇套件",
                "customer_code": "10500702",
                "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
                "specification": "HS-DR-HTF005-DC-RoHS",
                "april_unit_price": "23.45",
                "march_unit_price": "23.45",
                "product_category": "风扇",
                "transaction_date": "2022-01-21",
                "transaction_type": "销货",
                "customer_order_no": "2021110488",
                "invoiced_quantity": "0",
                "customer_short_name": "辉贸",
                "uninvoiced_quantity": "372",
                "transaction_order_no": "2301-20220121002-0001",
                "transaction_quantity": "372",
                "customer_product_code": "",
                "customer_product_name": "风扇套件",
                "reconciliation_amount": "8723.40",
                "customer_specification": "HS-DR-HTF005-DC-RoHS",
                "reconciliation_quantity": "372",
                "reconciliation_unit_price": "23.45"
              },
              {
                "remark": "历史遗留",
                "line_no": 2,
                "currency": "RMB",
                "order_no": "2201-20220210015-0001",
                "difference": "1.60",
                "risk_level": "低",
                "unit_price": "7.80",
                "order_month": "202202",
                "price_delta": "0.80",
                "price_issue": "单价不一致",
                "product_code": "122741090000",
                "product_name": "风扇显示板",
                "customer_code": "10500702",
                "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
                "specification": "HS-DR-HTF005-DC-RoHS",
                "april_unit_price": "7.00",
                "march_unit_price": "7.00",
                "product_category": "风扇",
                "transaction_date": "2022-03-23",
                "transaction_type": "销货",
                "customer_order_no": "2021110488",
                "invoiced_quantity": "40",
                "customer_short_name": "辉贸",
                "uninvoiced_quantity": "2",
                "transaction_order_no": "2301-20220323003-0005",
                "transaction_quantity": "42",
                "customer_product_code": "EL000000H0060",
                "customer_product_name": "风扇显示板",
                "reconciliation_amount": "14.00",
                "customer_specification": "HS-DR-HTF005-DC-RoHS",
                "reconciliation_quantity": "2",
                "reconciliation_unit_price": "7.00"
              },
              {
                "remark": "历史遗留",
                "line_no": 3,
                "currency": "RMB",
                "order_no": "220Z-20220214039-0001",
                "difference": "2.00",
                "risk_level": "低",
                "unit_price": "23.50",
                "order_month": "202202",
                "price_delta": "0.05",
                "price_issue": "单价不一致",
                "product_code": "122741070000",
                "product_name": "风扇套件",
                "customer_code": "10500702",
                "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
                "specification": "HS-DR-HTF005-DC-RoHS",
                "april_unit_price": "23.45",
                "march_unit_price": "23.45",
                "product_category": "风扇",
                "transaction_date": "2022-06-20",
                "transaction_type": "销货",
                "customer_order_no": "2021110488",
                "invoiced_quantity": "0",
                "customer_short_name": "辉贸",
                "uninvoiced_quantity": "40",
                "transaction_order_no": "2301-20220620006-0001",
                "transaction_quantity": "40",
                "customer_product_code": "",
                "customer_product_name": "风扇套件",
                "reconciliation_amount": "938.00",
                "customer_specification": "HS-DR-HTF005-DC-RoHS",
                "reconciliation_quantity": "40",
                "reconciliation_unit_price": "23.45"
              },
              {
                "remark": "历史遗留",
                "line_no": 4,
                "currency": "RMB",
                "order_no": "2201-20220519016-0001",
                "difference": "506.30",
                "risk_level": "高",
                "unit_price": "31.15",
                "order_month": "202205",
                "price_delta": "4.15",
                "price_issue": "单价不一致",
                "product_code": "122741680000",
                "product_name": "风扇电源板",
                "customer_code": "10500702",
                "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
                "specification": "HS-DR-HTF007-WIFI-RoHS",
                "april_unit_price": "27.00",
                "march_unit_price": "27.00",
                "product_category": "风扇",
                "transaction_date": "2022-06-20",
                "transaction_type": "销货",
                "customer_order_no": "2022050269",
                "invoiced_quantity": "0",
                "customer_short_name": "辉贸",
                "uninvoiced_quantity": "122",
                "transaction_order_no": "2301-20220620006-0007",
                "transaction_quantity": "122",
                "customer_product_code": "EL000000H0110",
                "customer_product_name": "风扇电源板",
                "reconciliation_amount": "3294.00",
                "customer_specification": "HS-DR-HTF007-WIFI-RoHS",
                "reconciliation_quantity": "122",
                "reconciliation_unit_price": "27.00"
              },
              {
                "remark": "历史遗留",
                "line_no": 5,
                "currency": "RMB",
                "order_no": "2201-20220519016-0001",
                "difference": "149.40",
                "risk_level": "高",
                "unit_price": "31.15",
                "order_month": "202205",
                "price_delta": "4.15",
                "price_issue": "单价不一致",
                "product_code": "122741680000",
                "product_name": "风扇电源板",
                "customer_code": "10500702",
                "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
                "specification": "HS-DR-HTF007-WIFI-RoHS",
                "april_unit_price": "27.00",
                "march_unit_price": "27.00",
                "product_category": "风扇",
                "transaction_date": "2022-06-29",
                "transaction_type": "销货",
                "customer_order_no": "2022050269",
                "invoiced_quantity": "0",
                "customer_short_name": "辉贸",
                "uninvoiced_quantity": "36",
                "transaction_order_no": "2301-20220629049-0004",
                "transaction_quantity": "36",
                "customer_product_code": "EL000000H0110",
                "customer_product_name": "风扇电源板",
                "reconciliation_amount": "972.00",
                "customer_specification": "HS-DR-HTF007-WIFI-RoHS",
                "reconciliation_quantity": "36",
                "reconciliation_unit_price": "27.00"
              },
              {
                "remark": "历史遗留",
                "line_no": 6,
                "currency": "RMB",
                "order_no": "2204-20221117002-0001",
                "difference": "165.00",
                "risk_level": "高",
                "unit_price": "33.00",
                "order_month": "202211",
                "price_delta": "5.50",
                "price_issue": "单价不一致",
                "product_code": "122743250000",
                "product_name": "风扇控制板",
                "customer_code": "10500702",
                "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
                "specification": "HS-DR-HTF007-EU-WIFI-RoHS",
                "april_unit_price": "27.50",
                "march_unit_price": "27.50",
                "product_category": "风扇",
                "transaction_date": "2022-12-01",
                "transaction_type": "销货",
                "customer_order_no": "无",
                "invoiced_quantity": "0",
                "customer_short_name": "辉贸",
                "uninvoiced_quantity": "30",
                "transaction_order_no": "2301-20221201016-0001",
                "transaction_quantity": "30",
                "customer_product_code": "EL000000H0111",
                "customer_product_name": "风扇控制板",
                "reconciliation_amount": "825.00",
                "customer_specification": "HS-DR-HTF007-EU-WIFI-RoHS",
                "reconciliation_quantity": "30",
                "reconciliation_unit_price": "27.50"
              }
            ],
            "badge": "SQL 驱动演示",
            "rules": [
              "对账数量 = 未开票数量。",
              "对账单价 = 客户确认价，本样例使用 4月单价；缺失时回退 3月单价。",
              "对账金额 = 对账数量 × 对账单价。",
              "差异 = 未开票数量 × ERP 单价 - 对账金额。",
              "风险等级按差异绝对值划分：>=100 高，>=10 中，其余低。"
            ],
            "mapping": [
              {
                "role": "对账主体",
                "ods_field": "customer_code / customer_short_name",
                "business_field": "客户编号/客户简称"
              },
              {
                "role": "业务单据定位",
                "ods_field": "transaction_date / transaction_order_no",
                "business_field": "销/退货日期/单号"
              },
              {
                "role": "物料识别",
                "ods_field": "product_code / product_name / specification",
                "business_field": "品号/品名/规格"
              },
              {
                "role": "对账数量来源",
                "ods_field": "uninvoiced_quantity",
                "business_field": "未开票数量"
              },
              {
                "role": "单价差异计算",
                "ods_field": "unit_price / march_unit_price / april_unit_price",
                "business_field": "单价/3月单价/4月单价"
              },
              {
                "role": "销售订单追溯",
                "ods_field": "order_no / customer_order_no",
                "business_field": "订单单号/客户单号"
              }
            ],
            "metrics": [
              {
                "label": "ODS 表",
                "value": "reconciliation_sales_detail"
              },
              {
                "label": "字段覆盖",
                "value": "31/31"
              },
              {
                "label": "中高风险",
                "value": "4 行"
              },
              {
                "label": "差异合计",
                "value": "842.90"
              }
            ],
            "summary": {
              "conclusion": "6 行样例中 4 行存在中高风险单价差异，差异合计 842.90 RMB；可作为财务复核清单直接下钻到销货单号和品号。"
            }
          },
          "title": "辉贸客户销售对账自动生成",
          "subtitle": "以未开票数量为对账数量，以客户确认价为对账单价，自动计算金额差异并标记风险。",
          "block_type": "reconciliation_demo",
          "sort_order": 20
        },
        {
          "id": 3,
          "props": {
            "charts": [
              {
                "note": "按品名汇总差异金额，快速定位影响最大的物料。",
                "option": {
                  "grid": {
                    "top": 42,
                    "left": 64,
                    "right": 24,
                    "bottom": 72
                  },
                  "xAxis": {
                    "data": [
                      "风扇套件",
                      "风扇显示板",
                      "风扇电源板",
                      "风扇控制板"
                    ],
                    "type": "category",
                    "axisLabel": {
                      "rotate": 25,
                      "interval": 0
                    }
                  },
                  "yAxis": {
                    "name": "差异金额",
                    "type": "value"
                  },
                  "series": [
                    {
                      "data": [
                        20.6,
                        1.6,
                        655.7,
                        165.0
                      ],
                      "name": "差异金额",
                      "type": "bar",
                      "itemStyle": {
                        "color": "#1f5eff"
                      }
                    }
                  ],
                  "tooltip": {
                    "trigger": "axis"
                  }
                }
              },
              {
                "note": "按风险等级统计异常行数，用于财务复核优先级排序。",
                "option": {
                  "legend": {
                    "bottom": 0
                  },
                  "series": [
                    {
                      "data": [
                        {
                          "name": "高",
                          "value": 3
                        },
                        {
                          "name": "中",
                          "value": 1
                        },
                        {
                          "name": "低",
                          "value": 2
                        }
                      ],
                      "name": "风险等级",
                      "type": "pie",
                      "center": [
                        "50%",
                        "45%"
                      ],
                      "radius": [
                        "42%",
                        "68%"
                      ]
                    }
                  ],
                  "tooltip": {
                    "trigger": "item"
                  }
                }
              }
            ]
          },
          "title": "对账差异图表",
          "subtitle": "ECharts 配置和数据作为 SQL block props 留存在数据库中，页面请求时动态渲染。",
          "block_type": "echarts",
          "sort_order": 30
        },
        {
          "id": 4,
          "props": {
            "after": [
              "字段映射入库",
              "计算规则入库",
              "HTML 请求时从 PostgreSQL 动态生成"
            ],
            "cards": [
              {
                "items": [
                  "DataWeave 连接：瑞德智能-模拟经营数据",
                  "Schema：ods_ruide_biz",
                  "表：reconciliation_sales_detail / reconciliation_delivery_detail"
                ],
                "title": "ODS 来源"
              },
              {
                "items": [
                  "页面 Schema：presentation_ruide_reconciliation_huimao_v1",
                  "对象：manifest / blocks / evidence / metrics / scenarios / rendered_html",
                  "公网路由：/p/ruide-reconciliation-huimao-v1/"
                ],
                "title": "SQL 页面包"
              }
            ],
            "before": [
              "Excel 表头和样例分散在文档中",
              "对账逻辑靠人工理解",
              "HTML 是一次性死页面"
            ]
          },
          "title": "这个页面如何保持活数据",
          "subtitle": "页面包、证据和渲染结果都留存在 PostgreSQL 中。",
          "block_type": "context",
          "sort_order": 30
        }
      ],
      "version": {
        "slug": "ruide-reconciliation-huimao-v1",
        "title": "瑞德智能 · 辉贸客户对账演示",
        "subtitle": "基于 ods_ruide_biz.reconciliation_sales_detail 的字段结构，演示未开票数量、对账单价、对账金额和单价差异自动识别。"
      },
      "evidence": [
        {
          "id": 1,
          "claim": "DataWeave 已通过连接 25c046f1 查询到 ods_ruide_biz.reconciliation_sales_detail 的 31 个业务字段。",
          "status": "verified",
          "payload": {
            "table": "reconciliation_sales_detail",
            "schema": "ods_ruide_biz",
            "column_count": 31
          },
          "block_id": 1,
          "source_ref": "dw query --connection-id 25c046f1... information_schema.columns",
          "source_type": "dw_query",
          "evidence_key": "dw-ods-schema"
        },
        {
          "id": 2,
          "claim": "用户提供的辉贸客户对账样例已转为可复算的 SQL 页面数据。",
          "status": "verified",
          "payload": {
            "sample_rows": 6,
            "total_difference": "842.90"
          },
          "block_id": 2,
          "source_ref": "2026-06-09 chat sample",
          "source_type": "user_sample",
          "evidence_key": "user-sample"
        }
      ]
    },
    "source_note": "dw: ods_ruide_biz.reconciliation_sales_detail + user supplied sample rows",
    "created_at": "2026-06-09 22:31:17.539038+08:00",
    "updated_at": "2026-06-09 22:37:10.650933+08:00"
  },
  "version": {
    "slug": "ruide-reconciliation-huimao-v1",
    "title": "瑞德智能 · 辉贸客户对账演示",
    "subtitle": "基于 ods_ruide_biz.reconciliation_sales_detail 的字段结构，演示未开票数量、对账单价、对账金额和单价差异自动识别。"
  },
  "blocks": [
    {
      "id": 1,
      "block_type": "hero",
      "title": "从 ODS 销售明细到客户对账结论",
      "subtitle": "把客户给出的 Excel 表头沉淀为可查询、可复算、可渲染的 SQL 页面资产。",
      "props": {
        "badge": "瑞德智能 · ODS 业务演示 · 客户对账",
        "metrics": [
          {
            "label": "演示明细",
            "value": "6 行"
          },
          {
            "label": "未开票数量",
            "value": "602"
          },
          {
            "label": "对账金额",
            "value": "14766.40"
          },
          {
            "label": "差异金额",
            "value": "842.90"
          }
        ],
        "summary": "对账逻辑不写死在 HTML 里，而是由 SQL 表中的字段映射、计算规则和样例行驱动。"
      }
    },
    {
      "id": 2,
      "block_type": "reconciliation_demo",
      "title": "辉贸客户销售对账自动生成",
      "subtitle": "以未开票数量为对账数量，以客户确认价为对账单价，自动计算金额差异并标记风险。",
      "props": {
        "rows": [
          {
            "remark": "历史遗留",
            "line_no": 1,
            "currency": "RMB",
            "order_no": "2201-20211221019-0001",
            "difference": "18.60",
            "risk_level": "中",
            "unit_price": "23.50",
            "order_month": "202112",
            "price_delta": "0.05",
            "price_issue": "单价不一致",
            "product_code": "122741070000",
            "product_name": "风扇套件",
            "customer_code": "10500702",
            "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
            "specification": "HS-DR-HTF005-DC-RoHS",
            "april_unit_price": "23.45",
            "march_unit_price": "23.45",
            "product_category": "风扇",
            "transaction_date": "2022-01-21",
            "transaction_type": "销货",
            "customer_order_no": "2021110488",
            "invoiced_quantity": "0",
            "customer_short_name": "辉贸",
            "uninvoiced_quantity": "372",
            "transaction_order_no": "2301-20220121002-0001",
            "transaction_quantity": "372",
            "customer_product_code": "",
            "customer_product_name": "风扇套件",
            "reconciliation_amount": "8723.40",
            "customer_specification": "HS-DR-HTF005-DC-RoHS",
            "reconciliation_quantity": "372",
            "reconciliation_unit_price": "23.45"
          },
          {
            "remark": "历史遗留",
            "line_no": 2,
            "currency": "RMB",
            "order_no": "2201-20220210015-0001",
            "difference": "1.60",
            "risk_level": "低",
            "unit_price": "7.80",
            "order_month": "202202",
            "price_delta": "0.80",
            "price_issue": "单价不一致",
            "product_code": "122741090000",
            "product_name": "风扇显示板",
            "customer_code": "10500702",
            "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
            "specification": "HS-DR-HTF005-DC-RoHS",
            "april_unit_price": "7.00",
            "march_unit_price": "7.00",
            "product_category": "风扇",
            "transaction_date": "2022-03-23",
            "transaction_type": "销货",
            "customer_order_no": "2021110488",
            "invoiced_quantity": "40",
            "customer_short_name": "辉贸",
            "uninvoiced_quantity": "2",
            "transaction_order_no": "2301-20220323003-0005",
            "transaction_quantity": "42",
            "customer_product_code": "EL000000H0060",
            "customer_product_name": "风扇显示板",
            "reconciliation_amount": "14.00",
            "customer_specification": "HS-DR-HTF005-DC-RoHS",
            "reconciliation_quantity": "2",
            "reconciliation_unit_price": "7.00"
          },
          {
            "remark": "历史遗留",
            "line_no": 3,
            "currency": "RMB",
            "order_no": "220Z-20220214039-0001",
            "difference": "2.00",
            "risk_level": "低",
            "unit_price": "23.50",
            "order_month": "202202",
            "price_delta": "0.05",
            "price_issue": "单价不一致",
            "product_code": "122741070000",
            "product_name": "风扇套件",
            "customer_code": "10500702",
            "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
            "specification": "HS-DR-HTF005-DC-RoHS",
            "april_unit_price": "23.45",
            "march_unit_price": "23.45",
            "product_category": "风扇",
            "transaction_date": "2022-06-20",
            "transaction_type": "销货",
            "customer_order_no": "2021110488",
            "invoiced_quantity": "0",
            "customer_short_name": "辉贸",
            "uninvoiced_quantity": "40",
            "transaction_order_no": "2301-20220620006-0001",
            "transaction_quantity": "40",
            "customer_product_code": "",
            "customer_product_name": "风扇套件",
            "reconciliation_amount": "938.00",
            "customer_specification": "HS-DR-HTF005-DC-RoHS",
            "reconciliation_quantity": "40",
            "reconciliation_unit_price": "23.45"
          },
          {
            "remark": "历史遗留",
            "line_no": 4,
            "currency": "RMB",
            "order_no": "2201-20220519016-0001",
            "difference": "506.30",
            "risk_level": "高",
            "unit_price": "31.15",
            "order_month": "202205",
            "price_delta": "4.15",
            "price_issue": "单价不一致",
            "product_code": "122741680000",
            "product_name": "风扇电源板",
            "customer_code": "10500702",
            "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
            "specification": "HS-DR-HTF007-WIFI-RoHS",
            "april_unit_price": "27.00",
            "march_unit_price": "27.00",
            "product_category": "风扇",
            "transaction_date": "2022-06-20",
            "transaction_type": "销货",
            "customer_order_no": "2022050269",
            "invoiced_quantity": "0",
            "customer_short_name": "辉贸",
            "uninvoiced_quantity": "122",
            "transaction_order_no": "2301-20220620006-0007",
            "transaction_quantity": "122",
            "customer_product_code": "EL000000H0110",
            "customer_product_name": "风扇电源板",
            "reconciliation_amount": "3294.00",
            "customer_specification": "HS-DR-HTF007-WIFI-RoHS",
            "reconciliation_quantity": "122",
            "reconciliation_unit_price": "27.00"
          },
          {
            "remark": "历史遗留",
            "line_no": 5,
            "currency": "RMB",
            "order_no": "2201-20220519016-0001",
            "difference": "149.40",
            "risk_level": "高",
            "unit_price": "31.15",
            "order_month": "202205",
            "price_delta": "4.15",
            "price_issue": "单价不一致",
            "product_code": "122741680000",
            "product_name": "风扇电源板",
            "customer_code": "10500702",
            "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
            "specification": "HS-DR-HTF007-WIFI-RoHS",
            "april_unit_price": "27.00",
            "march_unit_price": "27.00",
            "product_category": "风扇",
            "transaction_date": "2022-06-29",
            "transaction_type": "销货",
            "customer_order_no": "2022050269",
            "invoiced_quantity": "0",
            "customer_short_name": "辉贸",
            "uninvoiced_quantity": "36",
            "transaction_order_no": "2301-20220629049-0004",
            "transaction_quantity": "36",
            "customer_product_code": "EL000000H0110",
            "customer_product_name": "风扇电源板",
            "reconciliation_amount": "972.00",
            "customer_specification": "HS-DR-HTF007-WIFI-RoHS",
            "reconciliation_quantity": "36",
            "reconciliation_unit_price": "27.00"
          },
          {
            "remark": "历史遗留",
            "line_no": 6,
            "currency": "RMB",
            "order_no": "2204-20221117002-0001",
            "difference": "165.00",
            "risk_level": "高",
            "unit_price": "33.00",
            "order_month": "202211",
            "price_delta": "5.50",
            "price_issue": "单价不一致",
            "product_code": "122743250000",
            "product_name": "风扇控制板",
            "customer_code": "10500702",
            "software_name": "ODS: ods_ruide_biz.reconciliation_sales_detail",
            "specification": "HS-DR-HTF007-EU-WIFI-RoHS",
            "april_unit_price": "27.50",
            "march_unit_price": "27.50",
            "product_category": "风扇",
            "transaction_date": "2022-12-01",
            "transaction_type": "销货",
            "customer_order_no": "无",
            "invoiced_quantity": "0",
            "customer_short_name": "辉贸",
            "uninvoiced_quantity": "30",
            "transaction_order_no": "2301-20221201016-0001",
            "transaction_quantity": "30",
            "customer_product_code": "EL000000H0111",
            "customer_product_name": "风扇控制板",
            "reconciliation_amount": "825.00",
            "customer_specification": "HS-DR-HTF007-EU-WIFI-RoHS",
            "reconciliation_quantity": "30",
            "reconciliation_unit_price": "27.50"
          }
        ],
        "badge": "SQL 驱动演示",
        "rules": [
          "对账数量 = 未开票数量。",
          "对账单价 = 客户确认价，本样例使用 4月单价；缺失时回退 3月单价。",
          "对账金额 = 对账数量 × 对账单价。",
          "差异 = 未开票数量 × ERP 单价 - 对账金额。",
          "风险等级按差异绝对值划分：>=100 高，>=10 中，其余低。"
        ],
        "mapping": [
          {
            "role": "对账主体",
            "ods_field": "customer_code / customer_short_name",
            "business_field": "客户编号/客户简称"
          },
          {
            "role": "业务单据定位",
            "ods_field": "transaction_date / transaction_order_no",
            "business_field": "销/退货日期/单号"
          },
          {
            "role": "物料识别",
            "ods_field": "product_code / product_name / specification",
            "business_field": "品号/品名/规格"
          },
          {
            "role": "对账数量来源",
            "ods_field": "uninvoiced_quantity",
            "business_field": "未开票数量"
          },
          {
            "role": "单价差异计算",
            "ods_field": "unit_price / march_unit_price / april_unit_price",
            "business_field": "单价/3月单价/4月单价"
          },
          {
            "role": "销售订单追溯",
            "ods_field": "order_no / customer_order_no",
            "business_field": "订单单号/客户单号"
          }
        ],
        "metrics": [
          {
            "label": "ODS 表",
            "value": "reconciliation_sales_detail"
          },
          {
            "label": "字段覆盖",
            "value": "31/31"
          },
          {
            "label": "中高风险",
            "value": "4 行"
          },
          {
            "label": "差异合计",
            "value": "842.90"
          }
        ],
        "summary": {
          "conclusion": "6 行样例中 4 行存在中高风险单价差异，差异合计 842.90 RMB；可作为财务复核清单直接下钻到销货单号和品号。"
        }
      }
    },
    {
      "id": 3,
      "block_type": "echarts",
      "title": "对账差异图表",
      "subtitle": "ECharts 配置和数据作为 SQL block props 留存在数据库中，页面请求时动态渲染。",
      "props": {
        "charts": [
          {
            "note": "按品名汇总差异金额，快速定位影响最大的物料。",
            "option": {
              "grid": {
                "top": 42,
                "left": 64,
                "right": 24,
                "bottom": 72
              },
              "xAxis": {
                "data": [
                  "风扇套件",
                  "风扇显示板",
                  "风扇电源板",
                  "风扇控制板"
                ],
                "type": "category",
                "axisLabel": {
                  "rotate": 25,
                  "interval": 0
                }
              },
              "yAxis": {
                "name": "差异金额",
                "type": "value"
              },
              "series": [
                {
                  "data": [
                    20.6,
                    1.6,
                    655.7,
                    165.0
                  ],
                  "name": "差异金额",
                  "type": "bar",
                  "itemStyle": {
                    "color": "#1f5eff"
                  }
                }
              ],
              "tooltip": {
                "trigger": "axis"
              }
            }
          },
          {
            "note": "按风险等级统计异常行数，用于财务复核优先级排序。",
            "option": {
              "legend": {
                "bottom": 0
              },
              "series": [
                {
                  "data": [
                    {
                      "name": "高",
                      "value": 3
                    },
                    {
                      "name": "中",
                      "value": 1
                    },
                    {
                      "name": "低",
                      "value": 2
                    }
                  ],
                  "name": "风险等级",
                  "type": "pie",
                  "center": [
                    "50%",
                    "45%"
                  ],
                  "radius": [
                    "42%",
                    "68%"
                  ]
                }
              ],
              "tooltip": {
                "trigger": "item"
              }
            }
          }
        ]
      }
    },
    {
      "id": 4,
      "block_type": "context",
      "title": "这个页面如何保持活数据",
      "subtitle": "页面包、证据和渲染结果都留存在 PostgreSQL 中。",
      "props": {
        "after": [
          "字段映射入库",
          "计算规则入库",
          "HTML 请求时从 PostgreSQL 动态生成"
        ],
        "cards": [
          {
            "items": [
              "DataWeave 连接：瑞德智能-模拟经营数据",
              "Schema：ods_ruide_biz",
              "表：reconciliation_sales_detail / reconciliation_delivery_detail"
            ],
            "title": "ODS 来源"
          },
          {
            "items": [
              "页面 Schema：presentation_ruide_reconciliation_huimao_v1",
              "对象：manifest / blocks / evidence / metrics / scenarios / rendered_html",
              "公网路由：/p/ruide-reconciliation-huimao-v1/"
            ],
            "title": "SQL 页面包"
          }
        ],
        "before": [
          "Excel 表头和样例分散在文档中",
          "对账逻辑靠人工理解",
          "HTML 是一次性死页面"
        ]
      }
    }
  ],
  "evidence": [
    {
      "slug": "ruide-reconciliation-huimao-v1",
      "evidence_id": 1,
      "block_id": 1,
      "evidence_key": "dw-ods-schema",
      "claim": "DataWeave 已通过连接 25c046f1 查询到 ods_ruide_biz.reconciliation_sales_detail 的 31 个业务字段。",
      "status": "verified",
      "source_type": "dw_query",
      "source_ref": "dw query --connection-id 25c046f1... information_schema.columns",
      "payload": {
        "table": "reconciliation_sales_detail",
        "schema": "ods_ruide_biz",
        "column_count": 31
      },
      "created_at": null,
      "updated_at": "2026-06-11 08:08:16.916058+08:00"
    },
    {
      "slug": "ruide-reconciliation-huimao-v1",
      "evidence_id": 2,
      "block_id": 2,
      "evidence_key": "user-sample",
      "claim": "用户提供的辉贸客户对账样例已转为可复算的 SQL 页面数据。",
      "status": "verified",
      "source_type": "user_sample",
      "source_ref": "2026-06-09 chat sample",
      "payload": {
        "sample_rows": 6,
        "total_difference": "842.90"
      },
      "created_at": null,
      "updated_at": "2026-06-11 08:08:16.916058+08:00"
    }
  ]
}