recurring_journal_templates

source

The templates that generate accrual / deferral entries.

Definition

Recurring-JE templates naming a debit + credit account, amount, frequency, and active period window. Source of accrual / deferral / prepaid postings.

16 of 16

Column

Description

Tests · PII

recurring_journal_template_id

Primary key — BIGSERIAL on the source.

2 tests

name

Template name (renamed to `template_name` in staging).

accrual_type

Type — `accrual` / `deferral` / `prepaid` / `recurring`.

1 test

legal_entity_id

FK to `legal_entities.legal_entity_id`. Nullable.

gl_debit_account_id

FK to `gl_accounts.gl_account_id` (debit side). NOT NULL.

1 test

gl_credit_account_id

FK to `gl_accounts.gl_account_id` (credit side). NOT NULL.

1 test

cost_center_id

FK to `cost_centers.cost_center_id`. Nullable.

amount

Periodic amount. NUMERIC(14,2).

currency

Template currency.

frequency

Frequency — `monthly` / `quarterly`.

1 test

start_period_id

FK to `fiscal_periods.period_id` (first period). NOT NULL.

1 test

end_period_id

FK to `fiscal_periods.period_id` (last period). Nullable.

is_active

True for active templates.

created_by_employee_id

FK to the creating employee — actor reference. Nullable.

created_at

Row insert timestamp in the source DB.

updated_at

Row update timestamp in the source DB.