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 Code class assigned during the Cycle Count Calculate Parameters action. Only set for Cycle Counts	Search (1)
bin_objid_perp	LONG	int				DIRECT	Objid of perpetual inv bin	Search (1)
bin_type	LONG	smallint			0	DIRECT	User-defined type of bins; i.e., 0=fixed bin, 1=container, 2=pallet, default=0	Search (1)
blank_tag	LONG	int			0	DIRECT	Indicates whether the object was generated for an extra tag: 0=no, 1=yes, default=0	Search (1)
comments	CHAR	varchar		255			Notes about the count	Search (1)
count_date	CLK_TIME	datetime					Date this part was initially counted as part of this PI count	Search (1)
count_part_no	CHAR	varchar		40			Inventory part to be reconciled	Search (1)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
error_msg	CHAR	varchar		255			Used by the application to store any Accept Variance error which occurs while reconciling this count item
ext_cost_count	DECIMAL	decimal (19,4)				CURRENCY	Extended cost of the counted quantity of parts	Search (1)
ext_cost_final	DECIMAL	decimal (19,4)				CURRENCY	Extended Std Cost of the mod_level that was reconciled	Search (1)
ext_cost_perp	DECIMAL	decimal (19,4)				CURRENCY	Extended cost of the original quantity of parts	Search (1)
gen_date	CLK_TIME	datetime					Date the Physical Inventory was initiated	Search (1)
id_number	CHAR	varchar	4	32			Unique bin number assigned according to auto-numbering definition	Search (1)
inv_bin_count	CHAR	varchar		20			The inventory bin the part was counted in	Search (1)
inv_bin_perp	CHAR	varchar		20			The inventory bin the part is in according to the system	Search (1)
inv_loc_count	CHAR	varchar		20			The inventory location the part was counted in	Search (1)
inv_loc_perp	CHAR	varchar		20			The inventory location currently in the system	Search (1)
mod_objid	LONG	int				DIRECT	Mod level objid for blank tags
mv_bin_perp	CHAR	varchar		20			The movable inventory bin the part is in according to the system	Search (1)
mv_objid_perp	LONG	int				DIRECT	Objid of perpetual movable inv bin	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
opened_ind	LONG	tinyint			1	DIRECT	Indicates whether the bin allows parts to be moved in/out or not; i.e, 0=no, it s sealed, 1=yes it is opened, default=1	Search (1)
qty_bad_count	LONG	int				DIRECT	For parts tracked by quantity, the bad quantity physically counted	Search (1)
qty_bad_final	LONG	int				DIRECT	The bad quantity reconciled	Search (1)
qty_bad_perp	LONG	int				DIRECT	For parts tracked by quantity, the bad quantity currently in the system	Search (1)
qty_good_count	LONG	int				DIRECT	For parts tracked by quantity, the good quantity physically counted	Search (1)
qty_good_final	LONG	int				DIRECT	The good quantity reconciled	Search (1)
qty_good_perp	LONG	int				DIRECT	For parts tracked by quantity, the good quantity currently in the system	Search (1)
reconcile_date	CLK_TIME	datetime					Date the inv_count was reconciled via Active Variance action	Search (1)
recount_date	CLK_TIME	datetime					Date this part was re-counted as part of this PI count	Search (1)
reinit_date	CLK_TIME	datetime					Date the inv_count was re-initialized	Search (1)
rev_counted	CHAR	varchar		10			The part revision number physically counted	Search (1)
rev_perpetual	CHAR	varchar		10			The part revision number in the system	Search (1)
sn_counted	CHAR	varchar		30			For parts tracked by serial number, the part serial number physically counted	Search (1)
sn_perpetual	CHAR	varchar		30			For parts tracked by serial number, the part serial number in the system	Search (1)
status	CHAR	varchar		40			Internal status of this count	Search (1)
std_cost_count	DECIMAL	decimal (19,4)				CURRENCY	Active Std Cost of the mod_level that was counted	Search (1)
std_cost_final	DECIMAL	decimal (19,4)				CURRENCY	Active Std Cost of the mod_level that was reconciled	Search (1)
std_cost_perp	DECIMAL	decimal (19,4)				CURRENCY	Active Std Cost of the mod_level from part_inst	Search (1)
tag_count	CHAR	varchar		40			Unique ID for this unit to be counted	Search (1)
tag_recount	CHAR	varchar		40			Unique ID for this unit to be recounted	Search (1)
trans_id_in	CHAR	varchar		40			Transaction ID generated when transacting the counted information into inventory
trans_id_out	CHAR	varchar		40			Transaction ID generated when transacting the perpetual information out of inventory
trial_date	CLK_TIME	datetime					Last date the inv_count had trial reconciliation done	Search (1)
vi_trans_in	LONG	int				DIRECT	The virtual transactions calculated IN during trial reconciliation	Search (1)
vi_trans_out	LONG	int				DIRECT	The virtual transactions calculated OUT during trial reconciliation	Search (1)

Table Name:	inv_count
Table Number:	5175
Group:	Logistics
Description:	Represents the counting of a part_inst that participated in an inventory reconciliation count
Flags:
Baseline/Custom:	Baseline

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
count2count_setup	MTO	count_setup	setup2inv_count	Identifies the count profile that generated the count record	Search (1)
count2part_inst	MTO	part_inst	part_inst2inv_count	Inventory part_inst associated with the count
init_by2user	MTO	user	init_by2inv_count	User who initialized the count	Search (1)
counted_by2user	MTO	user	counted_by2inv_count	User who performed the count	Search (1)
recounted_by2user	MTO	user	recounted_by2inv_count	User who performed the recount	Search (1)
entered_by2user	MTO	user	entered_by2inv_count	User who physically entered the count into the system	Search (1)
trial_by2user	MTO	user	trial_by2inv_count	User who performed the last trial reconciliation	Search (1)

Index Name	Fields	Additional Information
cb2u5175	counted_by2user, entered_by2user, init_by2user, recounted_by2user, trial_by2user	nonclustered located on PRIMARY
ind_count2count_setup	count2count_setup, count_date, recount_date	nonclustered located on PRIMARY
ind_count2part_inst	count2part_inst	nonclustered located on PRIMARY
ind_entered_by2user	entered_by2user, counted_by2user, recounted_by2user	nonclustered located on PRIMARY
ind_rev_perpetual	rev_perpetual	nonclustered located on PRIMARY
ind_tag_count	tag_count, tag_recount	nonclustered located on PRIMARY
ind_tag_recount	tag_recount, tag_count	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog

Fields:

Relations:

Indexes: (Defined in Clarify Schema)

Indexes (Defined in Database):

Referenced in Views:

My Recent Objects

Quick Links