19 of 312 nodes

Open vendor bills bucketed by days overdue as of a snapshot day. Open balance is in functional USD. Ephemeral — inlined into mart_ap_aging and mart_ap_aging_daily.

Open customer invoices bucketed by days overdue as of a snapshot day. Open balance is in functional USD. Ephemeral — inlined into mart_ar_aging and mart_ar_aging_daily.

Month-end close checklist rollup — one row per fiscal period combining the period's close status, posted/draft entry counts, the trial-balance-ties flag, and bank-reconciliation progress. Ephemeral — inlined into mart_month_end_close.

Period dimension for the finance marts. fiscal_periods is unstaged in this slice, so this reads the declared `finance_periods` source (raw_postgres) and types period_code, fiscal_year/month, start/end dates, and close status. Ephemeral — inlined into every period-grained mart.

Trial balance — debit / credit / net by (period × gl_account × cost_center) over POSTED journal lines only. Net = sum(debit) - sum(credit) (never sum both). Ephemeral — inlined into mart_gl_balances and the trial_balance_zero_per_period test.

Ephemeral join — attaches product category to each inventory snapshot. Inlined into `mart_inventory_daily` so category rollups don't re-join.

Ephemeral join — pairs each send with its campaign metadata and derives funnel-stage booleans. Inlined into `mart_marketing_engagement_daily`.

ephemeral · no description

ephemeral · no description

Ephemeral join — attaches customer attributes (country, segment, signup_date) to each order and exposes a convenience `is_revenue_order` flag. Inlined into `mart_customers`, `mart_orders_daily`, and `mart_revenue_daily` so revenue logic stays consistent across them.

Ephemeral join — attaches the order header + paying customer's segment to each payment row, plus payment-lifecycle booleans. Inlined into `mart_payments_daily` so the payment-funnel definition stays consistent.

Ephemeral join — attaches order header + promotion metadata + customer segment to each order-promotion row. Inlined into `mart_promotion_performance`.

Ephemeral join — decorates each RFX opportunity with its account (name, segment, tier, revenue band) and the owning subject-matter expert (name, department). Inlined into `mart_rfx_pipeline` so the pipeline rollup never re-joins accounts + SMEs.

Ephemeral join — attaches each proposal to its parent opportunity (and that opportunity's account) so proposal economics can be sliced by the deal's segment / region / rfx_type. Exposes the price/cost/margin trio, decision cycle time, outcome, and a derived `is_won` flag. Inlined into `mart_proposal_outcomes`.

Ephemeral join — decorates shipments with ship-to country and the SLA derivations (ship_lag_hours, transit_hours, on_time). Inlined into `mart_shipments_daily`.

Ephemeral fan-out — explodes each subscription into one row per active calendar month (started_at → cancelled_at or today). Inlined into `mart_subscriptions_monthly`.

Ephemeral join — one row per client×site engagement with SLA targets flattened alongside client segment/tier and site region. Inlined into mart_client_scorecard (joined against actuals) and mart_site_performance.

Ephemeral join — inventory lots decorated with product temp/hazard class, site region, owning-client segment, and derived cover/turnover/near-expiry signals. Inlined into mart_inventory_health.

Ephemeral join — order spine decorated with client segment/tier, site region, dest region, and a line-level pick-accuracy rollup. Inlined into mart_fulfillment_daily and mart_order_outcomes so neither re-joins clients / sites / lines.