View Name:prt_at_loc
View Number:241
Group:Logistics
Description:Displays part location and authorization data. Used by forms Copy Stocking Level (518), Part Stocking Level (517), and Select Part Stocking Level (557)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_authobjidPart authorization internal record number 3 (UNIQUE)
locatn_objidinv_locatnobjidInventory location internal record number 
part_num_objidpart_numobjidPart number internal record number 
part_mod_objidmod_levelobjidPart revision internal record number 
bin_objidinv_binobjidInventory bin internal record number 
locationinv_locatnlocation_nameName of the inventory location 
descriptioninv_locatnlocation_descrDescription of the inventory location 
part_numberpart_numpart_numberPart number/name 
part_descrpart_numdescriptionProduct description 
authorizedinv_locatntrans_authThe 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 
statusmod_levelactiveActive/inactive/obsolete 
opn_ord_qtypart_authopn_ord_qtyTotal quantity of the part currently on order for the bin 
allocate_exchpart_authallocate_exchReserved; future 
allocate_replnpart_authallocate_replnReserved; future 
allocate_otherpart_authallocate_otherReserved; future 
part_rolpart_authpart_rolReserved; future 
part_roqpart_authpart_roqReserved; future 
part_maximumpart_authpart_maximumMaximum quantity that auto replenishment will fill 
part_minimumpart_authpart_minimumMinimum quanty permitted before auto replenishment 
hard_salelimitpart_authhard_salelimitReserved; future 
hard_exchlimitpart_authhard_exchlimitReserved; future 
hard_repllimitpart_authhard_repllimitReserved; future 
binnameinv_binbin_nameName of the inventory bin 
part_numpart_numdescriptionDescription of the product 
repl_queuepart_authrepl_queueDefault queue to which the auto replenishment part request will be dispatched 
mod_levelmod_levelmod_levelName of the part revision 
primary_indpart_authprimary_indIndicates whether the related bin is the primary bin for the related part revision within the bin's inventory location; i.e., 0=no, 1=yes, default=0 
turn_ratiopart_authturn_ratioTurn ratio for authorized parts included in a cycle count profile 
abc_cd_clspart_authabc_cd_clsCalculated ABC classification code for cycle counting part instances 
part_good_qohpart_authpart_good_qohStores the cumulative part good quantity on hand for the part/location/bin 
part_bad_qohpart_authpart_bad_qohStores the cumulative part bad quantity on hand for the part/location/bin 
activepart_authactiveIndicates whether the current part authorization is active; i.e., 0=inactive, 1=active, default=1 
active_cc_indpart_authactive_cc_indIndicates whether this PSL is active for Cycle Counting; i.e., 0=no, 1=yes, default=0 

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
(mod_level).part_info2part_num(part_num).part_num2mod_level
(inv_bin).inv_bin2inv_locatn(inv_locatn).inv_locatn2inv_bin
My Recent Objects
prt_at_loc