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

# session: Odoo itgen_odoo_session

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `pos`
- Label: itgen_odoo_session

Point of Sale Session

Can only retrieve data.

## Table Columns

The columns of the table `session` 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 |
|---|---|---|:---:|---|---|
| `activity_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `bank_payment_ids` | `varchar2` |  | [ ] |  | Account payments representing aggregated and bank split payments. |
| `cash_control` | `boolean` | Has Cash Control | [ ] |  |  |
| `cash_journal_id` | `varchar2` |  | [ ] |  |  |
| `cash_journal_id_label` | `varchar2` |  | [ ] |  |  |
| `cash_real_transaction` | `numeric` | Transaction | [ ] |  |  |
| `cash_register_balance_end` | `numeric` | Theoretical Closing Balance | [ ] |  | Opening balance summed to all cash transactions. |
| `cash_register_balance_end_real` | `numeric` | Ending Balance | [ ] |  |  |
| `cash_register_balance_start` | `numeric` | Starting Balance | [ ] |  |  |
| `cash_register_difference` | `numeric` | Before Closing Difference | [ ] |  | Difference between the theoretical closing balance and the real closing balance. |
| `cash_register_total_entry_encoding` | `numeric` | Total Cash Transaction | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `config_id` | `varchar2` |  | [ ] |  |  |
| `config_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `crm_team_id` | `varchar2` |  | [ ] |  | This Point of sale's sales will be related to this Sales Team. |
| `crm_team_id_label` | `varchar2` |  | [ ] |  | This Point of sale's sales will be related to this Sales Team. |
| `currency_id` | `varchar2` |  | [ ] |  |  |
| `currency_id_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `failed_pickings` | `boolean` | Failed Pickings | [ ] |  |  |
| `has_message` | `boolean` | Has Message | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `is_in_company_currency` | `boolean` | Is Using Company Currency | [ ] |  |  |
| `login_number` | `int32` | Login Sequence Number | [ ] |  | A sequence number that is incremented each time a user resumes the pos session |
| `message_attachment_count` | `int32` | Attachment Count | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Number of Actions | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `move_id` | `varchar2` |  | [ ] |  |  |
| `move_id_label` | `varchar2` |  | [ ] |  |  |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `name` | `varchar2` | Session ID | [x] |  |  |
| `opening_notes` | `varchar2` | Opening Notes | [ ] |  |  |
| `order_count` | `int32` | Order Count | [ ] |  |  |
| `order_ids` | `varchar2` |  | [ ] |  |  |
| `payment_method_ids` | `varchar2` |  | [ ] |  |  |
| `picking_count` | `int32` | Picking Count | [ ] |  |  |
| `picking_ids` | `varchar2` |  | [ ] |  |  |
| `rescue` | `boolean` | Recovery Session | [ ] |  | Auto-generated session for orphan orders, ignored in constraints |
| `sequence_number` | `int32` | Order Sequence Number | [ ] |  | A sequence number that is incremented with each order |
| `start_at` | `datetime` | Opening Date | [ ] |  |  |
| `state` | `varchar2` | Status | [x] |  |  |
| `statement_line_ids` | `varchar2` |  | [ ] |  |  |
| `stop_at` | `datetime` | Closing Date | [ ] |  |  |
| `total_payments_amount` | `numeric` | Total Payments Amount | [ ] |  |  |
| `update_stock_at_closing` | `boolean` | Stock should be updated at closing | [ ] |  |  |
| `user_id` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `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)

