# composer Send SMS Wizard - Catalog: `Odoo` - Schema: `sms` 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 `composer` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `body` | `string` | Message | ☑ | | | `comment_single_recipient` | `boolean` | Single Mode | ☐ | Indicates if the SMS composer targets a single specific recipient | | `composition_mode` | `string` | Composition Mode | ☑ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `display_name` | `string` | Display Name | ☐ | | | `id` | `int32` | ID | ☐ | | | `mailing_id_label` | `string` | | ☐ | | | `mailing_id` | `string` | | ☐ | | | `marketing_activity_id_label` | `string` | | ☐ | | | `marketing_activity_id` | `string` | | ☐ | | | `mass_force_send` | `boolean` | Send directly | ☐ | | | `mass_keep_log` | `boolean` | Keep a note on document | ☐ | | | `mass_sms_allow_unsubscribe` | `boolean` | Include opt-out link | ☐ | | | `mass_use_blacklist` | `boolean` | Use blacklist | ☐ | | | `number_field_name` | `string` | Number Field | ☐ | | | `numbers` | `string` | Recipients (Numbers) | ☐ | | | `recipient_invalid_count` | `int32` | # Invalid recipients | ☐ | | | `recipient_single_description` | `string` | Recipients (Partners) | ☐ | | | `recipient_single_number_itf` | `string` | Recipient Number | ☐ | Phone number of the recipient. If changed, it will be recorded on recipient's profile. | | `recipient_single_number` | `string` | Stored Recipient Number | ☐ | | | `recipient_single_valid` | `boolean` | Is valid | ☐ | | | `recipient_valid_count` | `int32` | # Valid recipients | ☐ | | | `res_id` | `int32` | Document ID | ☐ | | | `res_ids_count` | `int32` | Visible records count | ☐ | Number of recipients that will receive the SMS if sent in mass mode, without applying the Active Domain value | | `res_ids` | `string` | Document IDs | ☐ | | | `res_model_description` | `string` | Document Model Description | ☐ | | | `res_model` | `string` | Document Model Name | ☐ | | | `sanitized_numbers` | `string` | Sanitized Number | ☐ | | | `template_id_label` | `string` | | ☐ | | | `template_id` | `string` | | ☐ | | | `utm_campaign_id_label` | `string` | | ☐ | | | `utm_campaign_id` | `string` | | ☐ | | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |