Table Name:	cycle_setup
Table Number:	5292
Group:	Logistics
Description:	Cycle count parameters for global, system-wide settings as well as for inventory locations that have been indicated as cycle count reporting locations
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_cycle_setup

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
abc_cd_cls	CHAR	varchar		8			ABC classification code for cycle counting part instances	Search (1)
abc_cd_desc	CHAR	varchar		80			ABC code description	Search (1)
abc_cd_rank	LONG	tinyint			0	DIRECT	Valuation ranking of ABC Code class	Search (1)
abc_global	LONG	tinyint			0	DIRECT	Indicates whether system-wide ABC code default will be used when determining stratification value parameters; i.e., 0=no, 1=yes, default=0
abc_pct	FLOAT	real					ABC code percentage of part instances to be counted	Search (1)
cost_tolerance	DECIMAL	decimal (19,4)				CURRENCY	Cycle count accuracy tolerance expressed as a currency amount	Search (1)
ct_per_day	LONG	int				DIRECT	Calculated ABC code counts per day for code class	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
frequency	LONG	smallint				DIRECT	Cycle count frequency parameter expressed in number of counts/per year	Search (1)
last_ct_per_day	LONG	int				DIRECT	Calculated ABC code counts per day for the last count of the cycle count	Search (1)
num_cc_parts	LONG	int				DIRECT	Number of Cycle Count parts assigned to the code class	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
pct_tolerance	FLOAT	real					Cycle count accuracy tolerance expressed as a percent	Search (1)
val_freq	LONG	smallint				DIRECT	Frequency in days used when determining stratification value parameters	Search (1)
val_from	DECIMAL	decimal (19,4)				CURRENCY	Low value of currency units for stratification value	Search (1)
val_to	DECIMAL	decimal (19,4)				CURRENCY	High value of currency units for stratification value	Search (1)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
csetup2cycle_count	MTO	cycle_count	ccount2cycle_setup	Related cycle count			Search (1)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_csetup2cycle_count	csetup2cycle_count	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5303	cc_params_v	cycle_count, cycle_setup, rollup

My Recent Objects

cycle_setup

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user