maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Fixed-asset register naming the GL asset + accumulated-depreciation accounts; the source of the depreciation schedule.
17 of 17
Column
Description
Tests · PII
fixed_asset_id
Primary key — UInt64.
3 tests
asset_tag
Unique asset tag.
2 tests
asset_name
Asset name (renamed from `name`).
category
Category — hardware / furniture / leasehold / software_cap / vehicle.
1 test
legal_entity_id
FK to `stg_postgres__legal_entities.legal_entity_id`. Nullable.
cost_center_id
FK to `stg_postgres__cost_centers.cost_center_id`. Nullable.
gl_asset_account_id
FK to `stg_postgres__gl_accounts.gl_account_id` (asset account). NOT NULL.
2 tests
gl_depreciation_account_id
FK to `stg_postgres__gl_accounts.gl_account_id` (accumulated depreciation). NOT NULL.
2 tests
acquisition_date
When the asset was acquired. Date.
acquisition_cost
Capitalised cost. Decimal(14,2).
salvage_value
Estimated salvage value. Decimal(14,2).
useful_life_months
Useful life in months. Int16.
depreciation_method
Method — straight_line / declining_balance.
1 test
status
Lifecycle — in_service / disposed / fully_depreciated.
1 test
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.