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

# category: Odoo itgen_odoo_category

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `approval`
- Label: itgen_odoo_category

Approval Category

Can only retrieve data.

## Table Columns

The columns of the table `category` 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 |
|---|---|---|:---:|---|---|
| `active` | `boolean` | Active | [ ] |  |  |
| `approval_minimum` | `int32` | Minimum Approval | [x] |  |  |
| `approval_type` | `varchar2` | Approval Type | [ ] |  | Allows you to define which documents you would like to create once the request has been approved |
| `approver_ids` | `varchar2` |  | [ ] |  |  |
| `approver_sequence` | `boolean` | Approvers Sequence? | [ ] |  | If checked, the approvers have to approve in sequence (one after the other). If Employee's Manager is selected as approver, they will be the first in line. |
| `automated_sequence` | `boolean` | Automated Sequence? | [ ] |  | If checked, the Approval Requests will have an automated generated name based on the given code. |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `has_amount` | `varchar2` | Has Amount | [x] |  |  |
| `has_date` | `varchar2` | Has Date | [x] |  |  |
| `has_location` | `varchar2` | Has Location | [x] |  |  |
| `has_partner` | `varchar2` | Has Contact | [x] |  |  |
| `has_payment_method` | `varchar2` | Has Payment | [x] |  |  |
| `has_period` | `varchar2` | Has Period | [x] |  |  |
| `has_product` | `varchar2` | Has Product | [x] |  | Additional products that should be specified on the request. |
| `has_quantity` | `varchar2` | Has Quantity | [x] |  |  |
| `has_reference` | `varchar2` | Has Reference | [x] |  | An additional reference that should be specified on the request. |
| `id` | `int32` | ID | [ ] |  |  |
| `image` | `varbinary` | Image | [ ] |  |  |
| `invalid_minimum` | `boolean` | Invalid Minimum | [ ] |  |  |
| `invalid_minimum_warning` | `varchar2` | Invalid Minimum Warning | [ ] |  |  |
| `manager_approval` | `varchar2` | Employee's Manager | [ ] |  | How the employee's manager interacts with this type of approval.          Empty: do nothing         Is Approver: the employee's manager will be in the approver list         Is Required Approver: the employee's manager will be required to approve the request.      |
| `name` | `varchar2` | Name | [x] |  |  |
| `request_to_validate_count` | `int32` | Number of requests to validate | [ ] |  |  |
| `requirer_document` | `varchar2` | Documents | [x] |  |  |
| `sequence` | `int32` | Sequence | [ ] |  |  |
| `sequence_code` | `varchar2` | Code | [ ] |  |  |
| `sequence_id` | `varchar2` |  | [ ] |  |  |
| `sequence_id_label` | `varchar2` |  | [ ] |  |  |
| `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)

