View Name:prtuse1_view
View Number:308
Group:Logistics
Description:Information used in parts used form. Includes installed part and removed part information
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_prtuse1_view
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_usedobjidPart used internal record number 3 (UNIQUE)
inst_pmlobjidmod_levelobjidPart revision internal record number 
inst_namepart_numdescriptionMaps to sales and mfg systems 
inst_part_typepart_numdomainPart domanin name 
prd_inst_namesite_partinstance_namePart name 
inst_activemod_levelactiveActive/inactive/obsolete 
inst_pmh_objidpart_numobjidPart num internal record number 
serial_nosite_partserial_noInstalled part serial number 
invoice_nosite_partinvoice_noInstalled part invoice number 
pinst_objidsite_partobjidInstalled part internal record number 
inst_part_numberpart_numpart_numberPart number/name 
inst_mod_levelmod_levelmod_levelInstalled part revision 
inst_model_numpart_nummodel_numInstalled part marketing model number of the part; within family and line 
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 

Joins:

Join FromJoin To
(part_used).part_used2site_part(site_part).site_part2part_used
(part_used).part_used2inst_part_info(mod_level).inst_part_info2part_used
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
prtuse1_view      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user