maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
De-identified rollup of open AP by (as_of_day × aging_bucket × vendor_segment). vendor_segment is the vendor's payment_terms (a coarse, non-identifying class), not the vendor itself. `open_amount` is summed functional USD; `vendors_count` is a distinct vendor count.
What it means
Watch out for
- highMixing as_of_day snapshots
Each `as_of_day` is a full snapshot. Summing across snapshots double-counts the same open balance.
- mediumReading vendors_count as additive across buckets
`vendors_count` is a distinct count per bucket — a vendor with bills in two buckets counts in each. Summing across buckets over-counts distinct vendors.
Questions this answers
- “How much AP is more than 90 days overdue?”
- “Open AP by aging bucket for the latest snapshot.”
Related metrics
- ap_aging
The metric-layer surface over this aggregate.
6 of 6
Column
Type
Description
Tests · PII
as_of_day
Date
Snapshot day. Date. Part of the grain.
1 test
aging_bucket
String
current / 1_30 / 31_60 / 61_90 / 90_plus. Part of the grain.
2 tests
vendor_segment
String
Vendor payment-terms class (coarse, non-identifying). `unknown` when unmapped. Part of the grain.
1 test
open_bills
UInt64
Count of open bills in the bucket. UInt64.
1 test
vendors_count
UInt64
Distinct vendors in the bucket. UInt64.
1 test
open_amount
Decimal(18, 2)
Sum of open functional-USD balance in the bucket. Decimal(18,2).
1 test