invantive documentation
Forum di supporto InvantiveAccedi / Registrati

expense: Odoo itgen_odoo_expense

read only per partition

  • Catalogo: Odoo
  • Schema: hr
  • Etichetta: itgen_odoo_expense

Spesa

È possibile solo recuperare i dati.

Base model to inherit from to add extract functionality to a model.

Colonne della tabella

Di seguito sono riportate le colonne della tabella expense. 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_id varchar2 An expense account is expected
account_id_label varchar2 An expense account is expected
accounting_date datetime Accounting Date
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
amount_residual numeric Somma da pagare
amount_tax numeric Tax amount in Currency Tax amount in currency
amount_tax_company numeric Tax amount Tax amount in company currency
analytic_distribution varchar2 Analytic Distribution
analytic_precision int32 Analytic Precision
approved_by varchar2
approved_by_label varchar2
approved_on datetime Approved On
attachment_number int32 Numero di allegati
can_be_reinvoiced boolean Can be reinvoiced
company_currency_id varchar2
company_currency_id_label varchar2
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
currency_rate numeric Tasso di cambio della valuta
date datetime Data della spesa
description varchar2 Note interne
display_name varchar2 Nome visualizzato
duplicate_expense_ids varchar2
employee_id varchar2
employee_id_label varchar2
extract_can_show_send_button boolean Can show the ocr send button
extract_error_message varchar2 Error message
extract_remote_id int32 Id of the request to IAP-OCR
extract_state varchar2 Extract state
extract_state_processed boolean Extract State Processed
extract_status_code int32 Status code
has_message boolean Has Message
id int32 ID
is_editable boolean Is Editable By Current User
is_in_extractable_state boolean Is In Extractable State
is_ref_editable boolean Reference Is Editable By Current User
is_refused boolean Explicitly Refused by manager or accountant
label_convert_rate varchar2 Label Convert Rate
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
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Description
payment_mode varchar2 Paid By
predicted_category varchar2 Predicted Category
product_description varchar2 Descrizione del prodotto
product_has_cost boolean Is product with non zero cost selected
product_has_tax boolean Whether tax is defined on a selected product
product_id varchar2
product_id_label varchar2
product_uom_category_id varchar2 Conversion between Units of Measure can only occur if they belong to the same category.The conversion will be made based on the ratios.
product_uom_category_id_label varchar2 Conversion between Units of Measure can only occur if they belong to the same category.The conversion will be made based on the ratios.
product_uom_id varchar2
product_uom_id_label varchar2
quantity numeric Quantity
reference varchar2 Bill Reference
sale_order_id varchar2 If the category has an expense policy, it will be reinvoiced on this sales order
sale_order_id_label varchar2 If the category has an expense policy, it will be reinvoiced on this sales order
same_currency boolean Is currency_id different from the company_currency_id
sample boolean Sample
sheet_id varchar2
sheet_id_label varchar2
sheet_is_editable boolean Sheet Is Editable
state varchar2 Status
tax_ids varchar2
total_amount numeric Total In Currency
total_amount_company numeric Total
unit_amount numeric Prezzo unitario
unit_amount_display numeric Unit Price Display
untaxed_amount numeric Total Untaxed Amount In Currency
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: