View Name:countlocbin
View Number:5177
Group:Logistics
Description:Used by the Inventory Count form (8411) to show all locations and bins associated with this inventory count
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcount_setupobjidCount_setup internal record number 3 (UNIQUE)
count_namecount_setupcount_nameThe name of this inventory reconciliation count profile 
loc_objidinv_locatnobjidInventory location internal record number 
location_nameinv_locatnlocation_nameFor physical inventory locations, the name of the location. For GL accounts, the account number 
location_descrinv_locatnlocation_descrDescription of the inventory location or GL account 
location_typeinv_locatnlocation_typeUser-defined types of physical inventory location 
site_idsitesite_idSite ID number assigned according to auto-numbering definition 
site_namesitenameSite name 
site_objidsiteobjidSite internal record number 
bin_nameinv_binbin_nameUnique name of the inventory bin within an inventory location 
bin_objidinv_binobjidInventory bin internal record number 
role_nameinv_rolerole_nameRole being played by the inventory location or the site 
count_idcount_setupcount_idThe unique identifier for this inventory reconciliation count profile 
cc_ct_datecount_setupcc_ct_dateThe scheduled date for this count profile 

Joins:

Join FromJoin To
(count_setup).setup2inv_bin(inv_bin).setup2count_setup
(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
countlocbin