invantive documentation
Invantive Support ForumsLog In / Sign Up

quant: Odoo itgen_odoo_quant

read only per partition

  • Catalog: Odoo
  • Schema: stock
  • Label: itgen_odoo_quant

Quants

Can only retrieve data.

Table Columns

The columns of the table quant 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
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 Available Quantity 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 Created on
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 Display Name
dummy_id varchar2 Dummy
id int32 ID
in_date datetime Incoming Date
inventory_date datetime Scheduled Date 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 On Hand
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 Reserved Quantity 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

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: