stg_postgres__bank_accounts

staging view

Bank accounts, cleaned.

Definition

Bank-account dimension mapped to its GL cash account; drives AP/AR cash and reconciliations.

12 of 12

Column

Description

Tests · PII

bank_account_id

Primary key — UInt64.

6 tests

account_name

Internal account name.

bank_name

Bank name.

gl_account_id

FK to `stg_postgres__gl_accounts.gl_account_id`. NOT NULL.

2 tests

legal_entity_id

FK to `stg_postgres__legal_entities.legal_entity_id`. Nullable.

currency

Account currency, uppercased.

account_number_last4

Last 4 of the account number. Nullable.

region

Region slug — US / EU. Nullable.

is_active

True for active accounts.

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.