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

# digest: Odoo itgen_odoo_digest

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `digest`
- Label: itgen_odoo_digest

Digest

Can only retrieve data.

## Table Columns

The columns of the table `digest` 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 |
|---|---|---|:---:|---|---|
| `available_fields` | `varchar2` | Available Fields | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_subscribed` | `boolean` | Is user subscribed | [ ] |  |  |
| `kpi_account_bank_cash` | `boolean` | Bank & Cash Moves | [ ] |  |  |
| `kpi_account_bank_cash_value` | `numeric` | Kpi Account Bank Cash Value | [ ] |  |  |
| `kpi_account_total_revenue` | `boolean` | Revenue | [ ] |  |  |
| `kpi_account_total_revenue_value` | `numeric` | Kpi Account Total Revenue Value | [ ] |  |  |
| `kpi_all_sale_total` | `boolean` | All Sales | [ ] |  |  |
| `kpi_all_sale_total_value` | `numeric` | Kpi All Sale Total Value | [ ] |  |  |
| `kpi_crm_lead_created` | `boolean` | New Leads | [ ] |  |  |
| `kpi_crm_lead_created_value` | `int32` | Kpi Crm Lead Created Value | [ ] |  |  |
| `kpi_crm_opportunities_won` | `boolean` | Opportunities Won | [ ] |  |  |
| `kpi_crm_opportunities_won_value` | `int32` | Kpi Crm Opportunities Won Value | [ ] |  |  |
| `kpi_helpdesk_tickets_closed` | `boolean` | Tickets Closed | [ ] |  |  |
| `kpi_helpdesk_tickets_closed_value` | `int32` | Kpi Helpdesk Tickets Closed Value | [ ] |  |  |
| `kpi_hr_recruitment_new_colleagues` | `boolean` | New Employees | [ ] |  |  |
| `kpi_hr_recruitment_new_colleagues_value` | `int32` | Kpi Hr Recruitment New Colleagues Value | [ ] |  |  |
| `kpi_livechat_conversations` | `boolean` | Conversations handled | [ ] |  |  |
| `kpi_livechat_conversations_value` | `int32` | Kpi Livechat Conversations Value | [ ] |  |  |
| `kpi_livechat_rating` | `boolean` | % of Happiness | [ ] |  |  |
| `kpi_livechat_rating_value` | `numeric` | Kpi Livechat Rating Value | [ ] |  |  |
| `kpi_livechat_response` | `boolean` | Time to answer (sec) | [ ] |  |  |
| `kpi_livechat_response_value` | `numeric` | Kpi Livechat Response Value | [ ] |  |  |
| `kpi_mail_message_total` | `boolean` | Messages Sent | [ ] |  |  |
| `kpi_mail_message_total_value` | `int32` | Kpi Mail Message Total Value | [ ] |  |  |
| `kpi_pos_total` | `boolean` | POS Sales | [ ] |  |  |
| `kpi_pos_total_value` | `numeric` | Kpi Pos Total Value | [ ] |  |  |
| `kpi_project_task_opened` | `boolean` | Open Tasks | [ ] |  |  |
| `kpi_project_task_opened_value` | `int32` | Kpi Project Task Opened Value | [ ] |  |  |
| `kpi_res_users_connected` | `boolean` | Connected Users | [ ] |  |  |
| `kpi_res_users_connected_value` | `int32` | Kpi Res Users Connected Value | [ ] |  |  |
| `kpi_website_sale_total` | `boolean` | eCommerce Sales | [ ] |  |  |
| `kpi_website_sale_total_value` | `numeric` | Kpi Website Sale Total Value | [ ] |  |  |
| `name` | `varchar2` | Name | [x] |  |  |
| `next_run_date` | `datetime` | Next Mailing Date | [ ] |  |  |
| `periodicity` | `varchar2` | Periodicity | [x] |  |  |
| `state` | `varchar2` | Status | [ ] |  |  |
| `user_ids` | `varchar2` |  | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

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

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

