maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Each item links a bank transaction and/or GL line to a reconciliation, or flags an unmatched / adjustment item.
9 of 9
Column
Description
Tests · PII
reconciliation_item_id
Primary key — UInt64.
2 tests
reconciliation_id
FK to `stg_postgres__reconciliations.reconciliation_id`. NOT NULL.
2 tests
bank_transaction_id
FK to `stg_postgres__bank_transactions.bank_transaction_id`. Nullable.
journal_line_id
FK to `stg_postgres__gl_journal_lines.journal_line_id`. Nullable.
match_type
Match kind — matched / unmatched_bank / unmatched_book / adjustment.
1 test
amount
Item amount. Decimal(12,2).
note
Free-text note. Nullable.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.