View Name:cc_params_v
View Number:5303
Group:Logistics
Description:Displays Cycle Count Parameters. Used by Cycle Count Parameters form (8432)
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline
select * from table_cc_params_v
Keyboard shortcuts available

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcycle_setupobjidInternal objid 3 (UNIQUE)
abc_cd_clscycle_setupabc_cd_clsABC Code Classification 
abc_cd_desccycle_setupabc_cd_descDescription for this ABC Code Classification 
abc_cd_rankcycle_setupabc_cd_rankValuation ranking of ABC Code class 
abc_pctcycle_setupabc_pctABC Code percentage of parts 
frequencycycle_setupfrequencyCycle count frequency parameter for counts per year 
pct_tolerancecycle_setuppct_toleranceCycle count accuracy tolerance based on percent 
cost_tolerancecycle_setupcost_toleranceCycle count accuracy tolerance based on cost 
ct_dayscycle_countct_daysCounting days used in cycle count for a location rollup 
ct_per_daycycle_setupct_per_dayCalculated ABC Code counts per day for a location rollup 
last_ct_per_daycycle_setuplast_ct_per_dayCalculated ABC Code counts per day for a location rollup 
val_fromcycle_setupval_fromLow value of monetary units for stratification value 
val_tocycle_setupval_toHigh value of monetary units for stratification value 
val_freqcycle_setupval_freqValuation frequency for ABC Classification 
dflt_pct_indcycle_countdflt_pct_indIdentifies if system-wide ABC code default will be used when determining stratification value parameters 
dflt_turn_indcycle_countdflt_turn_indIdentifies if mod-level turn ratio will be used when determining stratification value parameters 
dflt_abc_indcycle_countdflt_abc_indIdentifies if mod-level ABC Code default will be used when determining stratification value parameters 
cc_objidcycle_countobjidCycle count internal record number 
cc_namecycle_countct_nameName of the rollup 
rollup_objidrollupobjidRollup internal record number 
rollup_namerollupnameName of the rollup 
num_cc_partscycle_setupnum_cc_partsNumber of Cycle Count parts assigned to the code class 

Joins:

Join FromJoin To
(cycle_setup).csetup2cycle_count(cycle_count).ccount2cycle_setup
(cycle_count).ccount2rollup(rollup).rollup2cycle_count
My Recent Objects
cc_params_v      
       
       
Quick Links
act_entry case contact employee
rol_contct site site_view user