---
title: "letter (Odoo)"
description: "itgen_odoo_letter"
language: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/odoo/Odoo.snailmail.letter
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.snailmail.letter
updated: 2026-11-19T00:03:01Z
license: https://documentation.invantive.eu/nl/
---

# letter: Odoo itgen_odoo_letter

`read only` `per partition`

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

Snailmail-brief

Kan alleen gegevens ophalen.

## Tabelkolommen

De kolommen van de tabel `letter` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `attachment_datas` | `varbinary` | Document | [ ] |  |  |
| `attachment_fname` | `varchar2` | Bestandsnaam bijlage | [ ] |  |  |
| `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` | Voorblad | [ ] |  |  |
| `create_date` | `datetime` | Aangemaakt op | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Weergavenaam | [ ] |  |  |
| `duplex` | `boolean` | Beide zijden | [ ] |  |  |
| `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` | Gerelateerd record | [ ] |  |  |
| `report_template` | `varchar2` |  | [ ] |  |  |
| `report_template_label` | `varchar2` |  | [ ] |  |  |
| `res_id` | `int32` | Document ID | [x] |  |  |
| `state` | `varchar2` | Status | [x] |  | Wanneer een brief wordt aangemaakt, is de status 'In behandeling'.Als de brief correct is verzonden, krijgt de status 'Verzonden'. Als dat niet het geval is, krijgt deze de status 'Fout' en wordt de foutmelding weergegeven in het veld 'Foutmelding'. |
| `state_id` | `varchar2` |  | [ ] |  |  |
| `state_id_label` | `varchar2` |  | [ ] |  |  |
| `street` | `varchar2` | Street | [ ] |  |  |
| `street2` | `varchar2` | Street2 | [ ] |  |  |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `write_date` | `datetime` | Laatst bijgewerkt op | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |
| `zip` | `varchar2` | Zip | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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