View Name:list_drmatl
View Number:5173
Group:Logistics
Description:Used by form Depot Repair (8410)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
detail_objiddemand_dtlobjidDemand Detail internal record number 
onsite_objidonsite_logobjidOnsite_log internal record number 
objidmtl_logobjidMtl_log internal record number 3 (UNIQUE)
locationmtl_logref_designatorWhere the replacement part was put in the item being repaired 
failure_codemtl_logfailure_codeCode describing the failure 
repair_codemtl_logrepair_codeCode describing the repair executed 
standard_costmtl_logstandard_costStandard cost of the material part used in the repair 
billablemtl_logbillableIndicates whether the line item is considered billable; i.e., 0=non-billable, 1=billable 
bill_tomtl_logbill_toOrganization, department, group to which the line item is to be billed 
wrk_centermtl_logwrk_centerWork Center where time activity took place 
notesmtl_lognotesNotes about the part replacement 
part_modmod_levelobjidPart revision internal record number 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
technicianonsite_logperf_byLogin name of the technician that performed the work 
total_costonsite_logtotal_mtlTotal material cost, both billable and non-billable 
dispositionmtl_logdispositionRepair part's disposition; i.e., 0=Used in the repair, 1=Removed in the repair, 2=Referenced but not used or removed in the repair. Default=0 
transaction_idmtl_logtransaction_idReference part_trans.transaction_id. This is the transaction used for the transacted part 

Joins:

Join FromJoin To
(onsite_log).detail_onsite2demand_dtl(demand_dtl).detail2onsite_log
(mtl_log).mtl_log2onsite_log(onsite_log).onsite_log2mtl_log
(mtl_log).mtl_log2mod_level(mod_level).mod_level2mtl_log
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
list_drmatl