maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmarts

mart_journal_entries

beta
mart table

Every posted/draft GL line with its entry and account.

Lineage Builds
Definition

One row per journal LINE with the entry header (number, date, source, status, creating employee) and the account it posts to. `net_amount` per line is debit - credit. The drill-down behind the GL balances; the creating employee is an actor reference, not a maskable identity column.

What it means
Watch out for
  • highSumming debit and credit together for a balance

    Per-line `net_amount` is debit - credit. Adding both columns gives gross posting volume, not a balance.

  • mediumTreating created_by_employee_id as a maskable identity column

    It is an actor reference (a DSAR-access location), not the employee identity surface. Employee erasure tokenizes finance_employees, not these retained legal_obligation rows.

Questions this answers
  • “Show the lines of journal entry JE-2025-000123.”
  • “Which entries did a given employee create last period?”
Related metrics
24 of 24
Column
Type
Description
Tests · PII
period_id
UInt64
FK to the fiscal period (from the entry header).
1 test
period_code
String
Period code. Nullable if the period dimension is missing.
fiscal_year
Int16
Fiscal year of the period. Int16.
period_month
Int16
Calendar month 1..12. Int16.
period_month_start
Date
Month bucket — toStartOfMonth(period start).
journal_entry_id
UInt64
FK to stg_postgres__gl_journal_entries.journal_entry_id.
1 test
entry_number
String
Human-readable entry number (e.g. JE-2025-000123).
entry_date
Date
Accounting date of the entry. Date.
source
String
Entry origin — manual / ap / ar / depreciation / accrual / fx_gain_loss / close.
status
String
Entry lifecycle — draft / posted / reversed.
legal_entity_id
Nullable(UInt64)
FK to the legal entity. Nullable.
created_by_employee_id
UInt64
FK to the creating employee — actor reference (DSAR-access location, not a maskable column).
posted_at
Nullable(DateTime64(6))
When the entry was posted. Nullable while draft.
journal_line_id
UInt64
Primary key — the line grain. UInt64.
2 tests
line_number
Int16
1-based line ordinal within the entry. Int16.
gl_account_id
UInt64
FK to stg_postgres__gl_accounts.gl_account_id.
1 test
account_code
String
GL account code.
account_name
String
GL account name.
account_type
String
asset / liability / equity / revenue / expense.
cost_center_id
Nullable(UInt64)
FK to the cost center. Nullable.
debit_amount
Decimal(14, 2)
Line debit in functional USD. Decimal(14,2). Zero on a credit line.
credit_amount
Decimal(14, 2)
Line credit in functional USD. Decimal(14,2). Zero on a debit line.
net_amount
Decimal(14, 2)
Per-line debit - credit. Decimal(14,2).
currency
String
Line currency (functional USD).