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