invantive documentation
Invantive Support ForumsLog In / Sign Up

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
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 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 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: