maiven gateway · online··
manifest · 2d ago
Sign in Back to catalog
Definition
One row per journal entry — period, entry date, source, status, and the employee who created it (`created_by_employee_id` is an actor reference, a DSAR-access location). Statutory record kept 7 years.
13 of 13
Column
Description
Tests · PII
journal_entry_id
Primary key — BIGSERIAL on the source.
2 tests
entry_number
Human-readable entry number (e.g. `JE-2025-000123`). Unique.
2 tests
legal_entity_id
FK to `legal_entities.legal_entity_id`. Nullable.
period_id
FK to `fiscal_periods.period_id` (not staged in this slice). NOT NULL.
1 test
entry_date
Accounting date of the entry.
source
Origin — `manual` / `ap` / `ar` / `depreciation` / `accrual` / `fx_gain_loss` / `close`.
1 test
status
Lifecycle — `draft` / `posted` / `reversed`.
1 test
memo
Free-text memo. Nullable.
reversal_of_entry_id
Self-FK to the entry this reverses. Nullable.
created_by_employee_id
FK to `finance_employees.employee_id` — actor reference (DSAR-access location). NOT NULL.
1 test
posted_at
When the entry was posted. Nullable while draft.
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.