stock_move_line

62 rows


Description

Product Moves (Stock Move Line)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_move_line_id_seq'::regclass)
lot_label_layout_stock_move_line_rel.stock_move_line_id lot_label_layout_stock_move_line_rel_stock_move_line_id_fkey C
stock_move_line_consume_rel.consume_line_id stock_move_line_consume_rel_consume_line_id_fkey C
stock_move_line_consume_rel.produce_line_id stock_move_line_consume_rel_produce_line_id_fkey C
picking_id int4 10 √ null
stock_picking.id stock_move_line_picking_id_fkey N

Transfer
move_id int4 10 √ null
stock_move.id stock_move_line_move_id_fkey N

Stock Operation
company_id int4 10 null
res_company.id stock_move_line_company_id_fkey R

Company
product_id int4 10 √ null
product_product.id stock_move_line_product_id_fkey C

Product
product_uom_id int4 10 null
uom_uom.id stock_move_line_product_uom_id_fkey R

Unit of Measure
package_id int4 10 √ null
stock_quant_package.id stock_move_line_package_id_fkey R

Source Package
package_level_id int4 10 √ null
stock_package_level.id stock_move_line_package_level_id_fkey N

Package Level
lot_id int4 10 √ null
stock_lot.id stock_move_line_lot_id_fkey N

Lot/Serial Number
result_package_id int4 10 √ null
stock_quant_package.id stock_move_line_result_package_id_fkey R

Destination Package
owner_id int4 10 √ null
res_partner.id stock_move_line_owner_id_fkey N

From Owner
location_id int4 10 null
stock_location.id stock_move_line_location_id_fkey R

From
location_dest_id int4 10 null
stock_location.id stock_move_line_location_dest_id_fkey R

To
create_uid int4 10 √ null
res_users.id stock_move_line_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id stock_move_line_write_uid_fkey N

Last Updated by
product_category_name varchar 2147483647 √ null

Product Category
lot_name varchar 2147483647 √ null

Lot/Serial Number Name
state varchar 2147483647 √ null

Status
reference varchar 2147483647 √ null

Reference
description_picking text 2147483647 √ null

Description picking
quantity numeric 0 √ null

Quantity
quantity_product_uom numeric 0 √ null

Quantity in Product UoM
picked bool 1 √ null

Picked
date timestamp 29,6 null

Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
workorder_id int4 10 √ null
mrp_workorder.id stock_move_line_workorder_id_fkey N

Work Order
production_id int4 10 √ null
mrp_production.id stock_move_line_production_id_fkey N

Production Order

Indexes

Constraint Name Type Sort Column(s)
stock_move_line_pkey Primary key Asc id
stock_move_line__company_id_index Performance Asc company_id
stock_move_line__move_id_index Performance Asc move_id
stock_move_line__owner_id_index Performance Asc owner_id
stock_move_line__picking_id_index Performance Asc picking_id
stock_move_line__product_id_index Performance Asc product_id
stock_move_line_free_reservation_index Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc id + company_id + product_id + lot_id + location_id + owner_id + package_id

Relationships

Close relationships within degrees of separation