| objid | part_used | objid | Part used internal record number | 3 (UNIQUE) |
| inst_pmlobjid | mod_level | objid | Part revision internal record number | |
| inst_name | part_num | description | Maps to sales and mfg systems | |
| inst_part_type | part_num | domain | Part domanin name | |
| prd_inst_name | site_part | instance_name | Part name | |
| inst_active | mod_level | active | Active/inactive/obsolete | |
| inst_pmh_objid | part_num | objid | Part num 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 | part_num | part_number | Part number/name | |
| inst_mod_level | mod_level | mod_level | Installed part revision | |
| inst_model_num | part_num | model_num | Installed 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 | |
| ins_trans_type | part_used | ins_trans_type | Install directly at site or not | |
| part_price | part_used | part_price | The price from part request | |
| parent_part_objid | site_part | objid | Parent part internal record number | |
| login_name | user | login_name | User login name | |
| user_objid | user | objid | User internal record number | |
| sn_track | part_num | sn_track | Track part for serialization; i.e. , 0=by quantity , 1=by serial number | |
| dom_serialno | part_num | dom_serialno | Serial number's degree of uniqueness; i.e. , 0=no serial numbers , tracked only by quantity , 1=unique across all part numbers , 2=unique within a part number , 3=not unique | |
| dom_uniquesn | part_num | dom_uniquesn | For any given site , serial number must be unique for all part numbers; i.e. , 0=no , 1=yes | |
| dom_catalogs | part_num | dom_catalogs | Allow part to be included in BOMs; i.e. , 0=no , 1=yes | |
| dom_boms | part_num | dom_boms | Allow part to be included in BOMs; i.e. , 0=no , 1=yes | |
| dom_at_site | part_num | dom_at_site | Part may be installed at either site or under another part. 0=no , 1=yes | |
| dom_at_parts | part_num | dom_at_parts | Domain allows parts to be installed under other parts in the Site Configuration Manager; i.e. , 0=no , 1=yes | |
| dom_at_domain | part_num | dom_at_domain | Bin must be included in another domain? 0=no , 1=yes | |
| dom_pt_used_bom | part_num | dom_pt_used_bom | During parts-used transactions , force part installation to conform to BOM; i.e. , 0=no , 1=yes | |
| dom_pt_used_dom | part_num | dom_pt_used_dom | Apply domain rules during parts-used transactions; i.e. , 0=no , 1=yes | |
| dom_pt_used_warn | part_num | dom_pt_used_warn | Warning for parts used | |
| incl_domain | part_num | incl_domain | Domain of the part under which the current part must be installed. If empty , part may be installed directly under the site | |
| is_sppt_prog | part_num | is_sppt_prog | Indicates application category of the part: i.e. , 0=physical part , 1=service part , 2=product literature | |
| dom_is_service | part_num | dom_is_service | Indicates the part is a service part , if selected , sit_prt_role will be set when installed; i.e. , 0=not a service , 1=a service , default=0 | |