invantive documentation
Forum di supporto InvantiveAccedi / Registrati

move_line: Odoo itgen_odoo_move_line

read only per partition

  • Catalogo: Odoo
  • Schema: stock
  • Etichetta: itgen_odoo_move_line

Product Moves (Stock Move Line)

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella move_line. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 Creato il
create_uid varchar2
create_uid_label varchar2
date datetime Date
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 Nome visualizzato
dummy_id varchar2 Dummy
id int32 ID
is_completed boolean È completato Check if the quantity done matches the demand
is_initial_demand_editable boolean Is initial demand editable
is_inventory boolean Inventory
is_locked boolean È bloccato
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 Categoria del prodotto
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
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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: