move |
Stock Move
Catalog: Odoo
Schema: stock
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table move are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
account_move_ids |
string |
|
☐ |
|
additional |
boolean |
Whether the move was added after the picking's confirmation |
☐ |
|
allowed_operation_ids |
string |
|
☐ |
|
analytic_account_line_id_label |
string |
|
☐ |
|
analytic_account_line_id |
string |
|
☐ |
|
availability |
decimal |
Forecasted Quantity |
☐ |
Quantity in stock that can still be reserved for this move |
bom_line_id_label |
string |
|
☐ |
|
bom_line_id |
string |
|
☐ |
|
byproduct_id_label |
string |
|
☐ |
By-product line that generated the move in a manufacturing order |
byproduct_id |
string |
|
☐ |
By-product line that generated the move in a manufacturing order |
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
consume_unbuild_id_label |
string |
|
☐ |
|
consume_unbuild_id |
string |
|
☐ |
|
cost_share |
decimal |
Cost Share (%) |
☐ |
The percentage of the final production cost for this by-product. The total of all by-products' cost share must be smaller or equal to 100. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
created_production_id_label |
string |
|
☐ |
|
created_production_id |
string |
|
☐ |
|
created_purchase_line_ids |
string |
|
☐ |
|
date_deadline |
datetime |
Deadline |
☐ |
Date Promise to the customer on the top level document (SO/PO) |
date |
datetime |
Date Scheduled |
☑ |
Scheduled date until move is done, then date of actual move processing |
delay_alert_date |
datetime |
Delay Alert Date |
☐ |
Process at this date to be on time |
description_bom_line |
string |
Kit |
☐ |
|
description_picking |
string |
Description of Picking |
☐ |
|
display_assign_serial |
boolean |
Display Assign Serial |
☐ |
|
display_clear_serial |
boolean |
Display Clear Serial |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
forecast_availability |
decimal |
Forecast Availability |
☐ |
|
forecast_expected_date |
datetime |
Forecasted Expected date |
☐ |
|
from_immediate_transfer |
boolean |
Immediate Transfer |
☐ |
|
group_id_label |
string |
|
☐ |
|
group_id |
string |
|
☐ |
|
has_tracking |
string |
Product with Tracking |
☐ |
Ensure the traceability of a storable product in your warehouse. |
id |
int32 |
ID |
☐ |
|
is_done |
boolean |
Done |
☐ |
|
is_initial_demand_editable |
boolean |
Is initial demand editable |
☐ |
|
is_inventory |
boolean |
Inventory |
☐ |
|
is_locked |
boolean |
Is Locked |
☐ |
|
is_quantity_done_editable |
boolean |
Is quantity done editable |
☐ |
|
location_dest_id_label |
string |
|
☐ |
Location where the system will stock the finished products. |
location_dest_id |
string |
|
☐ |
Location where the system will stock the finished products. |
location_dest_usage |
string |
Destination Location Type |
☐ |
* Vendor Location: Virtual location representing the source location for products coming from your vendors* View: Virtual location used to create a hierarchical structures for your warehouse, aggregating its child locations ; can't directly contain products* Internal Location: Physical locations inside your own warehouses,* Customer Location: Virtual location representing the destination location for products sent to your customers* Inventory Loss: Virtual location serving as counterpart for inventory operations used to correct stock levels (Physical inventories)* Production: Virtual counterpart location for production operations: this location consumes the components and produces finished products* Transit Location: Counterpart location that should be used in inter-company or inter-warehouses operations |
location_id_label |
string |
|
☐ |
Sets a location if you produce at a fixed location. This can be a partner location if you subcontract the manufacturing operations. |
location_id |
string |
|
☐ |
Sets a location if you produce at a fixed location. This can be a partner location if you subcontract the manufacturing operations. |
location_usage |
string |
Source Location Type |
☐ |
* Vendor Location: Virtual location representing the source location for products coming from your vendors* View: Virtual location used to create a hierarchical structures for your warehouse, aggregating its child locations ; can't directly contain products* Internal Location: Physical locations inside your own warehouses,* Customer Location: Virtual location representing the destination location for products sent to your customers* Inventory Loss: Virtual location serving as counterpart for inventory operations used to correct stock levels (Physical inventories)* Production: Virtual counterpart location for production operations: this location consumes the components and produces finished products* Transit Location: Counterpart location that should be used in inter-company or inter-warehouses operations |
lot_ids |
string |
|
☐ |
|
manual_consumption |
boolean |
Manual Consumption |
☐ |
When activated, then the registration of consumption for that component is recorded manually exclusively.If not activated, and any of the components consumption is edited manually on the manufacturing order, Odoo assumes manual consumption also. |
move_dest_ids |
string |
|
☐ |
Optional: next stock move when chaining them |
move_line_ids |
string |
|
☐ |
|
move_line_nosuggest_ids |
string |
|
☐ |
|
move_lines_count |
int32 |
Move Lines Count |
☐ |
|
move_orig_ids |
string |
|
☐ |
Optional: previous stock move when chaining them |
name |
string |
Description |
☑ |
|
next_serial_count |
int32 |
Number of SN |
☐ |
|
next_serial |
string |
First SN |
☐ |
|
operation_id_label |
string |
|
☐ |
|
operation_id |
string |
|
☐ |
|
order_finished_lot_id_label |
string |
|
☐ |
|
order_finished_lot_id |
string |
|
☐ |
|
orderpoint_id_label |
string |
|
☐ |
|
orderpoint_id |
string |
|
☐ |
|
origin_returned_move_id_label |
string |
|
☐ |
Move that created the return move |
origin_returned_move_id |
string |
|
☐ |
Move that created the return move |
origin |
string |
Source Document |
☐ |
|
package_level_id_label |
string |
|
☐ |
|
package_level_id |
string |
|
☐ |
|
partner_id_label |
string |
|
☐ |
Optional address where goods are to be delivered, specifically used for allotment |
partner_id |
string |
|
☐ |
Optional address where goods are to be delivered, specifically used for allotment |
picking_code |
string |
Type of Operation |
☐ |
|
picking_id_label |
string |
|
☐ |
|
picking_id |
string |
|
☐ |
|
picking_type_entire_packs |
boolean |
Move Entire Packages |
☐ |
If ticked, you will be able to select entire packages to move |
picking_type_id_label |
string |
|
☐ |
|
picking_type_id |
string |
|
☐ |
|
price_unit |
decimal |
Unit Price |
☐ |
|
priority |
string |
Priority |
☐ |
|
procure_method |
string |
Supply Method |
☑ |
By default, the system will take from the stock in the source location and passively wait for availability. The other possibility allows you to directly create a procurement on the source location (and thus ignore its current stock) to gather products. If we want to chain moves and have this one to wait for the previous, this second option should be chosen. |
product_id_label |
string |
|
☐ |
|
product_id |
string |
|
☐ |
|
product_packaging_id_label |
string |
|
☐ |
|
product_packaging_id |
string |
|
☐ |
|
product_qty_available |
decimal |
Product On Hand Quantity |
☐ |
Current quantity of products.In a context with a single Stock Location, this includes goods stored at this Location, or any of its children.In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children.stored in the Stock Location of the Warehouse of this Shop, or any of its children.Otherwise, this includes goods stored in any Stock Location with 'internal' type. |
product_qty |
decimal |
Real Quantity |
☐ |
Quantity in the default UoM of the product |
product_tmpl_id_label |
string |
|
☐ |
|
product_tmpl_id |
string |
|
☐ |
|
product_type |
string |
Product Type |
☐ |
A storable product is a product for which you manage stock. The Inventory app has to be installed.A consumable product is a product for which stock is not managed.A service is a non-material product you provide. |
product_uom_category_id_label |
string |
|
☐ |
Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios. |
product_uom_category_id |
string |
|
☐ |
Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios. |
product_uom_label |
string |
|
☐ |
|
product_uom_qty |
decimal |
Demand |
☑ |
This is the quantity of products from an inventory point of view. For moves in the state 'done', this is the quantity of products that were actually moved. For other moves, this is the quantity of product that is planned to be moved. Lowering this quantity does not generate a backorder. Changing this quantity on assigned moves affects the product reservation, and should be done with care. |
product_uom |
string |
|
☐ |
|
product_virtual_available |
decimal |
Product Forecasted Quantity |
☐ |
Forecast quantity (computed as Quantity On Hand - Outgoing + Incoming)In a context with a single Stock Location, this includes goods stored in this location, or any of its children.In a context with a single Warehouse, this includes goods stored in the Stock Location of this Warehouse, or any of its children.Otherwise, this includes goods stored in any Stock Location with 'internal' type. |
production_id_label |
string |
|
☐ |
|
production_id |
string |
|
☐ |
|
propagate_cancel |
boolean |
Propagate cancel and split |
☐ |
If checked, when this move is cancelled, cancel the linked move too |
purchase_line_id_label |
string |
|
☐ |
|
purchase_line_id |
string |
|
☐ |
|
quantity_done |
decimal |
Quantity Done |
☐ |
|
raw_material_production_id_label |
string |
|
☐ |
|
raw_material_production_id |
string |
|
☐ |
|
reference |
string |
Reference |
☐ |
|
repair_id_label |
string |
|
☐ |
|
repair_id |
string |
|
☐ |
|
reservation_date |
datetime |
Date to Reserve |
☐ |
Computes when a move should be reserved |
reserved_availability |
decimal |
Quantity Reserved |
☐ |
Quantity that has already been reserved for this move |
restrict_partner_id_label |
string |
|
☐ |
|
restrict_partner_id |
string |
|
☐ |
|
returned_move_ids |
string |
|
☐ |
Optional: all returned moves created from this move |
route_ids |
string |
|
☐ |
Preferred route |
rule_id_label |
string |
|
☐ |
The stock rule that created this stock move |
rule_id |
string |
|
☐ |
The stock rule that created this stock move |
sale_line_id_label |
string |
|
☐ |
|
sale_line_id |
string |
|
☐ |
|
scrap_ids |
string |
|
☐ |
|
scrapped |
boolean |
Scrapped |
☐ |
Check this box to allow using this location to put scrapped/damaged goods. |
sequence |
int32 |
Sequence |
☐ |
|
should_consume_qty |
decimal |
Quantity To Consume |
☐ |
|
show_details_visible |
boolean |
Details Visible |
☐ |
|
show_operations |
boolean |
Show Detailed Operations |
☐ |
If this checkbox is ticked, the pickings lines will represent detailed stock operations. If not, the picking lines will represent an aggregate of detailed stock operations. |
show_reserved_availability |
boolean |
From Supplier |
☐ |
|
state |
string |
Status |
☐ |
* New: When the stock move is created and not yet confirmed.* Waiting Another Move: This state can be seen when a move is waiting for another one, for example in a chained flow.* Waiting Availability: This state is reached when the procurement resolution is not straight forward. It may need the scheduler to run, a component to be manufactured...* Available: When products are reserved, it is set to 'Available'.* Done: When the shipment is processed, the state is 'Done'. |
stock_valuation_layer_ids |
string |
|
☐ |
|
to_refund |
boolean |
Update quantities on SO/PO |
☐ |
Trigger a decrease of the delivered/received quantity in the associated Sale Order/Purchase Order |
unbuild_id_label |
string |
|
☐ |
|
unbuild_id |
string |
|
☐ |
|
unit_factor |
decimal |
Unit Factor |
☐ |
|
warehouse_id_label |
string |
|
☐ |
the warehouse to consider for the route selection on the next procurement (if any). |
warehouse_id |
string |
|
☐ |
the warehouse to consider for the route selection on the next procurement (if any). |
weight |
decimal |
Weight |
☐ |
|
workorder_id_label |
string |
|
☐ |
|
workorder_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826