depreciation_schedule

source

How each asset depreciates, period by period.

Definition

Depreciation rows per (fixed_asset, period) — UNIQUE on the source. Carries period depreciation, accumulated depreciation, and net book value; the source of the recurring depreciation journal entries.

8 of 8

Column

Description

Tests · PII

depreciation_schedule_id

Primary key — BIGSERIAL on the source.

2 tests

fixed_asset_id

FK to `fixed_assets.fixed_asset_id`. NOT NULL.

1 test

period_id

FK to `fiscal_periods.period_id` (not staged in this slice). NOT NULL.

1 test

depreciation_amount

Depreciation for the period. NUMERIC(14,2).

accumulated_depreciation

Cumulative depreciation to date. NUMERIC(14,2).

net_book_value

Net book value after the period. NUMERIC(14,2).

journal_entry_id

FK to the GL entry that posted the depreciation. Nullable.

created_at

Row insert timestamp in the source DB.