invantive documentation
Invantive Support ForumsLog In / Sign Up

move: Odoo itgen_odoo_move

read only per partition

  • Catalog: Odoo
  • Schema: stock
  • Label: itgen_odoo_move

Stock Move

Can only retrieve data.

Table Columns

The columns of the table move 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
account_move_ids varchar2
additional boolean Whether the move was added after the picking's confirmation
allowed_operation_ids varchar2
analytic_account_line_id varchar2
analytic_account_line_id_label varchar2
availability numeric Forecasted Quantity Quantity in stock that can still be reserved for this move
bom_line_id varchar2
bom_line_id_label varchar2
byproduct_id varchar2 By-product line that generated the move in a manufacturing order
byproduct_id_label varchar2 By-product line that generated the move in a manufacturing order
company_id varchar2
company_id_label varchar2
consume_unbuild_id varchar2
consume_unbuild_id_label varchar2
cost_share numeric 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 varchar2
create_uid_label varchar2
created_production_id varchar2
created_production_id_label varchar2
created_purchase_line_ids varchar2
date datetime Date Scheduled Scheduled date until move is done, then date of actual move processing
date_deadline datetime Deadline Date Promise to the customer on the top level document (SO/PO)
delay_alert_date datetime Delay Alert Date Process at this date to be on time
description_bom_line varchar2 Kit
description_picking varchar2 Description of Picking
display_assign_serial boolean Display Assign Serial
display_clear_serial boolean Display Clear Serial
display_name varchar2 Display Name
forecast_availability numeric Forecast Availability
forecast_expected_date datetime Forecasted Expected date
from_immediate_transfer boolean Immediate Transfer
group_id varchar2
group_id_label varchar2
has_tracking varchar2 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 varchar2 Location where the system will stock the finished products.
location_dest_id_label varchar2 Location where the system will stock the finished products.
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 Sets a location if you produce at a fixed location. This can be a partner location if you subcontract the manufacturing operations.
location_id_label varchar2 Sets a location if you produce at a fixed location. This can be a partner location if you subcontract the manufacturing operations.
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_ids varchar2
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 varchar2 Optional: next stock move when chaining them
move_line_ids varchar2
move_line_nosuggest_ids varchar2
move_lines_count int32 Move Lines Count
move_orig_ids varchar2 Optional: previous stock move when chaining them
name varchar2 Description
next_serial varchar2 First SN
next_serial_count int32 Number of SN
operation_id varchar2
operation_id_label varchar2
order_finished_lot_id varchar2
order_finished_lot_id_label varchar2
orderpoint_id varchar2
orderpoint_id_label varchar2
origin varchar2 Source Document
origin_returned_move_id varchar2 Move that created the return move
origin_returned_move_id_label varchar2 Move that created the return move
package_level_id varchar2
package_level_id_label varchar2
partner_id varchar2 Optional address where goods are to be delivered, specifically used for allotment
partner_id_label varchar2 Optional address where goods are to be delivered, specifically used for allotment
picking_code varchar2 Type of Operation
picking_id varchar2
picking_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
price_unit numeric Unit Price
priority varchar2 Priority
procure_method varchar2 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 varchar2
product_id_label varchar2
product_packaging_id varchar2
product_packaging_id_label varchar2
product_qty numeric Real Quantity Quantity in the default UoM of the product
product_qty_available numeric 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_tmpl_id varchar2
product_tmpl_id_label varchar2
product_type varchar2 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 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_label varchar2
product_uom_qty numeric 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_virtual_available numeric 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 varchar2
production_id_label varchar2
propagate_cancel boolean Propagate cancel and split If checked, when this move is cancelled, cancel the linked move too
purchase_line_id varchar2
purchase_line_id_label varchar2
quantity_done numeric Quantity Done
raw_material_production_id varchar2
raw_material_production_id_label varchar2
reference varchar2 Reference
repair_id varchar2
repair_id_label varchar2
reservation_date datetime Date to Reserve Computes when a move should be reserved
reserved_availability numeric Quantity Reserved Quantity that has already been reserved for this move
restrict_partner_id varchar2
restrict_partner_id_label varchar2
returned_move_ids varchar2 Optional: all returned moves created from this move
route_ids varchar2 Preferred route
rule_id varchar2 The stock rule that created this stock move
rule_id_label varchar2 The stock rule that created this stock move
sale_line_id varchar2
sale_line_id_label varchar2
scrap_ids varchar2
scrapped boolean Scrapped Check this box to allow using this location to put scrapped/damaged goods.
sequence int32 Sequence
should_consume_qty numeric 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 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'.
stock_valuation_layer_ids varchar2
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 varchar2
unbuild_id_label varchar2
unit_factor numeric Unit Factor
warehouse_id varchar2 the warehouse to consider for the route selection on the next procurement (if any).
warehouse_id_label varchar2 the warehouse to consider for the route selection on the next procurement (if any).
weight numeric Weight
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: