category |
Product Category
Catalog: Odoo
Schema: product
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 category are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
child_id |
string |
|
☐ |
|
complete_name |
string |
Complete Name |
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
name |
string |
Name |
☑ |
|
packaging_reserve_method |
string |
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 reservedReserve 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_label |
string |
|
☐ |
|
parent_id |
string |
|
☐ |
|
parent_path |
string |
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_label |
string |
|
☐ |
This account will be used to value price difference between purchase price and accounting cost. |
property_account_creditor_price_difference_categ |
string |
|
☐ |
This account will be used to value price difference between purchase price and accounting cost. |
property_account_expense_categ_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_label |
string |
|
☐ |
This account will be used when validating a customer invoice. |
property_account_income_categ_id |
string |
|
☐ |
This account will be used when validating a customer invoice. |
property_cost_method |
string |
Costing Method |
☑ |
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_label |
string |
|
☐ |
Counterpart journal items for all incoming stock moves will be posted in this account, unless there is a specific valuation accountset 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 |
string |
|
☐ |
Counterpart journal items for all incoming stock moves will be posted in this account, unless there is a specific valuation accountset 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_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_label |
string |
|
☐ |
When automated inventory valuation is enabled on a product, this account will hold the current value of the products. |
property_stock_valuation_account_id |
string |
|
☐ |
When automated inventory valuation is enabled on a product, this account will hold the current value of the products. |
property_valuation |
string |
Inventory Valuation |
☑ |
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 |
string |
|
☐ |
|
removal_strategy_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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 |
string |
|
☐ |
|
total_route_ids |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826