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

mart_ar_aging

beta
mart table 1 PII columns

Open AR per customer invoice, aged into buckets.

Lineage Builds PII registry
Definition

One row per open customer invoice as of the snapshot day, with the customer, remaining functional-USD balance, days overdue from due_date, and aging bucket. Total open AR ties to the AR control account (subledger_ties_to_gl).

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

    `open_amount` is the remaining unreceived balance; `base_total_amount` is the original invoice total. Aging is about what is still owed.

  • mediumReading email from an AI persona

    `email` is PII and hidden from AI personas via column grants; this mart is controller/executive-only at the row level anyway.

Questions this answers
  • “Which customers have the most past-due AR?”
  • “What is our total open AR right now?”
Related metrics
  • ar_aging

    The de-identified bucket aggregate (includes DSO).

14 of 14
Column
Type
Description
Tests · PII
as_of_day
Date
Snapshot day the aging is computed as of. Date.
1 test
customer_id
UInt64
FK to ecommerce stg_postgres__customers.customer_id.
customer +17 PII1 test
email
String
Customer email. PII — hidden from AI personas via column grants.
PII
customer_country
Nullable(String)
ISO-2 customer country. Nullable.
customer_segment
Nullable(String)
Customer segment — consumer / business / enterprise. Nullable.
customer_invoice_id
UInt64
Primary key — the open invoice. UInt64.
2 tests
invoice_date
Date
Invoice date. Date.
due_date
Date
Payment due date. Date.
currency
String
Transaction currency.
status
String
Invoice 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