maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmetrics

metric_ap_aging

beta
metric table

Open AP totals by aging bucket and vendor segment.

Lineage Builds
Definition

Open accounts-payable totals bucketed by overdue band and vendor payment-terms segment, as of a snapshot day. `open_amount` is the remaining functional-USD balance owed to vendors.

What it means
Watch out for
  • highMixing as_of_day snapshots

    Each as_of_day is a full snapshot of open AP. Summing across snapshots double-counts the same balance — filter to one as_of_day.

  • mediumTreating vendors_count as additive across buckets

    vendors_count is distinct per bucket; a vendor with bills in two buckets counts in each.

Questions this answers
  • “How much AP is more than 90 days overdue?”
  • “Open AP by aging bucket for the latest snapshot.”
Related metrics
  • ar_aging

    The receivables counterpart; pair for a working-capital view.

6 of 6
Column
Type
Description
Tests · PII
as_of_day
Date
Snapshot day. Date. Grain + sort key.
1 test
aging_bucket
String
current / 1_30 / 31_60 / 61_90 / 90_plus. Dimension.
1 test
vendor_segment
String
Vendor payment-terms class (coarse, non-identifying). Dimension.
1 test
open_bills
UInt64
Open bills in the bucket. UInt64.
1 test
vendors_count
UInt64
Distinct vendors in the bucket. UInt64.
1 test
open_amount
Decimal(18, 2)
Open functional-USD balance in the bucket. Decimal(18,2).
1 test