Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: stock > Tables

move_line

Product Moves (Stock Move Line)

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_line are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

carrier_id_label

string

 

 

carrier_id

string

 

 

check_ids

string

 

 

check_state

string

Check State

 

company_id_label

string

 

 

company_id

string

 

 

consume_line_ids

string

 

 

create_date

datetime

Created on

 

create_uid_label

string

 

 

create_uid

string

 

 

date

datetime

Date

 

description_bom_line

string

Kit

 

description_picking

string

Description picking

 

destination_country_code

string

Destination Country

The ISO country code in two chars. You can use this field for quick search.

display_name

string

Display Name

 

dummy_id

string

Dummy

 

id

int32

ID

 

is_completed

boolean

Is Completed

Check if the quantity done matches the demand

is_initial_demand_editable

boolean

Is initial demand editable

 

is_inventory

boolean

Inventory

 

is_locked

boolean

Is Locked

 

location_dest_id_label

string

 

 

location_dest_id

string

 

 

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

 

 

location_id

string

 

 

location_processed

boolean

Location Processed

 

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_id_label

string

 

 

lot_id

string

 

 

lot_name

string

Lot/Serial Number Name

 

lots_visible

boolean

Lots Visible

 

move_id_label

string

 

 

move_id

string

 

 

origin

string

Source

 

owner_id_label

string

 

When validating the transfer, the products will be taken from this owner.

owner_id

string

 

When validating the transfer, the products will be taken from this owner.

package_id_label

string

 

 

package_id

string

 

 

package_level_id_label

string

 

 

package_level_id

string

 

 

picking_code

string

Type of Operation

 

picking_id_label

string

 

The stock operation where the packing has been made

picking_id

string

 

The stock operation where the packing has been made

picking_location_dest_id_label

string

 

 

picking_location_dest_id

string

 

 

picking_location_id_label

string

 

 

picking_location_id

string

 

 

picking_partner_id_label

string

 

 

picking_partner_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

 

 

picking_type_use_create_lots

boolean

Create New Lots/Serial Numbers

If this is checked only, it will suppose you want to create new Lots/Serial Numbers, so you can provide them in a text field.

picking_type_use_existing_lots

boolean

Use Existing Lots/Serial Numbers

If this is checked, you will be able to choose the Lots/Serial Numbers. You can also decide to not put lots in this operation type. This means it will create stock with no lot or not put a restriction on the lot taken.

produce_line_ids

string

 

 

product_barcode

string

Barcode

International Article Number used for product identification.

product_category_name

string

Product Category

 

product_id_label

string

 

 

product_id

string

 

 

product_packaging_id_label

string

 

 

product_packaging_id

string

 

 

product_packaging_uom_qty

decimal

Packaging Quantity

Quantity of the Packaging in the UoM of the Stock Move Line.

product_stock_quant_ids

string

 

 

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_id_label

string

 

 

product_uom_id

string

 

 

production_id_label

string

 

 

production_id

string

 

 

qty_done

decimal

Done

 

reference

string

Reference

 

reserved_qty

decimal

Real Reserved Quantity

 

reserved_uom_qty

decimal

Reserved

 

result_package_id_label

string

 

If set, the operations are packed into this package

result_package_id

string

 

If set, the operations are packed into this package

sale_price

decimal

Sale Price

 

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'.

tracking

string

Tracking

Ensure the traceability of a storable product in your warehouse.

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