| 分子 | 已收（到账日） |
|---|---|
| 分母 | 应收（账期） |
| 账龄 | 逾期分段 |
账龄分布
账龄分布
SELECT CASE WHEN overdue_days <= 30 THEN '0-30'
WHEN overdue_days <= 60 THEN '31-60'
WHEN overdue_days <= 90 THEN '61-90' ELSE '90+' END AS bucket,
sum(open_amt) AS open_amt
FROM fact_receivable
GROUP BY 1;跨期收款做账期维度与到账时间维度两个视角，避免归属争议。