invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

quant: Odoo itgen_odoo_quant

read only per partition

  • Catálogo: Odoo
  • Esquema: stock
  • Etiqueta: itgen_odoo_quant

Quants

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla quant. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
accounting_date datetime Accounting Date Date at which the accounting entries will be created in case of automated inventory valuation.If empty, the inventory date will be used.
available_quantity numeric Cantidad disponible On hand quantity which hasn't been reserved on a transfer, in the default unit of measure of the product
company_id varchar2 Let this field empty if this location is shared between companies
company_id_label varchar2 Let this field empty if this location is shared between companies
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.
create_date datetime Creado en
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
cyclic_inventory_frequency int32 Inventory Frequency (Days) When different than 0, inventory count date for products stored at this location will be automatically set at the defined frequency.
display_name varchar2 Nombre para mostrar
dummy_id varchar2 Dummy
id int32 ID
in_date datetime Incoming Date
inventory_date datetime Fecha Programada Next date the On Hand Quantity should be counted.
inventory_diff_quantity numeric Difference Indicates the gap between the product's theoretical quantity and its counted quantity.
inventory_quantity numeric Counted Quantity The product's counted quantity.
inventory_quantity_auto_apply numeric Inventoried Quantity
inventory_quantity_set boolean Inventory Quantity Set
is_outdated boolean Quantity has been moved since last count
last_count_date datetime Last Count Date Last time the Quantity was Updated
location_id varchar2
location_id_label varchar2
lot_id varchar2
lot_id_label varchar2
on_hand boolean En stock
owner_id varchar2 This is the owner of the quant
owner_id_label varchar2 This is the owner of the quant
package_id varchar2 The package containing this quant
package_id_label varchar2 The package containing this quant
priority varchar2 Favorite
product_categ_id varchar2
product_categ_id_label varchar2
product_id varchar2
product_id_label varchar2
product_tmpl_id varchar2
product_tmpl_id_label varchar2
product_uom_id varchar2 Default unit of measure used for all stock operations.
product_uom_id_label varchar2 Default unit of measure used for all stock operations.
quantity numeric Quantity Quantity of products in this quant, in the default unit of measure of the product
reserved_quantity numeric Cantidad reservada Quantity of reserved products in this quant, in the default unit of measure of the product
sn_duplicated boolean Duplicated Serial Number If the same SN is in another Quant
storage_category_id varchar2
storage_category_id_label varchar2
tracking varchar2 Tracking Ensure the traceability of a storable product in your warehouse.
user_id varchar2 User assigned to do product count.
user_id_label varchar2 User assigned to do product count.
value numeric Value
warehouse_id varchar2
warehouse_id_label varchar2
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: