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

mart_ap_aging

beta
mart table

Open AP per vendor bill, aged into buckets.

Lineage Builds
Definition

One row per open vendor bill as of the snapshot day, with the vendor, remaining functional-USD balance, days overdue from due_date, and aging bucket (current / 1_30 / 31_60 / 61_90 / 90_plus). Total open AP ties to the AP control account (subledger_ties_to_gl).

What it means
Watch out for
  • highSumming base_total_amount instead of open_amount

    `base_total_amount` is the original bill total; `open_amount` is the remaining unpaid balance. Aging is about what is still owed — always sum `open_amount`.

  • mediumComparing aging across different as_of_day snapshots

    Buckets are computed relative to a single snapshot day. Mixing rows from different `as_of_day` values double-counts and mis-ages.

Questions this answers
  • “Which vendors have the most past-due AP?”
  • “What is our total open AP right now?”
Related metrics
  • ap_aging

    The de-identified bucket aggregate of this snapshot.

14 of 14
Column
Type
Description
Tests · PII
as_of_day
Date
Snapshot day the aging is computed as of. Date.
1 test
vendor_id
UInt64
FK to stg_postgres__vendors.vendor_id (the vendor subject).
vendor +1 PII1 test
vendor_code
String
Short vendor code.
vendor_legal_name
String
Vendor legal (business) name.
payment_terms
String
Vendor payment terms — net_15 / net_30 / net_60 / due_on_receipt.
vendor_bill_id
UInt64
Primary key — the open bill. UInt64.
vendor +1 PII2 tests
bill_date
Date
Invoice date on the bill. Date.
due_date
Date
Payment due date. Date.
currency
String
Transaction currency.
status
String
Bill status — open / partially_paid.
base_total_amount
Decimal(14, 2)
Grand total in functional USD. Decimal(14,2).
open_amount
Decimal(14, 2)
Remaining functional-USD balance. Decimal(14,2).
1 test
days_overdue
Int64
Days past due_date as of as_of_day (0 if not yet due).
aging_bucket
String
current / 1_30 / 31_60 / 61_90 / 90_plus.
1 test