int_ap__aging

intermediate ephemeral

Open AP per bill, aged into buckets.

Definition

One row per open vendor bill 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.

vendor_bill_id

FK to stg_postgres__vendor_bills.vendor_bill_id.

vendor +1 PII

vendor_id

FK to stg_postgres__vendors.vendor_id.

vendor +1 PII

bill_date

Invoice date on the bill. Date.

due_date

Payment due date. Date.

currency

Transaction currency.

status

Bill lifecycle status (open / partially_paid).

base_total_amount

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

open_amount

Remaining functional-USD balance (unpaid 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.