Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: stock > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer