View Name:ccprt_auth_stats
View Number:5318
Group:Logistics
Description:Displays cycle count part valuation statistics data. Used by form Cycle Count Calculate Parameters (8437)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_ccprt_auth_stats
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidauth_statsobjidPart authorization stats internal record number 3 (UNIQUE)
invest_valauth_statsinvest_valCalculated investment valuation for this Cycle Count part 
as_of_dateauth_statsas_of_dateDate and time the valuation stat was taken for this cycle count part 
auth_objidpart_authobjidPart authorization internal record number 
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 
part_numberpart_numpart_numberPart number/name 
binnameinv_binbin_nameName of the inventory bin 
mod_levelmod_levelmod_levelName of the part revision 
cc_objidcycle_countobjidcycle count internal record number 
cc_namecycle_countct_namecycle count name 

Joins:

Join FromJoin To
(auth_stats).auth_stats2part_auth(part_auth).part_auth2auth_stats
(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
(part_auth).part_auth2cycle_count(cycle_count).ccount2part_auth
My Recent Objects
ccprt_auth_stats      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user