| 粒度 | 组织 x 科目 x 期间 |
|---|---|
| 版本 | 年度预算/调整/滚动预测 |
| 对比 | 实际 vs 预算差异 |
预算执行
预算执行
SELECT b.org_id, b.period, sum(a.amt) AS actual, sum(b.budget_amt) AS budget,
sum(a.amt) - sum(b.budget_amt) AS diff
FROM fact_budget b
LEFT JOIN fact_expense a
ON a.org_id = b.org_id AND a.period = b.period
WHERE b.version = 'annual'
GROUP BY b.org_id, b.period;预算科目与实际科目若有映射，映射表版本也要与期间对齐。