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 | Description of the product | |
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 | |
to_bin | to_bin(inv_bin) | bin_name | The TO inventory bin name | |
from_bin | from_bin(inv_bin) | bin_name | The FROM inventory bin name | |
notes | part_trans | notes | Notes for the transaction | |
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 | |
to_container | to_bin(inv_bin) | id_number | The TO inventory container ID | |
from_container | from_bin(inv_bin) | id_number | The FROM inventory container ID | |