stock_route

-1 rows


Description

Inventory Routes

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_route_id_seq'::regclass)
product_replenish.route_id product_replenish_route_id_fkey N
sale_order_line.route_id sale_order_line_route_id_fkey R
stock_replenishment_option.route_id stock_replenishment_option_route_id_fkey N
stock_route_categ.route_id stock_route_categ_route_id_fkey C
stock_route_move.route_id stock_route_move_route_id_fkey C
stock_route_packaging.route_id stock_route_packaging_route_id_fkey C
stock_route_product.route_id stock_route_product_route_id_fkey C
stock_route_stock_rules_report_rel.stock_route_id stock_route_stock_rules_report_rel_stock_route_id_fkey C
stock_route_warehouse.route_id stock_route_warehouse_route_id_fkey C
stock_rule.route_id stock_rule_route_id_fkey C
stock_warehouse.crossdock_route_id stock_warehouse_crossdock_route_id_fkey R
stock_warehouse.delivery_route_id stock_warehouse_delivery_route_id_fkey R
stock_warehouse.pbm_route_id stock_warehouse_pbm_route_id_fkey R
stock_warehouse.reception_route_id stock_warehouse_reception_route_id_fkey R
stock_warehouse_orderpoint.route_id stock_warehouse_orderpoint_route_id_fkey N
sequence int4 10 √ null

Sequence
supplied_wh_id int4 10 √ null
stock_warehouse.id stock_route_supplied_wh_id_fkey N

Supplied Warehouse
supplier_wh_id int4 10 √ null
stock_warehouse.id stock_route_supplier_wh_id_fkey N

Supplying Warehouse
company_id int4 10 √ null
res_company.id stock_route_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id stock_route_create_uid_fkey N

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

Last Updated by
name jsonb 2147483647 null

Route
active bool 1 √ null

Active
product_selectable bool 1 √ null

Applicable on Product
product_categ_selectable bool 1 √ null

Applicable on Product Category
warehouse_selectable bool 1 √ null

Applicable on Warehouse
packaging_selectable bool 1 √ null

Applicable on Packaging
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
sale_selectable bool 1 √ null

Selectable on Sales Order Line

Indexes

Constraint Name Type Sort Column(s)
stock_route_pkey Primary key Asc id
stock_route__company_id_index Performance Asc company_id

Relationships

Close relationships within degrees of separation