invantive documentation
Invantive Support ForumsLog In / Sign Up

expense: Odoo itgen_odoo_expense

read only per partition

  • Catalog: Odoo
  • Schema: hr
  • Label: itgen_odoo_expense

Expense

Can only retrieve data.

Summary

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

Table Columns

The columns of the table expense 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_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 Amount Due
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 Number of Attachments
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 Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
currency_rate numeric Currency Rate
date datetime Expense Date
description varchar2 Internal Notes
display_name varchar2 Display Name
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 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
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Description
payment_mode varchar2 Paid By
predicted_category varchar2 Predicted Category
product_description varchar2 Product Description
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 Unit Price
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

Release Notes

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