View Name:prtuse_view2
View Number:6028
Group:Logistics
Description:Information used in parts used form. Includes part information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_prtuse_view2
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_usedobjidPart used internal record number 3 (UNIQUE)
prd_inst_namesite_partinstance_namePart name 
serial_nosite_partserial_noInstalled part serial number 
invoice_nosite_partinvoice_noInstalled part invoice number 
pinst_objidsite_partobjidInstalled part internal record number 
pricepart_usedpricePrice of the part 
install_serialpart_usedinstall_serialSerial number of the installed part 
remove_serialpart_usedremove_serialSerial number of the removed part 
statuspart_usedstatusStatus of the transaction 
failure_statuspart_usedfailure_statusFailure code for the removed part 
install_qtypart_usedinstall_qtyNumber of parts installed 
remove_qtypart_usedremove_qtyNumber of parts removed 
part_used_datepart_usedpart_used_dateDate/time of transaction 
trans_typepart_usedtrans_typeTransaction type; i.e. , exchange/consume 
remove_prt_numpart_usedrem_part_numPart number of removed part 
remove_prt_namepart_usedrem_part_namePart description of removed part 
remove_modpart_usedrem_mod_levelRevision level of the removed part 
case_id_numberpart_usedcase_id_numberCase number for transaction 
detail_numberpart_useddetail_numberThe part request number for the part used action. Same as the part request , detail number 
inv_statuspart_usedinv_statusStatus of the inventory update for the part used activity; i.e. , new=not attempted , failed=attempted and failed , complete=completed successfully 
dtl_condtnpart_useddtl_condtnUsed for temporary storage of the related part request's condition 
ins_trans_typepart_usedins_trans_typeInstall directly at site or not 
part_pricepart_usedpart_priceThe price from part request 
parent_part_objidsite_partobjidParent part internal record number 
login_nameuserlogin_nameUser login name 
user_objiduserobjidUser internal record number 
inst_pmlobjidmod_levelobjidMod level internal record number 

Joins:

Join FromJoin To
(part_used).part_used2site_part(site_part).site_part2part_used
(part_used).part_used2assigned_eng(user).assigned_eng2part_used
(part_used).part_used2inst_part_infoOUTER (mod_level).inst_part_info2part_used
My Recent Objects
prtuse_view2      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user