maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One reconciliation per (bank_account, period). `difference_amount` is statement vs GL ending balance.
12 of 12
Column
Description
Tests · PII
reconciliation_id
Primary key — UInt64.
3 tests
bank_account_id
FK to `stg_postgres__bank_accounts.bank_account_id`. NOT NULL.
2 tests
period_id
FK to fiscal_periods.period_id (not staged in this slice). NOT NULL.
1 test
statement_ending_balance
Bank statement ending balance. Decimal(14,2).
gl_ending_balance
GL cash-account ending balance. Decimal(14,2).
difference_amount
Statement minus GL. Decimal(14,2).
status
Lifecycle — in_progress / balanced / closed.
1 test
reconciled_by_employee_id
FK to the reconciling employee — actor reference. Nullable.
reconciled_at
When reconciliation completed. Nullable.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.