invantive documentation
Forum di supporto InvantiveAccedi / Registrati

quant: Odoo itgen_odoo_quant

read only per partition

  • Catalogo: Odoo
  • Schema: stock
  • Etichetta: itgen_odoo_quant

Quants

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella quant. 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
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 Quantità disponibile 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 Creato il
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 Nome visualizzato
dummy_id varchar2 Dummy
id int32 ID
in_date datetime Incoming Date
inventory_date datetime Data programmata 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 Disponibile
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 Quantità riservata 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

Note di rilascio

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