maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Fixed-asset register with acquisition cost, salvage, useful life, and the GL asset + accumulated-depreciation accounts. Source of the depreciation schedule.
16 of 16
Column
Description
Tests · PII
fixed_asset_id
Primary key — BIGSERIAL on the source.
2 tests
asset_tag
Unique asset tag.
2 tests
name
Asset name (renamed to `asset_name` in staging).
category
Category — `hardware` / `furniture` / `leasehold` / `software_cap` / `vehicle`.
1 test
legal_entity_id
FK to `legal_entities.legal_entity_id`. Nullable.
cost_center_id
FK to `cost_centers.cost_center_id`. Nullable.
gl_asset_account_id
FK to `gl_accounts.gl_account_id` (asset account). NOT NULL.
1 test
gl_depreciation_account_id
FK to `gl_accounts.gl_account_id` (accumulated depreciation). NOT NULL.
1 test
acquisition_date
When the asset was acquired.
acquisition_cost
Capitalised cost. NUMERIC(14,2).
salvage_value
Estimated salvage value. NUMERIC(14,2).
useful_life_months
Useful life in months.
depreciation_method
Method — `straight_line` / `declining_balance`.
1 test
status
Lifecycle — `in_service` / `disposed` / `fully_depreciated`.
1 test
created_at
Row insert timestamp in the source DB.
updated_at
Row update timestamp in the source DB.