# session Point of Sale Session - Catalog: `Odoo` - Schema: `pos` 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 `session` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `activity_calendar_event_id_label` | `string` | | ☐ | | | `activity_calendar_event_id` | `string` | | ☐ | | | `activity_date_deadline` | `datetime` | Next Activity Deadline | ☐ | | | `activity_exception_decoration` | `string` | Activity Exception Decoration | ☐ | Type of the exception activity on record. | | `activity_exception_icon` | `string` | Icon | ☐ | Icon to indicate an exception activity. | | `activity_ids` | `string` | | ☐ | | | `activity_state` | `string` | Activity State | ☐ | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | | `activity_summary` | `string` | Next Activity Summary | ☐ | | | `activity_type_icon` | `string` | Activity Type Icon | ☐ | Font awesome icon e.g. fa-tasks | | `activity_type_id_label` | `string` | | ☐ | | | `activity_type_id` | `string` | | ☐ | | | `activity_user_id_label` | `string` | | ☐ | | | `activity_user_id` | `string` | | ☐ | | | `bank_payment_ids` | `string` | | ☐ | Account payments representing aggregated and bank split payments. | | `cash_control` | `boolean` | Has Cash Control | ☐ | | | `cash_journal_id_label` | `string` | | ☐ | | | `cash_journal_id` | `string` | | ☐ | | | `cash_real_transaction` | `decimal` | Transaction | ☐ | | | `cash_register_balance_end_real` | `decimal` | Ending Balance | ☐ | | | `cash_register_balance_end` | `decimal` | Theoretical Closing Balance | ☐ | Opening balance summed to all cash transactions. | | `cash_register_balance_start` | `decimal` | Starting Balance | ☐ | | | `cash_register_difference` | `decimal` | Before Closing Difference | ☐ | Difference between the theoretical closing balance and the real closing balance. | | `cash_register_total_entry_encoding` | `decimal` | Total Cash Transaction | ☐ | | | `company_id_label` | `string` | | ☐ | | | `company_id` | `string` | | ☐ | | | `config_id_label` | `string` | | ☐ | | | `config_id` | `string` | | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `crm_team_id_label` | `string` | | ☐ | This Point of sale's sales will be related to this Sales Team. | | `crm_team_id` | `string` | | ☐ | This Point of sale's sales will be related to this Sales Team. | | `currency_id_label` | `string` | | ☐ | | | `currency_id` | `string` | | ☐ | | | `display_name` | `string` | 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` | `string` | | ☐ | | | `message_has_error_counter` | `int32` | Number of errors | ☐ | Number of messages with delivery error | | `message_has_error` | `boolean` | Message Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_has_sms_error` | `boolean` | SMS Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_ids` | `string` | | ☐ | | | `message_is_follower` | `boolean` | Is Follower | ☐ | | | `message_main_attachment_id_label` | `string` | | ☐ | | | `message_main_attachment_id` | `string` | | ☐ | | | `message_needaction_counter` | `int32` | Number of Actions | ☐ | Number of messages which requires an action | | `message_needaction` | `boolean` | Action Needed | ☐ | If checked, new messages require your attention. | | `message_partner_ids` | `string` | | ☐ | | | `move_id_label` | `string` | | ☐ | | | `move_id` | `string` | | ☐ | | | `my_activity_date_deadline` | `datetime` | My Activity Deadline | ☐ | | | `name` | `string` | Session ID | ☑ | | | `opening_notes` | `string` | Opening Notes | ☐ | | | `order_count` | `int32` | Order Count | ☐ | | | `order_ids` | `string` | | ☐ | | | `payment_method_ids` | `string` | | ☐ | | | `picking_count` | `int32` | Picking Count | ☐ | | | `picking_ids` | `string` | | ☐ | | | `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` | `string` | Status | ☑ | | | `statement_line_ids` | `string` | | ☐ | | | `stop_at` | `datetime` | Closing Date | ☐ | | | `total_payments_amount` | `decimal` | Total Payments Amount | ☐ | | | `update_stock_at_closing` | `boolean` | Stock should be updated at closing | ☐ | | | `user_id_label` | `string` | | ☐ | | | `user_id` | `string` | | ☐ | | | `website_message_ids` | `string` | | ☐ | Website communication history | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |