reconciliation_items

source

The matched / unmatched items inside a reconciliation.

Definition

Each item links a bank transaction and/or a GL journal line to a reconciliation, or flags an unmatched / adjustment item.

8 of 8

Column

Description

Tests · PII

reconciliation_item_id

Primary key — BIGSERIAL on the source.

2 tests

reconciliation_id

FK to `reconciliations.reconciliation_id`. NOT NULL.

1 test

bank_transaction_id

FK to `bank_transactions.bank_transaction_id`. Nullable.

journal_line_id

FK to `gl_journal_lines.journal_line_id`. Nullable.

match_type

Match kind — `matched` / `unmatched_bank` / `unmatched_book` / `adjustment`.

1 test

amount

Item amount. NUMERIC(12,2).

note

Free-text note. Nullable.

created_at

Row insert timestamp in the source DB.