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

# device: Odoo itgen_odoo_device

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `iot`
- Label: itgen_odoo_device

IOT Device

Can only retrieve data.

## Table Columns

The columns of the table `device` 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 |
|---|---|---|:---:|---|---|
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `connected` | `boolean` | Status | [ ] |  | If device is connected to the IoT Box |
| `connection` | `varchar2` | Connection | [ ] |  | Type of connection. |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `display_url` | `varchar2` | Display URL | [ ] |  | URL of the page that will be displayed by the device, leave empty to use the customer facing display of the POS. |
| `id` | `int32` | ID | [ ] |  |  |
| `identifier` | `varchar2` | Identifier | [ ] |  |  |
| `iot_id` | `varchar2` |  | [ ] |  |  |
| `iot_id_label` | `varchar2` |  | [ ] |  |  |
| `iot_ip` | `varchar2` | Domain Address | [ ] |  |  |
| `is_scanner` | `boolean` | Is Scanner | [ ] |  | Manually switch the device type between keyboard and scanner |
| `keyboard_layout` | `varchar2` |  | [ ] |  |  |
| `keyboard_layout_label` | `varchar2` |  | [ ] |  |  |
| `manual_measurement` | `boolean` | Manual Measurement | [ ] |  | Manually read the measurement from the device |
| `manufacturer` | `varchar2` | Manufacturer | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `picking_type_ids` | `varchar2` |  | [ ] |  |  |
| `qcp_test_type` | `varchar2` | Qcp Test Type | [ ] |  |  |
| `quality_point_ids` | `varchar2` |  | [ ] |  |  |
| `report_ids` | `varchar2` |  | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  | Type of device. |
| `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)

