stock_location

37 rows


Description

Inventory Locations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('stock_location_id_seq'::regclass)
mrp_production.location_dest_id mrp_production_location_dest_id_fkey R
mrp_production.location_src_id mrp_production_location_src_id_fkey R
mrp_production.production_location_id mrp_production_production_location_id_fkey N
mrp_unbuild.location_dest_id mrp_unbuild_location_dest_id_fkey R
mrp_unbuild.location_id mrp_unbuild_location_id_fkey R
res_company.internal_transit_location_id res_company_internal_transit_location_id_fkey R
stock_location.location_id stock_location_location_id_fkey C
stock_lot.location_id stock_lot_location_id_fkey N
stock_move.location_dest_id stock_move_location_dest_id_fkey R
stock_move.location_id stock_move_location_id_fkey R
stock_move_line.location_dest_id stock_move_line_location_dest_id_fkey R
stock_move_line.location_id stock_move_line_location_id_fkey R
stock_package_destination.location_dest_id stock_package_destination_location_dest_id_fkey C
stock_package_level.location_dest_id stock_package_level_location_dest_id_fkey N
stock_picking.location_dest_id stock_picking_location_dest_id_fkey R
stock_picking.location_id stock_picking_location_id_fkey R
stock_picking_type.default_location_dest_id stock_picking_type_default_location_dest_id_fkey N
stock_picking_type.default_location_return_id stock_picking_type_default_location_return_id_fkey N
stock_picking_type.default_location_src_id stock_picking_type_default_location_src_id_fkey N
stock_putaway_rule.location_in_id stock_putaway_rule_location_in_id_fkey C
stock_putaway_rule.location_out_id stock_putaway_rule_location_out_id_fkey C
stock_quant.location_id stock_quant_location_id_fkey R
stock_quant_package.location_id stock_quant_package_location_id_fkey N
stock_quant_relocate.dest_location_id stock_quant_relocate_dest_location_id_fkey N
stock_return_picking.location_id stock_return_picking_location_id_fkey N
stock_return_picking.original_location_id stock_return_picking_original_location_id_fkey N
stock_return_picking.parent_location_id stock_return_picking_parent_location_id_fkey N
stock_rule.location_dest_id stock_rule_location_dest_id_fkey R
stock_rule.location_src_id stock_rule_location_src_id_fkey N
stock_scrap.location_id stock_scrap_location_id_fkey R
stock_scrap.scrap_location_id stock_scrap_scrap_location_id_fkey R
stock_warehouse.lot_stock_id stock_warehouse_lot_stock_id_fkey R
stock_warehouse.pbm_loc_id stock_warehouse_pbm_loc_id_fkey N
stock_warehouse.sam_loc_id stock_warehouse_sam_loc_id_fkey N
stock_warehouse.view_location_id stock_warehouse_view_location_id_fkey R
stock_warehouse.wh_input_stock_loc_id stock_warehouse_wh_input_stock_loc_id_fkey N
stock_warehouse.wh_output_stock_loc_id stock_warehouse_wh_output_stock_loc_id_fkey N
stock_warehouse.wh_pack_stock_loc_id stock_warehouse_wh_pack_stock_loc_id_fkey N
stock_warehouse.wh_qc_stock_loc_id stock_warehouse_wh_qc_stock_loc_id_fkey N
stock_warehouse_orderpoint.location_id stock_warehouse_orderpoint_location_id_fkey C
stock_warn_insufficient_qty_scrap.location_id stock_warn_insufficient_qty_scrap_location_id_fkey C
stock_warn_insufficient_qty_unbuild.location_id stock_warn_insufficient_qty_unbuild_location_id_fkey C
location_id int4 10 √ null
stock_location.id stock_location_location_id_fkey C

Parent Location
posx int4 10 √ null

Corridor (X)
posy int4 10 √ null

Shelves (Y)
posz int4 10 √ null

Height (Z)
company_id int4 10 √ null
res_company.id stock_location_company_id_fkey N

Company
removal_strategy_id int4 10 √ null
product_removal.id stock_location_removal_strategy_id_fkey N

Removal Strategy
cyclic_inventory_frequency int4 10 √ null

Inventory Frequency (Days)
warehouse_id int4 10 √ null
stock_warehouse.id stock_location_warehouse_id_fkey N

Warehouse
storage_category_id int4 10 √ null
stock_storage_category.id stock_location_storage_category_id_fkey N

Storage Category
create_uid int4 10 √ null
res_users.id stock_location_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Location Name
complete_name varchar 2147483647 √ null

Full Location Name
usage varchar 2147483647 null

Location Type
parent_path varchar 2147483647 √ null

Parent Path
barcode varchar 2147483647 √ null

Barcode
last_inventory_date date 13 √ null

Last Effective Inventory
next_inventory_date date 13 √ null

Next Expected Inventory
comment text 2147483647 √ null

Additional Information
active bool 1 √ null

Active
scrap_location bool 1 √ null

Is a Scrap Location?
return_location bool 1 √ null

Is a Return Location?
replenish_location bool 1 √ null

Replenish Location
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
valuation_in_account_id int4 10 √ null
account_account.id stock_location_valuation_in_account_id_fkey N

Stock Valuation Account (Incoming)
valuation_out_account_id int4 10 √ null
account_account.id stock_location_valuation_out_account_id_fkey N

Stock Valuation Account (Outgoing)

Indexes

Constraint Name Type Sort Column(s)
stock_location_pkey Primary key Asc id
stock_location__company_id_index Performance Asc company_id
stock_location__location_id_index Performance Asc location_id
stock_location__parent_path_index Performance Asc parent_path
stock_location__usage_index Performance Asc usage
stock_location_barcode_company_uniq Must be unique Asc/Asc barcode + company_id

Check Constraints

Constraint Name Constraint
stock_location_inventory_freq_nonneg ((cyclic_inventory_frequency >= 0))

Relationships

Close relationships within degrees of separation