View Name:v_inv_locatn
View Number:5331
Group:Logistics
Description:View of inventory location information used by form Picked Parts (552)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidinv_roleobjidInventory role internal record number 3 (UNIQUE)
location_idinv_locatnobjidInventory location internal record number 
site_idsiteobjidSite internal record number 
location_nameinv_locatnlocation_nameFor physical inventory locations, the name of the location. For GL accounts, the account number 
locdescinv_locatnlocation_descrDescription of the inventory location or GL account 
inv_classinv_locatninv_classInventory location class; i.e.,0=inventory location, 1=capital GL account, 2=expense GL account 
trans_authinv_locatntrans_authStates 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_nameinv_rolerole_nameName of role played by the focus type; e.g., sites default-bad parts inventory location, inventory locations located-at site 
rankinv_rolerankFor 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 

Joins:

Join FromJoin To
(inv_role).inv_role2inv_locatn(inv_locatn).locatn2inv_role
(inv_role).inv_role2site(site).site2inv_role
My Recent Objects
v_inv_locatn