---
title: "letter (Odoo)"
description: "itgen_odoo_letter"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.snailmail.letter
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.snailmail.letter
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# letter: Odoo itgen_odoo_letter

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `snailmail`
- Label: itgen_odoo_letter

Snailmail Letter

Can only retrieve data.

## Table Columns

The columns of the table `letter` 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 |
|---|---|---|:---:|---|---|
| `attachment_datas` | `varbinary` | Document | [ ] |  |  |
| `attachment_fname` | `varchar2` | Attachment Filename | [ ] |  |  |
| `attachment_id` | `varchar2` |  | [ ] |  |  |
| `attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `city` | `varchar2` | City | [ ] |  |  |
| `color` | `boolean` | Color | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `country_id` | `varchar2` |  | [ ] |  |  |
| `country_id_label` | `varchar2` |  | [ ] |  |  |
| `cover` | `boolean` | Cover Page | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `duplex` | `boolean` | Both side | [ ] |  |  |
| `error_code` | `varchar2` | Error | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `info_msg` | `varchar2` | Information | [ ] |  |  |
| `message_id` | `varchar2` |  | [ ] |  |  |
| `message_id_label` | `varchar2` |  | [ ] |  |  |
| `model` | `varchar2` | Model | [x] |  |  |
| `notification_ids` | `varchar2` |  | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `reference` | `varchar2` | Related Record | [ ] |  |  |
| `report_template` | `varchar2` |  | [ ] |  |  |
| `report_template_label` | `varchar2` |  | [ ] |  |  |
| `res_id` | `int32` | Document ID | [x] |  |  |
| `state` | `varchar2` | Status | [x] |  | When a letter is created, the status is 'Pending'. If the letter is correctly sent, the status goes in 'Sent', If not, it will got in state 'Error' and the error message will be displayed in the field 'Error Message'. |
| `state_id` | `varchar2` |  | [ ] |  |  |
| `state_id_label` | `varchar2` |  | [ ] |  |  |
| `street` | `varchar2` | Street | [ ] |  |  |
| `street2` | `varchar2` | Street2 | [ ] |  |  |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |
| `zip` | `varchar2` | Zip | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

