stock_picking

25 rows


Description

Transfer

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_picking_id_seq'::regclass)
picking_label_type_stock_picking_rel.stock_picking_id picking_label_type_stock_picking_rel_stock_picking_id_fkey C
purchase_order_stock_picking_rel.stock_picking_id purchase_order_stock_picking_rel_stock_picking_id_fkey C
stock_backorder_confirmation_line.picking_id stock_backorder_confirmation_line_picking_id_fkey N
stock_move.picking_id stock_move_picking_id_fkey N
stock_move_line.picking_id stock_move_line_picking_id_fkey N
stock_package_destination.picking_id stock_package_destination_picking_id_fkey C
stock_package_level.picking_id stock_package_level_picking_id_fkey N
stock_picking.backorder_id stock_picking_backorder_id_fkey N
stock_picking.return_id stock_picking_return_id_fkey N
stock_picking_backorder_rel.stock_picking_id stock_picking_backorder_rel_stock_picking_id_fkey C
stock_picking_sms_rel.stock_picking_id stock_picking_sms_rel_stock_picking_id_fkey C
stock_return_picking.picking_id stock_return_picking_picking_id_fkey N
stock_scrap.picking_id stock_scrap_picking_id_fkey N
backorder_id int4 10 √ null
stock_picking.id stock_picking_backorder_id_fkey N

Back Order of
return_id int4 10 √ null
stock_picking.id stock_picking_return_id_fkey N

Return of
group_id int4 10 √ null
procurement_group.id stock_picking_group_id_fkey N

Procurement Group
location_id int4 10 null
stock_location.id stock_picking_location_id_fkey R

Source Location
location_dest_id int4 10 null
stock_location.id stock_picking_location_dest_id_fkey R

Destination Location
picking_type_id int4 10 null
stock_picking_type.id stock_picking_picking_type_id_fkey R

Operation Type
partner_id int4 10 √ null
res_partner.id stock_picking_partner_id_fkey N

Contact
company_id int4 10 √ null
res_company.id stock_picking_company_id_fkey N

Company
user_id int4 10 √ null
res_users.id stock_picking_user_id_fkey N

Responsible
owner_id int4 10 √ null
res_partner.id stock_picking_owner_id_fkey N

Assign Owner
create_uid int4 10 √ null
res_users.id stock_picking_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 √ null

Reference
origin varchar 2147483647 √ null

Source Document
move_type varchar 2147483647 null

Shipping Policy
state varchar 2147483647 √ null

Status
priority varchar 2147483647 √ null

Priority
picking_properties jsonb 2147483647 √ null

Properties
note text 2147483647 √ null

Notes
has_deadline_issue bool 1 √ null

Is late
printed bool 1 √ null

Printed
is_locked bool 1 √ null

Is Locked
scheduled_date timestamp 29,6 √ null

Scheduled Date
date_deadline timestamp 29,6 √ null

Deadline
date timestamp 29,6 √ null

Creation Date
date_done timestamp 29,6 √ null

Date of Transfer
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
sale_id int4 10 √ null
sale_order.id stock_picking_sale_id_fkey N

Indexes

Constraint Name Type Sort Column(s)
stock_picking_pkey Primary key Asc id
stock_picking__backorder_id_index Performance Asc backorder_id
stock_picking__company_id_index Performance Asc company_id
stock_picking__owner_id_index Performance Asc owner_id
stock_picking__partner_id_index Performance Asc partner_id
stock_picking__picking_type_id_index Performance Asc picking_type_id
stock_picking__return_id_index Performance Asc return_id
stock_picking__sale_id_index Performance Asc sale_id
stock_picking__scheduled_date_index Performance Asc scheduled_date
stock_picking__state_index Performance Asc state
stock_picking_name_uniq Must be unique Asc/Asc name + company_id

Relationships

Close relationships within degrees of separation