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_ |
varchar2 |
||||
carrier_ |
varchar2 |
||||
check_ |
varchar2 |
||||
check_ |
varchar2 |
Check State | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
consume_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date |
datetime |
Date | |||
description_ |
varchar2 |
Kit | |||
description_ |
varchar2 |
Description picking | |||
destination_ |
varchar2 |
Destination Country | The ISO country code in two chars. You can use this field for quick search. | ||
display_ |
varchar2 |
Display Name | |||
dummy_ |
varchar2 |
Dummy | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Completed | Check if the quantity done matches the demand | ||
is_ |
boolean |
Is initial demand editable | |||
is_ |
boolean |
Inventory | |||
is_ |
boolean |
Is Locked | |||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
location_ |
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_ |
varchar2 |
||||
location_ |
varchar2 |
||||
location_ |
boolean |
Location Processed | |||
location_ |
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_ |
varchar2 |
||||
lot_ |
varchar2 |
Lot/Serial Number Name | |||
lots_ |
boolean |
Lots Visible | |||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
origin |
varchar2 |
Source | |||
owner_ |
varchar2 |
When validating the transfer, the products will be taken from this owner. | |||
owner_ |
varchar2 |
When validating the transfer, the products will be taken from this owner. | |||
package_ |
varchar2 |
||||
package_ |
varchar2 |
||||
package_ |
varchar2 |
||||
package_ |
varchar2 |
||||
picking_ |
varchar2 |
Type of Operation | |||
picking_ |
varchar2 |
The stock operation where the packing has been made | |||
picking_ |
varchar2 |
The stock operation where the packing has been made | |||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
boolean |
Move Entire Packages | If ticked, you will be able to select entire packages to move | ||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
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_ |
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_ |
varchar2 |
||||
product_ |
varchar2 |
Barcode | International Article Number used for product identification. | ||
product_ |
varchar2 |
Product Category | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Packaging Quantity | Quantity of the Packaging in the UoM of the Stock Move Line. | ||
product_ |
varchar2 |
||||
product_ |
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_ |
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_ |
varchar2 |
||||
product_ |
varchar2 |
||||
production_ |
varchar2 |
||||
production_ |
varchar2 |
||||
qty_ |
numeric |
Done | |||
reference |
varchar2 |
Reference | |||
reserved_ |
numeric |
Real Reserved Quantity | |||
reserved_ |
numeric |
Reserved | |||
result_ |
varchar2 |
If set, the operations are packed into this package | |||
result_ |
varchar2 |
If set, the operations are packed into this package | |||
sale_ |
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_ |
varchar2 |
||||
workorder_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: