bank_accounts

source

The bank accounts we move cash through.

Definition

One row per bank account, mapped to its GL cash account. Drives AP payments, AR receipts, bank transactions, and reconciliations.

11 of 11

Column

Description

Tests · PII

bank_account_id

Primary key — BIGSERIAL on the source.

2 tests

account_name

Internal account name.

bank_name

Name of the bank.

gl_account_id

FK to `gl_accounts.gl_account_id` (cash account). NOT NULL.

1 test

legal_entity_id

FK to `legal_entities.legal_entity_id`. Nullable.

currency

Account currency.

account_number_last4

Last 4 of the account number. Nullable.

region

Region slug — `US` / `EU`. Nullable.

is_active

True for active accounts.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.