---
title: "asset (Odoo)"
description: "itgen_odoo_asset"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.account.asset
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.account.asset
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# asset: Odoo itgen_odoo_asset

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `account`
- Label: itgen_odoo_asset

Asset/Revenue Recognition

Can only retrieve data.

## Table Columns

The columns of the table `asset` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `account_asset_id` | `varchar2` |  | [ ] |  | Account used to record the purchase of the asset at its original price. |
| `account_asset_id_label` | `varchar2` |  | [ ] |  | Account used to record the purchase of the asset at its original price. |
| `account_depreciation_expense_id` | `varchar2` |  | [ ] |  | Account used in the periodical entries, to record a part of the asset as expense. |
| `account_depreciation_expense_id_label` | `varchar2` |  | [ ] |  | Account used in the periodical entries, to record a part of the asset as expense. |
| `account_depreciation_id` | `varchar2` |  | [ ] |  | Account used in the depreciation entries, to decrease the asset value. |
| `account_depreciation_id_label` | `varchar2` |  | [ ] |  | Account used in the depreciation entries, to decrease the asset value. |
| `account_type` | `varchar2` | Type of the account | [ ] |  | Account Type is used for information purpose, to generate country-specific legal reports, and set the rules to close a fiscal year and generate opening entries. |
| `acquisition_date` | `datetime` | Acquisition Date | [ ] |  |  |
| `active` | `boolean` | Active | [ ] |  |  |
| `activity_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `already_depreciated_amount_import` | `numeric` | Already Depreciated Amount Import | [ ] |  | In case of an import from another software, you might need to use this field to have the right depreciation table report. This is the value that was already depreciated with entries not computed from this model |
| `analytic_distribution` | `varchar2` | Analytic Distribution | [ ] |  |  |
| `analytic_precision` | `int32` | Analytic Precision | [ ] |  |  |
| `asset_lifetime_days` | `int32` | Asset Lifetime Days | [ ] |  |  |
| `asset_paused_days` | `numeric` | Asset Paused Days | [ ] |  |  |
| `asset_type` | `varchar2` | Asset Type | [ ] |  |  |
| `book_value` | `numeric` | Book Value | [ ] |  | Sum of the depreciable value, the salvage value and the book value of all value increase items |
| `children_ids` | `varchar2` |  | [ ] |  | The children are the gains in value of this asset |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `depreciation_entries_count` | `int32` | # Posted Depreciation Entries | [ ] |  |  |
| `depreciation_move_ids` | `varchar2` |  | [ ] |  |  |
| `display_account_asset_id` | `boolean` | Display Account Asset | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `disposal_date` | `datetime` | Disposal Date | [ ] |  |  |
| `gross_increase_count` | `int32` | # Gross Increases | [ ] |  | Number of assets made to increase the value of the asset |
| `gross_increase_value` | `numeric` | Gross Increase Value | [ ] |  |  |
| `has_message` | `boolean` | Has Message | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `journal_id` | `varchar2` |  | [ ] |  |  |
| `journal_id_label` | `varchar2` |  | [ ] |  |  |
| `message_attachment_count` | `int32` | Attachment Count | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Number of Actions | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `method` | `varchar2` | Method | [ ] |  | Choose the method to use to compute the amount of depreciation lines.   * Straight Line: Calculated on basis of: Gross Value / Duration   * Declining: Calculated on basis of: Residual Value * Declining Factor   * Declining then Straight Line: Like Declining but with a minimum depreciation value equal to the straight line value. |
| `method_number` | `int32` | Duration | [ ] |  | The number of depreciations needed to depreciate your asset |
| `method_period` | `varchar2` | Number of Months in a Period | [ ] |  | The amount of time between two depreciations |
| `method_progress_factor` | `numeric` | Declining Factor | [ ] |  |  |
| `model_id` | `varchar2` |  | [ ] |  |  |
| `model_id_label` | `varchar2` |  | [ ] |  |  |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `name` | `varchar2` | Asset Name | [x] |  |  |
| `non_deductible_tax_value` | `numeric` | Non Deductible Tax Value | [ ] |  |  |
| `original_move_line_ids` | `varchar2` |  | [ ] |  |  |
| `original_value` | `numeric` | Original Value | [ ] |  |  |
| `parent_id` | `varchar2` |  | [ ] |  | An asset has a parent when it is the result of gaining value |
| `parent_id_label` | `varchar2` |  | [ ] |  | An asset has a parent when it is the result of gaining value |
| `paused_prorata_date` | `datetime` | Paused Prorata Date | [ ] |  |  |
| `prorata_computation_type` | `varchar2` | Computation | [x] |  |  |
| `prorata_date` | `datetime` | Prorata Date | [x] |  |  |
| `related_purchase_value` | `numeric` | Related Purchase Value | [ ] |  |  |
| `salvage_value` | `numeric` | Not Depreciable Value | [ ] |  | It is the amount you plan to have that you cannot depreciate. |
| `state` | `varchar2` | Status | [ ] |  | When an asset is created, the status is 'Draft'. If the asset is confirmed, the status goes in 'Running' and the depreciation lines can be posted in the accounting. The 'On Hold' status can be set manually when you want to pause the depreciation of an asset for some time. You can manually close an asset when the depreciation is over. By cancelling an asset, all depreciation entries will be reversed |
| `total_depreciable_value` | `numeric` | Total Depreciable Value | [ ] |  |  |
| `total_depreciation_entries_count` | `int32` | # Depreciation Entries | [ ] |  | Number of depreciation entries (posted or not) |
| `value_residual` | `numeric` | Depreciable Value | [ ] |  |  |
| `vehicle_id` | `varchar2` |  | [ ] |  |  |
| `vehicle_id_label` | `varchar2` |  | [ ] |  |  |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

