stock_warehouse

-1 rows


Description

Warehouse

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_warehouse_id_seq'::regclass)
product_replenish.warehouse_id product_replenish_warehouse_id_fkey C
sale_order.warehouse_id sale_order_warehouse_id_fkey R
stock_location.warehouse_id stock_location_warehouse_id_fkey N
stock_move.warehouse_id stock_move_warehouse_id_fkey N
stock_picking_type.warehouse_id stock_picking_type_warehouse_id_fkey C
stock_route.supplied_wh_id stock_route_supplied_wh_id_fkey N
stock_route.supplier_wh_id stock_route_supplier_wh_id_fkey N
stock_route_warehouse.warehouse_id stock_route_warehouse_warehouse_id_fkey C
stock_rule.propagate_warehouse_id stock_rule_propagate_warehouse_id_fkey N
stock_rule.warehouse_id stock_rule_warehouse_id_fkey N
stock_rules_report_stock_warehouse_rel.stock_warehouse_id stock_rules_report_stock_warehouse_rel_stock_warehouse_id_fkey C
stock_warehouse_orderpoint.warehouse_id stock_warehouse_orderpoint_warehouse_id_fkey C
stock_wh_resupply_table.supplied_wh_id stock_wh_resupply_table_supplied_wh_id_fkey C
stock_wh_resupply_table.supplier_wh_id stock_wh_resupply_table_supplier_wh_id_fkey C
company_id int4 10 null
res_company.id stock_warehouse_company_id_fkey R

Company
partner_id int4 10 √ null
res_partner.id stock_warehouse_partner_id_fkey N

Address
view_location_id int4 10 null
stock_location.id stock_warehouse_view_location_id_fkey R

View Location
lot_stock_id int4 10 null
stock_location.id stock_warehouse_lot_stock_id_fkey R

Location Stock
wh_input_stock_loc_id int4 10 √ null
stock_location.id stock_warehouse_wh_input_stock_loc_id_fkey N

Input Location
wh_qc_stock_loc_id int4 10 √ null
stock_location.id stock_warehouse_wh_qc_stock_loc_id_fkey N

Quality Control Location
wh_output_stock_loc_id int4 10 √ null
stock_location.id stock_warehouse_wh_output_stock_loc_id_fkey N

Output Location
wh_pack_stock_loc_id int4 10 √ null
stock_location.id stock_warehouse_wh_pack_stock_loc_id_fkey N

Packing Location
mto_pull_id int4 10 √ null
stock_rule.id stock_warehouse_mto_pull_id_fkey N

MTO rule
pick_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_pick_type_id_fkey N

Pick Type
pack_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_pack_type_id_fkey N

Pack Type
out_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_out_type_id_fkey N

Out Type
in_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_in_type_id_fkey N

In Type
int_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_int_type_id_fkey N

Internal Type
crossdock_route_id int4 10 √ null
stock_route.id stock_warehouse_crossdock_route_id_fkey R

Crossdock Route
reception_route_id int4 10 √ null
stock_route.id stock_warehouse_reception_route_id_fkey R

Receipt Route
delivery_route_id int4 10 √ null
stock_route.id stock_warehouse_delivery_route_id_fkey R

Delivery Route
sequence int4 10 √ null

Sequence
create_uid int4 10 √ null
res_users.id stock_warehouse_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Warehouse
code varchar 5 null

Short Name
reception_steps varchar 2147483647 null

Incoming Shipments
delivery_steps varchar 2147483647 null

Outgoing Shipments
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
manufacture_pull_id int4 10 √ null
stock_rule.id stock_warehouse_manufacture_pull_id_fkey N

Manufacture Rule
manufacture_mto_pull_id int4 10 √ null
stock_rule.id stock_warehouse_manufacture_mto_pull_id_fkey N

Manufacture MTO Rule
pbm_mto_pull_id int4 10 √ null
stock_rule.id stock_warehouse_pbm_mto_pull_id_fkey N

Picking Before Manufacturing MTO Rule
sam_rule_id int4 10 √ null
stock_rule.id stock_warehouse_sam_rule_id_fkey N

Stock After Manufacturing Rule
manu_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_manu_type_id_fkey N

Manufacturing Operation Type
pbm_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_pbm_type_id_fkey N

Picking Before Manufacturing Operation Type
sam_type_id int4 10 √ null
stock_picking_type.id stock_warehouse_sam_type_id_fkey N

Stock After Manufacturing Operation Type
pbm_route_id int4 10 √ null
stock_route.id stock_warehouse_pbm_route_id_fkey R

Picking Before Manufacturing Route
pbm_loc_id int4 10 √ null
stock_location.id stock_warehouse_pbm_loc_id_fkey N

Picking before Manufacturing Location
sam_loc_id int4 10 √ null
stock_location.id stock_warehouse_sam_loc_id_fkey N

Stock after Manufacturing Location
manufacture_steps varchar 2147483647 null

Manufacture
manufacture_to_resupply bool 1 √ null

Manufacture to Resupply
buy_pull_id int4 10 √ null
stock_rule.id stock_warehouse_buy_pull_id_fkey N

Buy rule
buy_to_resupply bool 1 √ null

Buy to Resupply

Indexes

Constraint Name Type Sort Column(s)
stock_warehouse_pkey Primary key Asc id
stock_warehouse_warehouse_code_uniq Must be unique Asc/Asc code + company_id
stock_warehouse_warehouse_name_uniq Must be unique Asc/Asc name + company_id

Relationships

Close relationships within degrees of separation