View Name:prtuse2_view
View Number:309
Group:Logistics
Description:Information used in parts used transactions
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_usedobjidPart used internal record number 3 (UNIQUE)
rem_pmlobjidmod_levelobjidPart revision internal record number 
rem_namepart_numdescriptionMaps to sales and mfg systems 
rem_part_typepart_numdomainName 
prd_inst_namesite_partinstance_nameInstalled part name 
rem_activemod_levelactiveActive/inactive/obsolete 
rem_pmh_objidpart_numobjidPart internal record number 
serial_nosite_partserial_noInstalled part serial number 
invoice_nosite_partinvoice_noInstalled part invoice number 
pinst_objidsite_partobjidInstalled part internal record number 
rem_part_numberpart_numpart_numberPart number/name 
rem_mod_levelmod_levelmod_levelRemoved part revision 
rem_model_numpart_nummodel_numRemoved 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_used2rem_part_info(mod_level).rem_part_info2part_used
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
prtuse2_view