int_gl__trial_balance

intermediate view

Posted-only debit/credit/net per account, period, cost center.

Definition

Per (period, gl_account, cost_center) sum of debits and credits over posted lines, plus the net (debit minus credit). The standing balance the trial balance and GL marts are built from.

7 of 7

Column

Description

Tests · PII

period_id

FK to int_finance__periods.period_id (from the entry header).

gl_account_id

FK to stg_postgres__gl_accounts.gl_account_id.

cost_center_id

Cost center; 0 when the line carried none (kept non-null for the sort key).

debit_amount

Sum of posted debits in functional USD. Decimal(18,2).

credit_amount

Sum of posted credits in functional USD. Decimal(18,2).

net_amount

Derived — sum(debit) - sum(credit). The balance. Decimal(18,2).

line_count

Number of posted lines in the bucket. UInt64.