View Name:prtins_view
View Number:280
Group:Logistics
Description:Installed part's location, bin, rev level, and part number
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_prtins_view
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_instobjidPart internal record number 
location_idinv_locatnobjidInventory location internal record number 
location_nameinv_locatnlocation_nameFor physical inventory locations, the name of the location. For GL accounts, the account number 
bin_idinv_binobjidInventory bin internal record number 3 (UNIQUE)
part_num_idmod_levelobjidPart revision internal record number 
part_numberpart_numpart_numberPart number/name 
part_name_idpart_numobjidPart internal record number 
part_descrpart_numdescriptionProduct description 
part_good_qtypart_instpart_good_qtyFor parts tracked by quantity, the quantity usable 
part_bad_qtypart_instpart_bad_qtyFor parts tracked by quantity, the quantity not usable 
part_serial_nopart_instpart_serial_noFor parts tracked by serial number, the part serial number 
bin_nameinv_binbin_nameInventory bin name 
mod_levelmod_levelmod_levelPart revision name 

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
prtins_view      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user