int_ar__aging

intermediate ephemeral

Open AR per invoice, aged into buckets.

Definition

One row per open customer invoice with its remaining functional-USD balance, days overdue from due_date, and aging bucket (current / 1_30 / 31_60 / 61_90 / 90_plus) as of the snapshot day.

11 of 11

Column

Description

Tests · PII

as_of_day

Snapshot day the aging is computed as of. Date.

customer_invoice_id

FK to stg_postgres__customer_invoices.customer_invoice_id.

customer_id

FK to ecommerce stg_postgres__customers.customer_id.

customer +18 PII

invoice_date

Invoice date. Date.

due_date

Payment due date. Date.

currency

Transaction currency.

status

Invoice lifecycle status (open / partially_paid).

base_total_amount

Grand total in functional USD. Decimal(14,2).

open_amount

Remaining functional-USD balance (unreceived fraction of base total). Decimal(14,2).

days_overdue

Days past due_date as of as_of_day (0 if not yet due).

aging_bucket

current / 1_30 / 31_60 / 61_90 / 90_plus.