stock_move

81 rows


Description

Stock Move

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_move_id_seq'::regclass)
account_analytic_line_stock_move_rel.stock_move_id account_analytic_line_stock_move_rel_stock_move_id_fkey C
account_move.stock_move_id account_move_stock_move_id_fkey N
product_label_layout_stock_move_rel.stock_move_id product_label_layout_stock_move_rel_stock_move_id_fkey C
stock_assign_serial.move_id stock_assign_serial_move_id_fkey N
stock_move.origin_returned_move_id stock_move_origin_returned_move_id_fkey N
stock_move_created_purchase_line_rel.move_id stock_move_created_purchase_line_rel_move_id_fkey C
stock_move_line.move_id stock_move_line_move_id_fkey N
stock_move_move_rel.move_dest_id stock_move_move_rel_move_dest_id_fkey C
stock_move_move_rel.move_orig_id stock_move_move_rel_move_orig_id_fkey C
stock_return_picking_line.move_id stock_return_picking_line_move_id_fkey N
stock_route_move.move_id stock_route_move_move_id_fkey C
stock_valuation_layer.stock_move_id stock_valuation_layer_stock_move_id_fkey N
sequence int4 10 √ null

Sequence
company_id int4 10 null
res_company.id stock_move_company_id_fkey R

Company
product_id int4 10 null
product_product.id stock_move_product_id_fkey R

Product
product_uom int4 10 null
uom_uom.id stock_move_product_uom_fkey R

UoM
location_id int4 10 null
stock_location.id stock_move_location_id_fkey R

Source Location
location_dest_id int4 10 null
stock_location.id stock_move_location_dest_id_fkey R

Destination Location
partner_id int4 10 √ null
res_partner.id stock_move_partner_id_fkey N

Destination Address
picking_id int4 10 √ null
stock_picking.id stock_move_picking_id_fkey N

Transfer
scrap_id int4 10 √ null
stock_scrap.id stock_move_scrap_id_fkey N

Scrap operation
group_id int4 10 √ null
procurement_group.id stock_move_group_id_fkey N

Procurement Group
rule_id int4 10 √ null
stock_rule.id stock_move_rule_id_fkey R

Stock Rule
picking_type_id int4 10 √ null
stock_picking_type.id stock_move_picking_type_id_fkey N

Operation Type
origin_returned_move_id int4 10 √ null
stock_move.id stock_move_origin_returned_move_id_fkey N

Origin return move
restrict_partner_id int4 10 √ null
res_partner.id stock_move_restrict_partner_id_fkey N

Owner
warehouse_id int4 10 √ null
stock_warehouse.id stock_move_warehouse_id_fkey N

Warehouse
package_level_id int4 10 √ null
stock_package_level.id stock_move_package_level_id_fkey N

Package Level
next_serial_count int4 10 √ null

Number of SN
orderpoint_id int4 10 √ null
stock_warehouse_orderpoint.id stock_move_orderpoint_id_fkey N

Original Reordering Rule
product_packaging_id int4 10 √ null
product_packaging.id stock_move_product_packaging_id_fkey N

Packaging
create_uid int4 10 √ null
res_users.id stock_move_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Description
priority varchar 2147483647 √ null

Priority
state varchar 2147483647 √ null

Status
origin varchar 2147483647 √ null

Source Document
procure_method varchar 2147483647 null

Supply Method
reference varchar 2147483647 √ null

Reference
next_serial varchar 2147483647 √ null

First SN
reservation_date date 13 √ null

Date to Reserve
description_picking text 2147483647 √ null

Description of Picking
product_qty numeric 0 √ null

Real Quantity
product_uom_qty numeric 0 null

Demand
quantity numeric 0 √ null

Quantity
picked bool 1 √ null

Picked
scrapped bool 1 √ null

Scrapped
propagate_cancel bool 1 √ null

Propagate cancel and split
is_inventory bool 1 √ null

Inventory
additional bool 1 √ null

Whether the move was added after the picking’s confirmation
date timestamp 29,6 null

Date Scheduled
date_deadline timestamp 29,6 √ null

Deadline
delay_alert_date timestamp 29,6 √ null

Delay Alert Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
price_unit float8 17,17 √ null

Unit Price
is_done bool 1 √ null
unit_factor float8 17,17 √ null
created_production_id int4 10 √ null
mrp_production.id stock_move_created_production_id_fkey N

Created Production Order
production_id int4 10 √ null
mrp_production.id stock_move_production_id_fkey N

Production Order for finished products
raw_material_production_id int4 10 √ null
mrp_production.id stock_move_raw_material_production_id_fkey N

Production Order for components
unbuild_id int4 10 √ null
mrp_unbuild.id stock_move_unbuild_id_fkey N

Disassembly Order
consume_unbuild_id int4 10 √ null
mrp_unbuild.id stock_move_consume_unbuild_id_fkey N

Consumed Disassembly Order
operation_id int4 10 √ null
mrp_routing_workcenter.id stock_move_operation_id_fkey N

Operation To Consume
workorder_id int4 10 √ null
mrp_workorder.id stock_move_workorder_id_fkey N

Work Order To Consume
bom_line_id int4 10 √ null
mrp_bom_line.id stock_move_bom_line_id_fkey N

BoM Line
byproduct_id int4 10 √ null
mrp_bom_byproduct.id stock_move_byproduct_id_fkey N

By-products
order_finished_lot_id int4 10 √ null
stock_lot.id stock_move_order_finished_lot_id_fkey N

Finished Lot/Serial Number
cost_share numeric 0 √ null

Cost Share (%)
manual_consumption bool 1 √ null

Manual Consumption
to_refund bool 1 √ null

Update quantities on SO/PO
purchase_line_id int4 10 √ null
purchase_order_line.id stock_move_purchase_line_id_fkey N

Purchase Order Line
sale_line_id int4 10 √ null
sale_order_line.id stock_move_sale_line_id_fkey N

Sale Line

Indexes

Constraint Name Type Sort Column(s)
stock_move_pkey Primary key Asc id
stock_move__company_id_index Performance Asc company_id
stock_move__created_production_id_index Performance Asc created_production_id
stock_move__date_index Performance Asc date
stock_move__group_id_index Performance Asc group_id
stock_move__location_dest_id_index Performance Asc location_dest_id
stock_move__location_id_index Performance Asc location_id
stock_move__order_finished_lot_id_index Performance Asc order_finished_lot_id
stock_move__orderpoint_id_index Performance Asc orderpoint_id
stock_move__origin_returned_move_id_index Performance Asc origin_returned_move_id
stock_move__partner_id_index Performance Asc partner_id
stock_move__picking_id_index Performance Asc picking_id
stock_move__product_id_index Performance Asc product_id
stock_move__production_id_index Performance Asc production_id
stock_move__purchase_line_id_index Performance Asc purchase_line_id
stock_move__raw_material_production_id_index Performance Asc raw_material_production_id
stock_move__restrict_partner_id_index Performance Asc restrict_partner_id
stock_move__sale_line_id_index Performance Asc sale_line_id
stock_move__state_index Performance Asc state
stock_move__workorder_id_index Performance Asc workorder_id
stock_move_product_location_index Performance Asc/Asc/Asc/Asc/Asc product_id + location_id + location_dest_id + company_id + state

Relationships

Close relationships within degrees of separation