objid | container(inv_bin) | objid | Container inventory bin internal record number | 3 (UNIQUE) |
id | container(inv_bin) | id_number | Container unique bin number assigned by auto-numbering definition | |
name | container(inv_bin) | bin_name | Unique name of the container within an inventory bin | |
status | container(inv_bin) | opened_ind | Indicates whether the container bin allows parts to be moved in/out or not | |
locname | container(inv_bin) | location_name | For display only of the container's inventory location name | |
parent_objid | parent(inv_bin) | objid | Parent inventory bin internal record number | |
bin_name | parent(inv_bin) | bin_name | Parent inventory bin unique name within an inventory location | |
fixbin_objid | fixbin(inv_bin) | objid | Fixed inventory bin internal record number | |
fixbin_name | fixbin(inv_bin) | bin_name | Fixed inventory bin unique name within an inventory location | |
loc_objid | inv_locatn | objid | Inventory location internal record number | |
loc_name | inv_locatn | location_name | For physical inventory locations, the name of the location. For GL accounts, the account number | |
site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
site_name | site | name | Site name | |
site_objid | site | objid | Site internal record number | |
role_name | inv_role | role_name | Name of role played by the focus type; e.g., site's default-bad parts inventory location, inventory locations located-at site | |
role_objid | inv_role | objid | Inv_role internal record number | |
loc_turn_ratio | inv_locatn | loc_turn_ratio | Reserved; future | |