stock_picking_type

16 rows


Description

Picking Type

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_picking_type_id_seq'::regclass)
mrp_bom.picking_type_id mrp_bom_picking_type_id_fkey N
mrp_production.picking_type_id mrp_production_picking_type_id_fkey R
purchase_order.picking_type_id purchase_order_picking_type_id_fkey R
stock_move.picking_type_id stock_move_picking_type_id_fkey N
stock_picking.picking_type_id stock_picking_picking_type_id_fkey R
stock_picking_type.return_picking_type_id stock_picking_type_return_picking_type_id_fkey N
stock_rule.picking_type_id stock_rule_picking_type_id_fkey R
stock_warehouse.in_type_id stock_warehouse_in_type_id_fkey N
stock_warehouse.int_type_id stock_warehouse_int_type_id_fkey N
stock_warehouse.manu_type_id stock_warehouse_manu_type_id_fkey N
stock_warehouse.out_type_id stock_warehouse_out_type_id_fkey N
stock_warehouse.pack_type_id stock_warehouse_pack_type_id_fkey N
stock_warehouse.pbm_type_id stock_warehouse_pbm_type_id_fkey N
stock_warehouse.pick_type_id stock_warehouse_pick_type_id_fkey N
stock_warehouse.sam_type_id stock_warehouse_sam_type_id_fkey N
color int4 10 √ null

Color
sequence int4 10 √ null

Sequence
sequence_id int4 10 √ null
ir_sequence.id stock_picking_type_sequence_id_fkey N

Reference Sequence
default_location_src_id int4 10 √ null
stock_location.id stock_picking_type_default_location_src_id_fkey N

Default Source Location
default_location_dest_id int4 10 √ null
stock_location.id stock_picking_type_default_location_dest_id_fkey N

Default Destination Location
default_location_return_id int4 10 √ null
stock_location.id stock_picking_type_default_location_return_id_fkey N

Default returns location
return_picking_type_id int4 10 √ null
stock_picking_type.id stock_picking_type_return_picking_type_id_fkey N

Operation Type for Returns
warehouse_id int4 10 √ null
stock_warehouse.id stock_picking_type_warehouse_id_fkey C

Warehouse
reservation_days_before int4 10 √ null

Days
reservation_days_before_priority int4 10 √ null

Days when starred
company_id int4 10 null
res_company.id stock_picking_type_company_id_fkey R

Company
create_uid int4 10 √ null
res_users.id stock_picking_type_create_uid_fkey N

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

Last Updated by
sequence_code varchar 2147483647 null

Sequence Prefix
code varchar 2147483647 null

Type of Operation
reservation_method varchar 2147483647 null

Reservation Method
product_label_format varchar 2147483647 √ null

Product Label Format to auto-print
lot_label_format varchar 2147483647 √ null

Lot Label Format to auto-print
package_label_to_print varchar 2147483647 √ null

Package Label to Print
barcode varchar 2147483647 √ null

Barcode
create_backorder varchar 2147483647 null

Create Backorder
name jsonb 2147483647 null

Operation Type
picking_properties_definition jsonb 2147483647 √ null

Picking Properties
show_entire_packs bool 1 √ null

Move Entire Packages
active bool 1 √ null

Active
use_create_lots bool 1 √ null

Create New Lots/Serial Numbers
use_existing_lots bool 1 √ null

Use Existing Lots/Serial Numbers
print_label bool 1 √ null

Print Label
show_operations bool 1 √ null

Show Detailed Operations
show_reserved bool 1 √ null

Pre-fill Detailed Operations
auto_show_reception_report bool 1 √ null

Show Reception Report at Validation
auto_print_delivery_slip bool 1 √ null

Auto Print Delivery Slip
auto_print_return_slip bool 1 √ null

Auto Print Return Slip
auto_print_product_labels bool 1 √ null

Auto Print Product Labels
auto_print_lot_labels bool 1 √ null

Auto Print Lot/SN Labels
auto_print_reception_report bool 1 √ null

Auto Print Reception Report
auto_print_reception_report_labels bool 1 √ null

Auto Print Reception Report Labels
auto_print_packages bool 1 √ null

Auto Print Packages
auto_print_package_label bool 1 √ null

Auto Print Package Label
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
mrp_product_label_to_print varchar 2147483647 √ null

Product Label to Print
done_mrp_lot_label_to_print varchar 2147483647 √ null

Lot/SN Label to Print
generated_mrp_lot_label_to_print varchar 2147483647 √ null

Generated Lot/SN Label to Print
use_create_components_lots bool 1 √ null

Create New Lots/Serial Numbers for Components
use_auto_consume_components_lots bool 1 √ null

Consume Reserved Lots/Serial Numbers automatically
auto_print_done_production_order bool 1 √ null

Auto Print Done Production Order
auto_print_done_mrp_product_labels bool 1 √ null

Auto Print Produced Product Labels
auto_print_done_mrp_lot bool 1 √ null

Auto Print Produced Lot Label
auto_print_mrp_reception_report bool 1 √ null

Auto Print Allocation Report
auto_print_mrp_reception_report_labels bool 1 √ null

Auto Print Allocation Report Labels
auto_print_generated_mrp_lot bool 1 √ null

Auto Print Generated Lot/SN Label

Indexes

Constraint Name Type Sort Column(s)
stock_picking_type_pkey Primary key Asc id
stock_picking_type__company_id_index Performance Asc company_id

Relationships

Close relationships within degrees of separation