| objid | part_used | objid | Part used internal record number | 3 (UNIQUE) |
| inst_pmlobjid | inst_part_mod(mod_level) | objid | Installed part revision internal record number | |
| rem_pmlobjid | rem_part_mod(mod_level) | objid | Removed part revision internal record number | |
| rem_name | rem_part_num(part_num) | description | Removed product number maps to sales and mfg systems | |
| rem_part_type | rem_part_num(part_num) | domain | Removed part name | |
| inst_name | inst_part_num(part_num) | description | Installed part maps to sales and mfg systems | |
| inst_part_type | inst_part_num(part_num) | domain | Installed part domain name | |
| prd_inst_name | site_part | instance_name | Installed part name | |
| inst_active | inst_part_mod(mod_level) | active | Installed part state; i.e., active/inactive/obsolete | |
| rem_active | rem_part_mod(mod_level) | active | Removed part state; i.e., active/inactive/obsolete | |
| rem_pmh_objid | rem_part_num(part_num) | objid | Removed part num internal record number | |
| inst_pmh_objid | inst_part_num(part_num) | objid | Installed part number 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 | |
| inst_part_number | inst_part_num(part_num) | part_number | Installed part number/name | |
| inst_mod_level | inst_part_mod(mod_level) | mod_level | Installed part revision | |
| inst_model_num | inst_part_num(part_num) | model_num | Installed part marketing model number of the part; within family and line | |
| rem_part_number | rem_part_num(part_num) | part_number | Removed part number/name | |
| rem_mod_level | rem_part_mod(mod_level) | mod_level | Removed part revision | |
| rem_model_num | rem_part_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 | |
| part_used_oid | part_used | objid | Part used internal record number | |
| 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 | |