maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
One row per journal entry. `created_by_employee_id` is an actor reference (DSAR-access location, not a maskable identity column). Statutory record kept 7 years.
14 of 14
Column
Description
Tests · PII
journal_entry_id
Primary key — UInt64.
3 tests
entry_number
Human-readable entry number. Unique.
2 tests
legal_entity_id
FK to `stg_postgres__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. Date.
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 `stg_postgres__finance_employees.employee_id` — actor reference. NOT NULL.
2 tests
posted_at
When the entry was posted. Nullable while draft.
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
source_updated_at
Row update timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.