View Name:v_part_bin
View Number:5330
Group:Logistics
Description:View of inventory part/bin information used by form Picked Parts (552)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_v_part_bin
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_instobjidInventory part internal record number 3 (UNIQUE)
part_num_idpart_numobjidPart_num internal record number 
mod_idmod_levelobjidPart revision internal record number 
bin_idinv_binobjidInventory bin internal record number 
inv_locatn_idinv_locatnobjidInventory location internal record number 
part_numberpart_numpart_numberPart number/name 
part_descrpart_numdescriptionDescription of the product 
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 inventory installed part serial number 
bin_nameinv_binbin_nameUnique name of the inventory bin within an inventory location 
last_trans_timepart_instlast_trans_timeDate and time of the last transaction against the part instance 
part_statuspart_instpart_statusStatus of the inventory part 

Joins:

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