---
title: "move_line (Odoo)"
description: "itgen_odoo_move_line"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.stock.move_line
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.stock.move_line
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# move_line: Odoo itgen_odoo_move_line

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `stock`
- Label: itgen_odoo_move_line

Product Moves (Stock Move Line)

Can only retrieve data.

## Table Columns

The columns of the table `move_line` 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 |
|---|---|---|:---:|---|---|
| `carrier_id` | `varchar2` |  | [ ] |  |  |
| `carrier_id_label` | `varchar2` |  | [ ] |  |  |
| `check_ids` | `varchar2` |  | [ ] |  |  |
| `check_state` | `varchar2` | Check State | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `consume_line_ids` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `date` | `datetime` | Date | [x] |  |  |
| `description_bom_line` | `varchar2` | Kit | [ ] |  |  |
| `description_picking` | `varchar2` | Description picking | [ ] |  |  |
| `destination_country_code` | `varchar2` | Destination Country | [ ] |  | The ISO country code in two chars.  You can use this field for quick search. |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `dummy_id` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `location_dest_id_label` | `varchar2` |  | [ ] |  |  |
| `location_dest_usage` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `location_id_label` | `varchar2` |  | [ ] |  |  |
| `location_processed` | `boolean` | Location Processed | [ ] |  |  |
| `location_usage` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `lot_id_label` | `varchar2` |  | [ ] |  |  |
| `lot_name` | `varchar2` | Lot/Serial Number Name | [ ] |  |  |
| `lots_visible` | `boolean` | Lots Visible | [ ] |  |  |
| `move_id` | `varchar2` |  | [ ] |  |  |
| `move_id_label` | `varchar2` |  | [ ] |  |  |
| `origin` | `varchar2` | Source | [ ] |  |  |
| `owner_id` | `varchar2` |  | [ ] |  | When validating the transfer, the products will be taken from this owner. |
| `owner_id_label` | `varchar2` |  | [ ] |  | When validating the transfer, the products will be taken from this owner. |
| `package_id` | `varchar2` |  | [ ] |  |  |
| `package_id_label` | `varchar2` |  | [ ] |  |  |
| `package_level_id` | `varchar2` |  | [ ] |  |  |
| `package_level_id_label` | `varchar2` |  | [ ] |  |  |
| `picking_code` | `varchar2` | Type of Operation | [ ] |  |  |
| `picking_id` | `varchar2` |  | [ ] |  | The stock operation where the packing has been made |
| `picking_id_label` | `varchar2` |  | [ ] |  | The stock operation where the packing has been made |
| `picking_location_dest_id` | `varchar2` |  | [ ] |  |  |
| `picking_location_dest_id_label` | `varchar2` |  | [ ] |  |  |
| `picking_location_id` | `varchar2` |  | [ ] |  |  |
| `picking_location_id_label` | `varchar2` |  | [ ] |  |  |
| `picking_partner_id` | `varchar2` |  | [ ] |  |  |
| `picking_partner_id_label` | `varchar2` |  | [ ] |  |  |
| `picking_type_entire_packs` | `boolean` | Move Entire Packages | [ ] |  | If ticked, you will be able to select entire packages to move |
| `picking_type_id` | `varchar2` |  | [ ] |  |  |
| `picking_type_id_label` | `varchar2` |  | [ ] |  |  |
| `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` | `varchar2` |  | [ ] |  |  |
| `product_barcode` | `varchar2` | Barcode | [ ] |  | International Article Number used for product identification. |
| `product_category_name` | `varchar2` | Product Category | [ ] |  |  |
| `product_id` | `varchar2` |  | [ ] |  |  |
| `product_id_label` | `varchar2` |  | [ ] |  |  |
| `product_packaging_id` | `varchar2` |  | [ ] |  |  |
| `product_packaging_id_label` | `varchar2` |  | [ ] |  |  |
| `product_packaging_uom_qty` | `numeric` | Packaging Quantity | [ ] |  | Quantity of the Packaging in the UoM of the Stock Move Line. |
| `product_stock_quant_ids` | `varchar2` |  | [ ] |  |  |
| `product_uom_category_id` | `varchar2` |  | [ ] |  | 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_label` | `varchar2` |  | [ ] |  | 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` | `varchar2` |  | [ ] |  |  |
| `product_uom_id_label` | `varchar2` |  | [ ] |  |  |
| `production_id` | `varchar2` |  | [ ] |  |  |
| `production_id_label` | `varchar2` |  | [ ] |  |  |
| `qty_done` | `numeric` | Done | [ ] |  |  |
| `reference` | `varchar2` | Reference | [ ] |  |  |
| `reserved_qty` | `numeric` | Real Reserved Quantity | [ ] |  |  |
| `reserved_uom_qty` | `numeric` | Reserved | [x] |  |  |
| `result_package_id` | `varchar2` |  | [ ] |  | If set, the operations are packed into this package |
| `result_package_id_label` | `varchar2` |  | [ ] |  | If set, the operations are packed into this package |
| `sale_price` | `numeric` | Sale Price | [ ] |  |  |
| `state` | `varchar2` | 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` | `varchar2` | Tracking | [ ] |  | Ensure the traceability of a storable product in your warehouse. |
| `workorder_id` | `varchar2` |  | [ ] |  |  |
| `workorder_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:

- [Odoo](/en/release-notes/drivers?driver=odoo)

