| loc_objid | 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 | |
| location_descr | inv_locatn | location_descr | Description of the inventory location or GL account | |
| location_type | inv_locatn | location_type | User-defined types of physical inventory location | |
| reports_to_loc | inv_locatn | reports_to_loc | The parent inventory location name or, if GL account, the parent GL account number | |
| role_name | inv_role | role_name | Name of the inventory role | |
| gl_acct_no | inv_locatn | gl_acct_no | If the current object is a physical location, the GL account number. If a GL account, the field is either empty, or contains the parent GL account number | |
| inv_class | inv_locatn | inv_class | 0=inventory location, 1=capital GL account, 2=expense GL account | |
| loc_type | inv_bin | location_name | For display only of the inventory location type | |
| bin_name | inv_bin | bin_name | Unique name of the inventory bin within an inventory location | |
| bin_objid | inv_bin | objid | Inventory bin internal record number | 3 (UNIQUE) |
| active | inv_bin | active | Indicates whether the bin is in use; i.e., 0=inactive, 1=active, default=1 | |
| id_number | inv_bin | id_number | Unique bin number assigned according to auto-numbering definition | |
| 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 | |
| fixed_ind | inv_bin | fixed_ind | Indicates whether the bin is movable or not; i.e., 0=no it is fixed, 1=yes, it is moveable, default=0 | |
| bin_type | inv_bin | bin_type | User-defined type of bins; i.e., 0=fixed bin, 1=container, 2=pallet, 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=' ' | |
| loc_active | inv_locatn | active | Indicates whether the inventory location is active; i.e., 0=inactive, 1=active, default=1 | |