gl_journal_lines

source

The debit/credit lines that make every entry balance.

Definition

Line-level GL postings in functional USD. Exactly one of `debit_amount` / `credit_amount` is non-zero per line (source CHECK; re-asserted in staging tests). Sum(debit)=Sum(credit) per entry and per period (trial_balance_zero_per_period).

10 of 10

Column

Description

Tests · PII

journal_line_id

Primary key — BIGSERIAL on the source.

2 tests

journal_entry_id

FK to `gl_journal_entries.journal_entry_id`. NOT NULL.

1 test

line_number

1-based line ordinal within the entry.

gl_account_id

FK to `gl_accounts.gl_account_id`. NOT NULL.

1 test

cost_center_id

FK to `cost_centers.cost_center_id`. Nullable.

debit_amount

Debit in functional USD. NUMERIC(14,2). Zero when this is a credit line.

credit_amount

Credit in functional USD. NUMERIC(14,2). Zero when this is a debit line.

currency

Currency of the line (functional `USD`).

memo

Free-text line memo. Nullable.

created_at

Row insert timestamp in the source DB.