# request Approval Request - Catalog: `Odoo` - Schema: `approval` The data in this table is partitioned per value of the column. This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API. ## Table Columns The columns of the table `request` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity_calendar_event_id_label` | `string` | | ☐ | | | `activity_calendar_event_id` | `string` | | ☐ | | | `activity_date_deadline` | `datetime` | Next Activity Deadline | ☐ | | | `activity_exception_decoration` | `string` | Activity Exception Decoration | ☐ | Type of the exception activity on record. | | `activity_exception_icon` | `string` | Icon | ☐ | Icon to indicate an exception activity. | | `activity_ids` | `string` | | ☐ | | | `activity_state` | `string` | Activity State | ☐ | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | | `activity_summary` | `string` | Next Activity Summary | ☐ | | | `activity_type_icon` | `string` | Activity Type Icon | ☐ | Font awesome icon e.g. fa-tasks | | `activity_type_id_label` | `string` | | ☐ | | | `activity_type_id` | `string` | | ☐ | | | `activity_user_id_label` | `string` | | ☐ | | | `activity_user_id` | `string` | | ☐ | | | `amount` | `decimal` | Amount | ☐ | | | `approval_minimum` | `int32` | Minimum Approval | ☐ | | | `approval_type` | `string` | Approval Type | ☐ | Allows you to define which documents you would like to create once the request has been approved | | `approver_ids` | `string` | | ☐ | | | `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_label` | `string` | | ☐ | | | `category_id` | `string` | | ☐ | | | `category_image` | `byte[]` | Image | ☐ | | | `change_request_owner` | `boolean` | Can Change Request Owner | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `date_confirmed` | `datetime` | Date Confirmed | ☐ | | | `date_end` | `datetime` | Date end | ☐ | | | `date_start` | `datetime` | Date start | ☐ | | | `date` | `datetime` | Date | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `has_access_to_request` | `boolean` | Has Access To Request | ☐ | | | `has_amount` | `string` | Has Amount | ☐ | | | `has_date` | `string` | Has Date | ☐ | | | `has_location` | `string` | Has Location | ☐ | | | `has_message` | `boolean` | Has Message | ☐ | | | `has_partner` | `string` | Has Contact | ☐ | | | `has_payment_method` | `string` | Has Payment | ☐ | | | `has_period` | `string` | Has Period | ☐ | | | `has_product` | `string` | Has Product | ☐ | Additional products that should be specified on the request. | | `has_quantity` | `string` | Has Quantity | ☐ | | | `has_reference` | `string` | Has Reference | ☐ | An additional reference that should be specified on the request. | | `hide_location` | `boolean` | Hide Location | ☐ | | | `id` | `int32` | ID | ☐ | | | `location` | `string` | Location | ☐ | | | `message_attachment_count` | `int32` | Attachment Count | ☐ | | | `message_follower_ids` | `string` | | ☐ | | | `message_has_error_counter` | `int32` | Number of errors | ☐ | Number of messages with delivery error | | `message_has_error` | `boolean` | Message Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_has_sms_error` | `boolean` | SMS Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_ids` | `string` | | ☐ | | | `message_is_follower` | `boolean` | Is Follower | ☐ | | | `message_main_attachment_id_label` | `string` | | ☐ | | | `message_main_attachment_id` | `string` | | ☐ | | | `message_needaction_counter` | `int32` | Number of Actions | ☐ | Number of messages which requires an action | | `message_needaction` | `boolean` | Action Needed | ☐ | If checked, new messages require your attention. | | `message_partner_ids` | `string` | | ☐ | | | `my_activity_date_deadline` | `datetime` | My Activity Deadline | ☐ | | | `name` | `string` | Approval Subject | ☐ | | | `partner_id_label` | `string` | | ☐ | | | `partner_id` | `string` | | ☐ | | | `product_line_ids` | `string` | | ☐ | | | `purchase_order_count` | `int32` | Purchase Order Count | ☐ | | | `quantity` | `decimal` | Quantity | ☐ | | | `reason` | `string` | Description | ☐ | | | `reference` | `string` | Reference | ☐ | | | `request_owner_id_label` | `string` | | ☐ | | | `request_owner_id` | `string` | | ☐ | | | `request_status` | `string` | Request Status | ☐ | | | `requirer_document` | `string` | Documents | ☐ | | | `user_status` | `string` | User Status | ☐ | | | `website_message_ids` | `string` | | ☐ | Website communication history | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |