| objid | part_inst | objid | Inventory part internal record number | 3 (UNIQUE) |
| location_id | inv_locatn | objid | Inventory location internal record number | |
| site_id | site | objid | Site 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 internal record number | |
| part_descr | part_num | description | Description of the product | |
| 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 inventory installed 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 | Part revison of the inventory part | |
| locdesc | inv_locatn | location_descr | Description of the inventory location or GL account | |
| last_trans_time | part_inst | last_trans_time | Date and time of the last transaction against the part instance | |
| part_status | part_inst | part_status | Status of the inventory part | |
| inv_class | inv_locatn | inv_class | Inventory location class; i.e., 0=inventory location, 1=capital GL account, 2=expense GL account | |
| 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 | |
| role_name | inv_role | role_name | Name of role played by the focus type; e.g., sites default-bad parts inventory location, inventory locations located-at site | |
| rank | inv_role | rank | For servicing inventory locations, ranks the order in which locations should be displayed for a given site in the Pick form; e.g., 0=not applicable, 1=first displayed, 2=second displayed, etc., default=0 | |
| hdr_ind | part_inst | hdr_ind | Whether the part instance is a header which tracks a group of serialized part instances; 0=serial tracked part instance, 1=serial tracked header instance, 2=quantity tracked part instance, 3=empty header instance, default=0 | |