bank_transactions

source 1 PII columns

Cash movements on the bank statement.

Definition

Bank-statement lines with settlement linkage (source_payment_id / ar_receipt_id / ap_payment_id) so a customer/vendor DSAR reaches matched lines deterministically (H4). `counterparty_name` is incidental financial PII (nullify on erasure). Statutory record kept 7 years.

16 of 16

Column

Description

Tests · PII

bank_transaction_id

Primary key — BIGSERIAL on the source.

2 tests

bank_account_id

FK to `bank_accounts.bank_account_id`. NOT NULL.

1 test

transaction_date

Posting date of the transaction.

value_date

Value date. Nullable.

direction

Cash direction — `debit` / `credit`.

1 test

amount

Transaction amount. NUMERIC(12,2).

currency

Transaction currency.

description

Statement description. Nullable.

counterparty_name

Counterparty on the statement. Financial PII (incidental). Nullable.

PII

external_reference

Bank-side reference. Nullable.

source_payment_id

FK to ecommerce `payments.payment_id`. Nullable.

customer PII

ar_receipt_id

FK to `ar_receipts.ar_receipt_id`. Nullable.

ap_payment_id

FK to `ap_payments.ap_payment_id`. Nullable.

is_reconciled

True once matched in a reconciliation.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.