objid | part_used | objid | Part used internal record number | 3 (UNIQUE) |
rem_pmlobjid | mod_level | objid | Part revision internal record number | |
rem_name | part_num | description | Maps to sales and mfg systems | |
rem_part_type | part_num | domain | Name | |
prd_inst_name | site_part | instance_name | Installed part name | |
rem_active | mod_level | active | Active/inactive/obsolete | |
rem_pmh_objid | part_num | objid | Part internal record number | |
serial_no | site_part | serial_no | Installed part serial number | |
invoice_no | site_part | invoice_no | Installed part invoice number | |
pinst_objid | site_part | objid | Installed part internal record number | |
rem_part_number | part_num | part_number | Part number/name | |
rem_mod_level | mod_level | mod_level | Removed part revision | |
rem_model_num | part_num | model_num | Removed part marketing model number of the part; within family and line | |
price | part_used | price | Price of the part | |
install_serial | part_used | install_serial | Serial number of the installed part | |
remove_serial | part_used | remove_serial | Serial number of the removed part | |
status | part_used | status | Status of the transaction | |
failure_status | part_used | failure_status | Failure code for the removed part | |
install_qty | part_used | install_qty | Number of parts installed | |
remove_qty | part_used | remove_qty | Number of parts removed | |
part_used_date | part_used | part_used_date | Date/time of transaction | |
trans_type | part_used | trans_type | Transaction type; i.e., exchange/consume | |
remove_prt_num | part_used | rem_part_num | Part number of removed part | |
remove_prt_name | part_used | rem_part_name | Part description of removed part | |
remove_mod | part_used | rem_mod_level | Revision level of the removed part | |
case_id_number | part_used | case_id_number | Case number for transaction | |
detail_number | part_used | detail_number | The part request number for the part used action. Same as the part request, detail number | |
inv_status | part_used | inv_status | Status of the inventory update for the part used activity; i.e., new=not attempted, failed=attempted and failed, complete=completed successfully | |
dtl_condtn | part_used | dtl_condtn | Used for temporary storage of the related part request's condition | |