View Name:locatn_view
View Number:407
Group:Logistics
Description:Used by the Select Accounts and Locations form (515), Part Stocking Levels (517), Servicing Locations for Site (8418), Serv Sites for Location (8419) and Inventory Location Rollups (8431)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
loc_objidinv_locatnobjidInventory location internal record number 3 (UNIQUE)
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 
reports_to_locinv_locatnreports_to_locThe parent inventory location name or, if GL account, the parent GL account number 
role_nameinv_rolerole_nameName of the inventory role 
gl_acct_noinv_locatngl_acct_noIf 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_classinv_locatninv_class0=inventory location, 1=capital GL account, 2=expense GL account 
mdbksitemdbkUsed, transiently, to hold the translation of inv_class 
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 
site_typesitesite_typeMnemonic representation of the integer site type field 
regionsiteregionRegion to which the site belongs 
addressaddressaddressLine 1 of address which includes street number, street name, office, building, or suite number, etc 
cityaddresscityThe city for the specified address 
stateaddressstateThe state for the specified address 
zipaddresszipcodeThe state for the specified address 
activeinv_locatnactiveIndicates whether the current part authorization is active; i.e., 0=inactive, 1=active, default=1 

Joins:

Join FromJoin To
(inv_role).inv_role2inv_locatn(inv_locatn).locatn2inv_role
(inv_role).inv_role2site(site).site2inv_role
(site).cust_primaddr2address(address).primary_addr2site
My Recent Objects
locatn_view