invantive documentation
Forum di supporto InvantiveAccedi / Registrati

category: Odoo itgen_odoo_category

read only per partition

  • Catalogo: Odoo
  • Schema: product
  • Etichetta: itgen_odoo_category

Categoria del prodotto

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella category. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
child_id varchar2
complete_name varchar2 Complete Name
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
display_name varchar2 Nome visualizzato
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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: