detail_objid | demand_dtl | objid | Demand Detail internal record number | |
onsite_objid | onsite_log | objid | Onsite_log internal record number | |
objid | mtl_log | objid | Mtl_log internal record number | 3 (UNIQUE) |
location | mtl_log | ref_designator | Where the replacement part was put in the item being repaired | |
failure_code | mtl_log | failure_code | Code describing the failure | |
repair_code | mtl_log | repair_code | Code describing the repair executed | |
standard_cost | mtl_log | standard_cost | Standard cost of the material part used in the repair | |
billable | mtl_log | billable | Indicates whether the line item is considered billable; i.e., 0=non-billable, 1=billable | |
bill_to | mtl_log | bill_to | Organization, department, group to which the line item is to be billed | |
wrk_center | mtl_log | wrk_center | Work Center where time activity took place | |
notes | mtl_log | notes | Notes about the part replacement | |
part_mod | mod_level | objid | Part revision internal record number | |
part_number | part_num | part_number | Part number/name | |
mod_level | mod_level | mod_level | Revision level | |
technician | onsite_log | perf_by | Login name of the technician that performed the work | |
total_cost | onsite_log | total_mtl | Total material cost, both billable and non-billable | |
disposition | mtl_log | disposition | Repair 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_id | mtl_log | transaction_id | Reference part_trans.transaction_id. This is the transaction used for the transacted part | |