View Name:container_v
View Number:5279
Group:Logistics
Description:Used by the forms Container Tracking (8470) and Move Container (8471)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontainer(inv_bin)objidContainer inventory bin internal record number 3 (UNIQUE)
idcontainer(inv_bin)id_numberContainer unique bin number assigned by auto-numbering definition 
namecontainer(inv_bin)bin_nameUnique name of the container within an inventory bin 
statuscontainer(inv_bin)opened_indIndicates whether the container bin allows parts to be moved in/out or not 
locnamecontainer(inv_bin)location_nameFor display only of the container's inventory location name 
parent_objidparent(inv_bin)objidParent inventory bin internal record number 
bin_nameparent(inv_bin)bin_nameParent inventory bin unique name within an inventory location 
fixbin_objidfixbin(inv_bin)objidFixed inventory bin internal record number 
fixbin_namefixbin(inv_bin)bin_nameFixed inventory bin unique name within an inventory location 
loc_objidinv_locatnobjidInventory location internal record number 
loc_nameinv_locatnlocation_nameFor physical inventory locations, the name of the location. For GL accounts, the account number 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameSite name 
site_objidsiteobjidSite internal record number 
role_nameinv_rolerole_nameName of role played by the focus type; e.g., site's default-bad parts inventory location, inventory locations located-at site 
role_objidinv_roleobjidInv_role internal record number 
loc_turn_ratioinv_locatnloc_turn_ratioReserved; future 

Joins:

Join FromJoin To
container(inv_bin).child2inv_binparent(inv_bin).parent2inv_bin
container(inv_bin).movable_bin2inv_binfixbin(inv_bin).fixed_bin2inv_bin
container(inv_bin).inv_bin2inv_locatn(inv_locatn).inv_locatn2inv_bin
(inv_role).inv_role2inv_locatn(inv_locatn).locatn2inv_role
(inv_role).inv_role2site(site).site2inv_role
My Recent Objects
container_v