View Name:pn_at_loc
View Number:242
Group:Logistics
Description:Installed part at a specific site location. Used by form Group Authorize (518)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_authobjidPart auth internal record number 3 (UNIQUE)
namepart_numdescriptionMaps to sales and mfg systems 
familypart_numfamilyMarketing product family the part belongs to; new user-defined pop up replaces relation to gbst_elm 
linepart_numlineMarketing product line, within family, of the part; new user-defined pop up replaces relation to gbst_elm 
part_numberpart_numpart_numberPart number/name 
mod_levelmod_levelmod_levelRevision level 
model_numpart_nummodel_numMarketing model number of the part; within family and line 
part_typepart_numdomainName of the domain which governs the part's behavior in Configuration Manager 
activemod_levelactiveStatus; i.e., Active/inactive/obsolete 
pmh_objidpart_numobjidPart_num internal record number 
locnameinv_locatnlocation_nameName of the inventory location 
locdescinv_locatnlocation_descrDescription of the inventory location 
bin_nameinv_binbin_nameUnique name of the inventory bin within an inventory location 
part_descpart_numdescriptionMaps to sales and mfg systems 
part_auth_objidpart_authobjidPart_auth internal record number 
part_minimumpart_authpart_minimumMinimum stock level for the part in the bin/location 
part_maximumpart_authpart_maximumMaximum stock level for the part in the bin/location 
part_rolpart_authpart_rolNumber of parts in stock at which or below a replenishment order is generated to increase the number of parts to the maximum stocking level 
part_roqpart_authpart_roqThe quantity of parts ordered when a replenishment order is generated 
part_mod_objidmod_levelobjidMod_level internal record number 

Joins:

Join FromJoin To
(part_auth).part_auth2inv_bin(inv_bin).inv_bin2part_auth
(part_auth).n_auth_parts2part_mod(mod_level).n_part_info2part_auth
(inv_bin).inv_bin2inv_locatn(inv_locatn).inv_locatn2inv_bin
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
pn_at_loc