maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_postgres__bank_transactions

staging view 1 PII columns

Bank transactions, cleaned.

Lineage Builds PII registry
Definition

Bank-statement lines with settlement linkage so a customer/vendor DSAR reaches matched lines (H4). `counterparty_name` is incidental financial PII (nullify on erasure).

18 of 18
Column
Description
Tests · PII
bank_transaction_id
Primary key — UInt64.
2 tests
bank_account_id
FK to `stg_postgres__bank_accounts.bank_account_id`. NOT NULL.
2 tests
transaction_date
Posting date of the transaction. Date.
transaction_day
Calendar date — toDate(transaction_date).
value_date
Value date. Nullable.
direction
Cash direction — debit / credit.
1 test
amount
Transaction amount. Decimal(12,2).
currency
Transaction currency, uppercased.
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 `stg_postgres__payments.payment_id`. Nullable.
customer PII
ar_receipt_id
FK to `stg_postgres__ar_receipts.ar_receipt_id`. Nullable.
ap_payment_id
FK to `stg_postgres__ap_payments.ap_payment_id`. Nullable.
is_reconciled
True once matched in a reconciliation.
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.