invantive documentation
Invantive Support ForumsLog In / Sign Up

request: Odoo itgen_odoo_request

read only per partition

  • Catalog: Odoo
  • Schema: approval
  • Label: itgen_odoo_request

Approval Request

Can only retrieve data.

Table Columns

The columns of the table request 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
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 numeric Amount
approval_minimum int32 Minimum Approval
approval_type varchar2 Approval Type Allows you to define which documents you would like to create once the request has been approved
approver_ids varchar2
approver_sequence boolean Approvers Sequence? If checked, the approvers have to approve in sequence (one after the other). If Employee's Manager is selected as approver, they will be the first in line.
attachment_number int32 Number of Attachments
automated_sequence boolean Automated Sequence? If checked, the Approval Requests will have an automated generated name based on the given code.
category_id varchar2
category_id_label varchar2
category_image varbinary Image
change_request_owner boolean Can Change Request Owner
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
date datetime Date
date_confirmed datetime Date Confirmed
date_end datetime Date end
date_start datetime Date start
display_name varchar2 Display Name
has_access_to_request boolean Has Access To Request
has_amount varchar2 Has Amount
has_date varchar2 Has Date
has_location varchar2 Has Location
has_message boolean Has Message
has_partner varchar2 Has Contact
has_payment_method varchar2 Has Payment
has_period varchar2 Has Period
has_product varchar2 Has Product Additional products that should be specified on the request.
has_quantity varchar2 Has Quantity
has_reference varchar2 Has Reference An additional reference that should be specified on the request.
hide_location boolean Hide Location
id int32 ID
location varchar2 Location
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 Approval Subject
partner_id varchar2
partner_id_label varchar2
product_line_ids varchar2
purchase_order_count int32 Purchase Order Count
quantity numeric Quantity
reason varchar2 Description
reference varchar2 Reference
request_owner_id varchar2
request_owner_id_label varchar2
request_status varchar2 Request Status
requirer_document varchar2 Documents
user_status varchar2 User Status
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: