# request Signature Request - Catalog: `Odoo` - Schema: `sign` 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 | |---|:---:|---|:---:|---| | `access_token` | `string` | Security Token | ☑ | | | `active` | `boolean` | Active | ☐ | | | `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` | | ☐ | | | `attachment_ids` | `string` | | ☐ | | | `cc_partner_ids` | `string` | | ☐ | | | `color` | `int32` | Color | ☐ | | | `communication_company_id_label` | `string` | | ☐ | | | `communication_company_id` | `string` | | ☐ | | | `completed_document_attachment_ids` | `string` | | ☐ | | | `completed_document` | `byte[]` | Completed Document | ☐ | | | `completion_date` | `datetime` | Completion Date | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `favorited_ids` | `string` | | ☐ | | | `has_message` | `boolean` | Has Message | ☐ | | | `id` | `int32` | ID | ☐ | | | `integrity` | `boolean` | Integrity of the Sign request | ☐ | | | `last_action_date` | `datetime` | Last Action Date | ☐ | | | `message_attachment_count` | `int32` | Attachment Count | ☐ | | | `message_cc` | `string` | sign.message_cc | ☐ | | | `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` | | ☐ | | | `message` | `string` | sign.message | ☐ | | | `my_activity_date_deadline` | `datetime` | My Activity Deadline | ☐ | | | `nb_closed` | `int32` | Completed Signatures | ☐ | | | `nb_total` | `int32` | Requested Signatures | ☐ | | | `nb_wait` | `int32` | Sent Requests | ☐ | | | `need_my_signature` | `boolean` | Need My Signature | ☐ | | | `progress` | `string` | Progress | ☐ | | | `reference` | `string` | Document Name | ☑ | This is how the document will be named in the mail | | `refusal_allowed` | `boolean` | Can be refused | ☐ | Allow the contacts to refuse the document for a specific reason. | | `request_item_ids` | `string` | | ☐ | | | `request_item_infos` | `byte[]` | Request Item Infos | ☐ | | | `share_link` | `string` | Share Link | ☐ | | | `sign_log_ids` | `string` | | ☐ | Activity logs linked to this request | | `start_sign` | `boolean` | Signature Started | ☐ | At least one signer has signed the document. | | `state` | `string` | State | ☐ | | | `subject` | `string` | Email Subject | ☐ | | | `template_id_label` | `string` | | ☐ | | | `template_id` | `string` | | ☐ | | | `template_tags` | `string` | | ☐ | | | `website_message_ids` | `string` | | ☐ | Website communication history | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |