maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
Per-period rollup of the signals a controller checks before locking a period: posted vs draft entries, whether the trial balance ties, and bank reconciliations opened vs balanced.
18 of 18
Column
Description
Tests · PII
period_id
FK to int_finance__periods.period_id.
period_code
Period code (e.g. FY2025-M07).
fiscal_year
Fiscal year. Int16.
period_month
Calendar month 1..12. Int16.
period_month_start
Month bucket — toStartOfMonth(start_date).
period_start_date
First day of the period. Date.
period_end_date
Last day of the period. Date.
period_status
Close status — open / closed / locked.
period_closed_at
When the period was closed. Nullable.
posted_entries
Count of posted journal entries in the period.
draft_entries
Count of draft journal entries (block the close).
reversed_entries
Count of reversed journal entries.
total_entries
Total journal entries in the period.
reconciliations_total
Bank reconciliations opened for the period.
reconciliations_balanced
Reconciliations in `balanced` status.
reconciliations_closed
Reconciliations in `closed` status.
reconciliations_in_progress
Reconciliations still `in_progress`.
trial_balance_ties
True when the period's posted trial balance nets to zero.