| objid | part_trans | objid | Part transaction internal record number | 3 (UNIQUE) |
| part_mod_objid | mod_level | objid | Part revision internal record number | |
| to_location | to_bin(inv_bin) | location_name | The TO location for the parts | |
| fr_location | from_bin(inv_bin) | location_name | The FROM location for the parts | |
| trans_date | part_trans | creation_date | The date of transaction | |
| ref_number | part_trans | reference_no | The reference number of transaction | |
| trans_id | part_trans | transaction_id | The ID number of transaction | |
| part_number | part_num | part_number | Part number/name | |
| part_num_desc | part_num | description | Maps to sales and mfg systems | |
| qty | part_trans | quantity | The quantity of transaction | |
| std_cost | part_trans | standard_cost | The cost of transaction | |
| serial_no | from_inst(part_inst) | part_serial_no | The serial number transaction | |
| mod_level | mod_level | mod_level | Part revision | |
| notes | part_trans | notes | Notes for the transaction | |
| to_gl_acct | to_bin(inv_bin) | gl_acct_no | The capital GL account of the TO inventory bin. This is the same as the GL account of its parent inventory location | |
| from_gl_acct | from_bin(inv_bin) | gl_acct_no | The capital GL account of the FROM inventory bin. This is the same as the GL account of its parent inventory location | |
| fr_bin_objid | from_bin(inv_bin) | objid | Internal record number of the FROM inventory bin | |
| to_bin_objid | to_bin(inv_bin) | objid | Internal record number of the TO inventory bin | |
| part_objid | part_num | objid | Internal record number of the part number | |
| movement_type | part_trans | movement_type | Movement type; i.e., 0=good to good, 1=good to bad, 2=bad to good, 3=bad to bad | |
| to_inst_objid | to_inst(part_inst) | objid | The TO part_inst internal record number for this part transaction | |
| fr_inst_objid | from_inst(part_inst) | objid | The FROM part_inst internal record number for this part transaction | |