---
title: "category (Odoo)"
description: "itgen_odoo_category"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.product.category
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.product.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: `product`
- Label: itgen_odoo_category

Product 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 |
|---|---|---|:---:|---|---|
| `child_id` | `varchar2` |  | [ ] |  |  |
| `complete_name` | `varchar2` | Complete Name | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `name` | `varchar2` | Name | [x] |  |  |
| `packaging_reserve_method` | `varchar2` | Reserve Packagings | [ ] |  | Reserve Only Full Packagings: will not reserve partial packagings. If customer orders 2 pallets of 1000 units each and you only have 1600 in stock, then only 1000 will be reserved Reserve Partial Packagings: allow reserving partial packagings. If customer orders 2 pallets of 1000 units each and you only have 1600 in stock, then 1600 will be reserved |
| `parent_id` | `varchar2` |  | [ ] |  |  |
| `parent_id_label` | `varchar2` |  | [ ] |  |  |
| `parent_path` | `varchar2` | Parent Path | [ ] |  |  |
| `product_count` | `int32` | # Products | [ ] |  | The number of products under this category (Does not consider the children categories) |
| `property_account_creditor_price_difference_categ` | `varchar2` |  | [ ] |  | This account will be used to value price difference between purchase price and accounting cost. |
| `property_account_creditor_price_difference_categ_label` | `varchar2` |  | [ ] |  | This account will be used to value price difference between purchase price and accounting cost. |
| `property_account_expense_categ_id` | `varchar2` |  | [ ] |  | The expense is accounted for when a vendor bill is validated, except in anglo-saxon accounting with perpetual inventory valuation in which case the expense (Cost of Goods Sold account) is recognized at the customer invoice validation. |
| `property_account_expense_categ_id_label` | `varchar2` |  | [ ] |  | The expense is accounted for when a vendor bill is validated, except in anglo-saxon accounting with perpetual inventory valuation in which case the expense (Cost of Goods Sold account) is recognized at the customer invoice validation. |
| `property_account_income_categ_id` | `varchar2` |  | [ ] |  | This account will be used when validating a customer invoice. |
| `property_account_income_categ_id_label` | `varchar2` |  | [ ] |  | This account will be used when validating a customer invoice. |
| `property_cost_method` | `varchar2` | Costing Method | [x] |  | Standard Price: The products are valued at their standard cost defined on the product.         Average Cost (AVCO): The products are valued at weighted average cost.         First In First Out (FIFO): The products are valued supposing those that enter the company first will also leave it first.          |
| `property_stock_account_input_categ_id` | `varchar2` |  | [ ] |  | Counterpart journal items for all incoming stock moves will be posted in this account, unless there is a specific valuation account                 set on the source location. This is the default value for all products in this category. It can also directly be set on each product. |
| `property_stock_account_input_categ_id_label` | `varchar2` |  | [ ] |  | Counterpart journal items for all incoming stock moves will be posted in this account, unless there is a specific valuation account                 set on the source location. This is the default value for all products in this category. It can also directly be set on each product. |
| `property_stock_account_output_categ_id` | `varchar2` |  | [ ] |  | When doing automated inventory valuation, counterpart journal items for all outgoing stock moves will be posted in this account,                 unless there is a specific valuation account set on the destination location. This is the default value for all products in this category.                 It can also directly be set on each product. |
| `property_stock_account_output_categ_id_label` | `varchar2` |  | [ ] |  | When doing automated inventory valuation, counterpart journal items for all outgoing stock moves will be posted in this account,                 unless there is a specific valuation account set on the destination location. This is the default value for all products in this category.                 It can also directly be set on each product. |
| `property_stock_journal` | `varchar2` |  | [ ] |  | When doing automated inventory valuation, this is the Accounting Journal in which entries will be automatically posted when stock moves are processed. |
| `property_stock_journal_label` | `varchar2` |  | [ ] |  | When doing automated inventory valuation, this is the Accounting Journal in which entries will be automatically posted when stock moves are processed. |
| `property_stock_valuation_account_id` | `varchar2` |  | [ ] |  | When automated inventory valuation is enabled on a product, this account will hold the current value of the products. |
| `property_stock_valuation_account_id_label` | `varchar2` |  | [ ] |  | When automated inventory valuation is enabled on a product, this account will hold the current value of the products. |
| `property_valuation` | `varchar2` | Inventory Valuation | [x] |  | Manual: The accounting entries to value the inventory are not posted automatically.         Automated: An accounting entry is automatically created to value the inventory when a product enters or leaves the company.          |
| `putaway_rule_ids` | `varchar2` |  | [ ] |  |  |
| `removal_strategy_id` | `varchar2` |  | [ ] |  | Set a specific removal strategy that will be used regardless of the source location for this product category.  FIFO: products/lots that were stocked first will be moved out first. LIFO: products/lots that were stocked last will be moved out first. Closet location: products/lots closest to the target location will be moved out first. FEFO: products/lots with the closest removal date will be moved out first (the availability of this method depends on the "Expiration Dates" setting). |
| `removal_strategy_id_label` | `varchar2` |  | [ ] |  | Set a specific removal strategy that will be used regardless of the source location for this product category.  FIFO: products/lots that were stocked first will be moved out first. LIFO: products/lots that were stocked last will be moved out first. Closet location: products/lots closest to the target location will be moved out first. FEFO: products/lots with the closest removal date will be moved out first (the availability of this method depends on the "Expiration Dates" setting). |
| `route_ids` | `varchar2` |  | [ ] |  |  |
| `total_route_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)

