stg_postgres__gl_journal_lines

staging view

Double-entry GL lines, cleaned.

Definition

Line-level GL postings in functional USD. The exactly-one-of-debit/credit invariant (source CHECK) is re-asserted here as a dbt_utils.expression_is_true data test; trial-balance ties are tested downstream.

11 of 11

Column

Description

Tests · PII

journal_line_id

Primary key — UInt64.

2 tests

journal_entry_id

FK to `stg_postgres__gl_journal_entries.journal_entry_id`. NOT NULL.

2 tests

line_number

1-based line ordinal within the entry. Int16.

gl_account_id

FK to `stg_postgres__gl_accounts.gl_account_id`. NOT NULL.

2 tests

cost_center_id

FK to `stg_postgres__cost_centers.cost_center_id`. Nullable.

debit_amount

Debit in functional USD. Decimal(14,2). Zero when a credit line.

credit_amount

Credit in functional USD. Decimal(14,2). Zero when a debit line.

currency

Currency of the line, uppercased (functional USD).

memo

Free-text line memo. Nullable.

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When the loader extracted this row from postgres-source.