Please enable JavaScript to view this site.

Navigation: Schema: product > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer