View Name:ccprt_at_loc
View Number:5304
Group:Logistics
Description:Displays cycle count part data. Used by forms Cycle Count Stratification(8438)
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 
active_cc_indpart_authactive_cc_indIndicates whether this mod level is active for cycle counting 
abc_cd_clspart_authabc_cd_clsCalculated ABC classification code for cycle counting part instances 
turn_ratiopart_authturn_ratioTurn ratio for authorized parts included in a cycle count profile 
last_cycle_ctpart_authlast_cycle_ctDate and time of last cycle count 
average_usagepart_authaverage_usagePart usage for authorized parts included in a cycle count profile. Reserved; future 
last_calc_valpart_authlast_calc_valLast calculated valuation for the Cycle Count part 
opn_ord_qtypart_authopn_ord_qtyTotal quantity of the part currently on order for the bin 
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 
part_good_qohpart_authpart_good_qohGood on hand quantity 
part_bad_qohpart_authpart_bad_qohBad on hand quantity 
sn_trackpart_numsn_trackPart number/name 
times_cc_ctpart_authtimes_cc_ctTimes this part has already been scheduled for this Cycle count 

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
(part_auth).part_auth2cycle_count(cycle_count).ccount2part_auth
My Recent Objects
ccprt_at_loc