stg_postgres__depreciation_schedule

staging view

Depreciation schedule, cleaned.

Definition

Depreciation rows per (fixed_asset, period) — period depreciation, accumulated, and net book value.

9 of 9

Column

Description

Tests · PII

depreciation_schedule_id

Primary key — UInt64.

2 tests

fixed_asset_id

FK to `stg_postgres__fixed_assets.fixed_asset_id`. NOT NULL.

2 tests

period_id

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

1 test

depreciation_amount

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

accumulated_depreciation

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

net_book_value

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

journal_entry_id

FK to `stg_postgres__gl_journal_entries.journal_entry_id`. Nullable.

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When the loader extracted this row from postgres-source.