Table Name:	count_setup
Table Number:	5174
Group:	Logistics
Description:	Describes the count profile for a particular physical inventory reconciliation
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_count_setup

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
blind_count	LONG	int			1	DIRECT	Indicates whether the count is blind; i.e., 0=false, 1=true, default=1
cc_ct_date	CLK_TIME	datetime					Date Cycle Count count is to be performed	Search (1)
count_descr	CHAR	varchar		255			Description for this count profile
count_id	CHAR	varchar		30			Unique ID for count profile	Search (2)
count_name	CHAR	varchar		40			Nameof the count profile	Search (2)
count_type	CHAR	varchar		40			Type of count profile. This is from a user_defined popup list with default name Count Type
cutoff_date	CLK_TIME	datetime					Date this count should be completed
cutoff_duration	LONG	int				DIRECT	Duration that the count must be completed in
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
extra_tags	LONG	smallint				DIRECT	Quantity of extra tags to be generated for each location/bin
gl_account	CHAR	varchar		20			Default variance GL account for this count reconciliation
last_ct_ind	LONG	tinyint			0	DIRECT	Indicates whether this is the last count profile for a cycle count; i.e., 0=no, 1=yes, default=0
last_mod_date	CLK_TIME	datetime					Date this count was last updated
objid	LONG	int	3			DIRECT	Internal record number	Search (2)
profile_type	CHAR	varchar		40			Type of count profile. This is from a Clarify application defined list - Physical, Cycle, Operational
status	CHAR	varchar		40			Internal status of this count	Search (1)
tag_print_date	CLK_TIME	datetime					Date the tags for this count were last printed
tag_type	LONG	int			0	DIRECT	Indicates type of tag to print; i.e., 0=Tag, 1=Sheet, default=0
variance_warn	LONG	int			0	DIRECT	Indicates whether a blind count posts warning if count entered varies from perpetual; i.e., 0=false, 1=true, default=0

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
setup2act_entry	OTM	act_entry	act_entry2count_setup	Audit of major activities against the count profile
setup2cycle_count	MTO	cycle_count	ccount2count_setup	Related cycle count
setup2inv_bin	MTM	inv_bin	setup2count_setup	Identifies the inventory bins that will be counted		mtm_inv_bin7_ count_setup0	Search (1)
setup2inv_count	OTM	inv_count	count2count_setup	Identifies the inventory counts that the profile controls
setup2part_auth	OTM	part_auth	part_auth2count_setup	Cycle Count parts that make up the scheduled CC Profile

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
count_id_ind	count_id	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
count_id_ind	count_id	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5177	countlocbin	count_setup, inv_bin, inv_locatn, inv_role, site
5178	reconcilecnt	count_setup, inv_count, user

My Recent Objects

count_setup

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user