invantive documentation
Forum di supporto InvantiveAccedi / Registrati

asset: Odoo itgen_odoo_asset

read only per partition

  • Catalogo: Odoo
  • Schema: account
  • Etichetta: itgen_odoo_asset

Asset/Revenue Recognition

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella asset. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Data di acquisizione
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 Creato il
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 Nome visualizzato
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 Numero di allegati
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 Numero di azioni 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
non_deductible_tax_value numeric Non Deductible Tax Value
original_move_line_ids varchar2
original_value numeric Valore originale
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
prorata_date datetime Prorata Date
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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: