wms_inv_location

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_aisle varchar 4 null
c_area varchar 4 null
c_direct_booking_allowed bool 1 √ null
c_incoming_active bool 1 √ null
c_marked_deletion bool 1 √ null
c_mixed_products bool 1 √ null
c_no_max_transport_units int4 10 √ null
c_outgoing_active bool 1 √ null
c_plc_state int4 10 √ null
c_sort int4 10 √ null
c_x varchar 4 null
c_y varchar 4 null
c_z varchar 4 null
c_created timestamp 29,6 √ null
c_last_inventory_date timestamp 22 √ null
c_last_pick_date timestamp 22 √ null
c_ol int8 19 √ null
c_pk int8 19 null
wms_inv_packaging_unit.c_actual_location fk_pu_loc_pk R
wms_inv_product.c_preferable_storage_location fk_prod_loc_pk R
wms_inv_transport_unit.c_actual_location fk_loc_pk R
c_updated timestamp 29,6 √ null
c_classification varchar 255 √ null
c_created_by varchar 255 √ null
c_description varchar 255 √ null
c_erp_code varchar 255 √ null
c_foreign_pid varchar 255 √ null
c_location_group varchar 255 √ null
c_pid varchar 255 null
c_stock_zone varchar 255 √ null
c_updated_by varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
wms_inv_location_pkey Primary key Asc c_pk
uc_coordinate Must be unique Asc/Asc/Asc/Asc/Asc c_area + c_aisle + c_x + c_y + c_z
uc_loc_foreign_pid Must be unique Asc c_foreign_pid
wms_inv_location_c_pid_key Must be unique Asc c_pid

Relationships

Close relationships within degrees of separation