invantive documentation
Invantive Support ForumsLog In / Sign Up

document: Odoo itgen_odoo_document

read only per partition

  • Catalog: Odoo
  • Schema: documents
  • Label: itgen_odoo_document

Document

Can only retrieve data.

Table Columns

The columns of the table document 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
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
attachment_id varchar2
attachment_id_label varchar2
attachment_name varchar2 Attachment Name
attachment_type varchar2 Attachment Type You can either upload a file from your computer or copy/paste an internet link to your file.
available_rule_ids varchar2
checksum varchar2 Checksum/SHA1
company_id varchar2 This workspace will only be available to the selected company
company_id_label varchar2 This workspace will only be available to the selected company
create_date datetime Created on
create_share_id varchar2 Share used to create this document
create_share_id_label varchar2 Share used to create this document
create_uid varchar2
create_uid_label varchar2
datas varbinary File Content (base64)
description varchar2 Attachment Description
display_name varchar2 Display Name
email_cc varchar2 Email cc
favorited_ids varchar2
file_size int32 File Size
folder_id varchar2
folder_id_label varchar2
group_ids varchar2 This attachment will only be available for the selected user groups
handler varchar2 Handler
has_message boolean Has Message
id int32 ID
index_content varchar2 Indexed Content
is_editable_attachment boolean Is Editable Attachment True if we can edit the link attachment.
is_favorited boolean Is Favorited
is_locked boolean Locked
is_shared boolean Is Shared
lock_uid varchar2
lock_uid_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
mimetype varchar2 Mime Type
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Name
owner_id varchar2
owner_id_label varchar2
partner_id varchar2
partner_id_label varchar2
previous_attachment_ids varchar2
raw varbinary File Content (raw)
request_activity_id varchar2
request_activity_id_label varchar2
res_id int32 Resource ID
res_model varchar2 Resource Model
res_model_name varchar2 Res Model Name
res_name varchar2 Resource Name
spreadsheet_revision_ids varchar2
spreadsheet_snapshot varbinary Spreadsheet Snapshot
tag_ids varchar2
thumbnail varbinary Thumbnail
thumbnail_status varchar2 Thumbnail Status
type varchar2 Type
url varchar2 URL
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: