View Name:locs_view
View Number:62
Group:Logistics
Description:Reserved; obsolete
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_locs_view
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidinv_locatnobjidReserved; obsolete 
location_idinv_locatnobjidReserved; obsolete 
location_nameinv_locatnlocation_nameReserved; obsolete 
bin_idinv_binobjidReserved; obsolete 
part_num_idinv_locatnobjidReserved; obsolete 
part_numberpart_numpart_numberReserved; obsolete 
part_name_idpart_numobjidReserved; obsolete 
part_descrpart_numdescriptionReserved; obsolete 
part_good_qtyinv_locatnd_good_qtyReserved; obsolete 
part_bad_qtyinv_locatnd_bad_qtyReserved; obsolete 
part_serial_noinv_locatnloc_serv_levelReserved; obsolete 
bin_nameinv_binbin_nameReserved; obsolete 
mod_levelmod_levelmod_levelReserved; obsolete 
locdescinv_locatnlocation_descrReserved; obsolete 
good_res_qtypart_instgood_res_qtyReserved; obsolete 
bad_res_qtypart_instbad_res_qtyReserved; obsolete 
inv_classinv_locatninv_classReserved; obsolete 
pick_requestpart_instpick_requestReserved; obsolete 
mod_level_objidmod_levelobjidReserved; obsolete 
inst_good_qtypart_instpart_good_qtyReserved; obsolete 
inst_bad_qtypart_instpart_bad_qtyReserved; obsolete 
inst_objidpart_instobjidReserved; obsolete 3 (UNIQUE)

Joins:

Join FromJoin To
(part_inst).part_inst2inv_bin(inv_bin).inv_bin2part_inst
(part_inst).n_part_inst2part_mod(mod_level).n_part_info2part_inst
(inv_bin).inv_bin2inv_locatn(inv_locatn).inv_locatn2inv_bin
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
locs_view      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user