| objid | part_inst | objid | Part internal record number | 3 (UNIQUE) |
| location_id | inv_locatn | objid | Inventory location internal record number | |
| location_name | inv_locatn | location_name | For physical inventory locations, the name of the location. For GL accounts, the account number | |
| bin_id | inv_bin | objid | Inventory bin internal record number | |
| part_num_id | mod_level | objid | Part revision internal record number | |
| part_number | part_num | part_number | Part number/name | |
| part_name_id | part_num | objid | Part number internal record number | |
| part_descr | part_num | description | Maps to sales and mfg systems | |
| part_good_qty | part_inst | part_good_qty | For parts tracked by quantity, the quantity usable | |
| part_bad_qty | part_inst | part_bad_qty | For parts tracked by quantity, the quantity not usable | |
| part_serial_no | part_inst | part_serial_no | For parts tracked by serial number, the part serial number | |
| bin_name | inv_bin | bin_name | Unique name of the inventory bin within an inventory location | |
| mod_level | mod_level | mod_level | Name of part revision | |
| locdesc | inv_locatn | location_descr | Description of the inventory location or GL account | |
| good_res_qty | part_inst | good_res_qty | For parts tracked by quantity, the good quantity reserved | |
| bad_res_qty | part_inst | bad_res_qty | For parts tracked by quantity, the bad quantity reserved | |
| inv_class | inv_locatn | inv_class | Part location; i.e., 0=inventory location, 1=capital GL account, 2=expense GL account | |
| pick_request | part_inst | pick_request | The part request number for the request that has currently picked the part | |
| last_trans_time | part_inst | last_trans_time | Date and time of the last transaction against the part | |
| part_status | part_inst | part_status | Status of the part | |
| trans_auth | inv_locatn | trans_auth | States the type of transactions authorized for the inventory location; i.e., 0=All, 1=None, 2=Authorized Parts only. An authorized part is one for which there is a part_auth object | |
| sn_track | part_num | sn_track | Track part for serialization; i.e., 0=by quantity, 1=by serial number | |
| hdr_ind | part_inst | hdr_ind | Whether the part instance is a header which tracks a group of serial numbered part instances; i.e., 0=not a header instance, 1=is a header instance, default=0 | |
| fixed_bin_name | inv_bin | fixed_bin_name | For containers, the name of the fixed bin within which the container resides, for fixed bins this field is blank, default=' ' | |
| container_id | inv_bin | id_number | For containers, the ID of the container, for fixed bins this field is blank, default=' ' | |
| opened_ind | inv_bin | opened_ind | Indicates whether the bin allows parts to be moved in/out or not; i.e, 0=no, it s sealed, 1=yes it is opened, default=1 | |
| active | inv_bin | active | Indicates whether the bin is in use; i.e., 0=inactive, 1=active, default=1 | |