| 明细级 | 按单据号逐笔比对，定位到单 |
|---|---|
| 汇总级 | 按日与维度汇总比对 |
| 差异分类 | 时延、口径、真实错账 |
| 闭环 | 差异工单跟踪至关闭 |
明细级对账
明细级对账
SELECT a.order_id, a.pay_amount AS dw_amt, b.pay_amount AS biz_amt
FROM dwd_trade_order_di a
FULL OUTER JOIN ods_biz_order b ON a.order_id = b.order_id AND a.dt = b.dt
WHERE a.dt = '2026-10-11'
AND (a.order_id IS NULL OR b.order_id IS NULL OR ABS(a.pay_amount - b.pay_amount) > 0.01)
LIMIT 100;对账差异要先分类再处理：把时延差异（跨天入账）与真实错账分开，能显著减少无效排查。