maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Templates naming a debit + credit account, amount, frequency, and active period window; the source of accrual / deferral / prepaid postings.
17 of 17
Column
Description
Tests · PII
recurring_journal_template_id
Primary key — UInt64.
2 tests
template_name
Template name (renamed from `name`).
accrual_type
Type — accrual / deferral / prepaid / recurring.
1 test
legal_entity_id
FK to `stg_postgres__legal_entities.legal_entity_id`. Nullable.
gl_debit_account_id
FK to `stg_postgres__gl_accounts.gl_account_id` (debit side). NOT NULL.
2 tests
gl_credit_account_id
FK to `stg_postgres__gl_accounts.gl_account_id` (credit side). NOT NULL.
2 tests
cost_center_id
FK to `stg_postgres__cost_centers.cost_center_id`. Nullable.
amount
Periodic amount. Decimal(14,2).
currency
Template currency, uppercased.
frequency
Frequency — monthly / quarterly.
1 test
start_period_id
FK to fiscal_periods.period_id (first period; not staged). NOT NULL.
1 test
end_period_id
FK to fiscal_periods.period_id (last period; not staged). Nullable.
is_active
True for active templates.
created_by_employee_id
FK to the creating employee — actor reference. Nullable.
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.