View Name:prt_inv_auth
View Number:73
Group:Logistics
Description:Selects part authorization details
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidpart_authobjidDisplays part_auth object ID number 3 (UNIQUE)
mod_objidmod_levelobjidDisplays mod_level object ID number 
part_objidpart_numobjidDisplays part_num object ID number 
inv_bin_objidinv_binobjidDisplays inv_bin object ID number 
mod_levelmod_levelmod_levelDisplays mod_level name 
part_rolpart_authpart_rolDisplays reorder level 
part_good_qohpart_authpart_good_qohDisplays good quantity on hand 
part_bad_qohpart_authpart_bad_qohDisplays bad quantity on hand 
opn_ord_qtypart_authopn_ord_qtyDisplays quantity ordered on last replenishment parts request 
part_roqpart_authpart_roqThe quantity of parts ordered when a replenishment order is generated 
repl_queuepart_authrepl_queueTitle of the queue to which demands generated via auto-replenishment will be dispatched 

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
My Recent Objects
prt_inv_auth