Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
abc_code	CHAR	varchar		8			ABC code classification for the mod_level	Search (1)
all_serv_level	CHAR	varchar		8			Reserved; future
all_stockout	CHAR	varchar		8			Reserved; future
average_usage	CHAR	varchar		8			Reserved; future
back_order_age	CHAR	varchar		8			Reserved; future
back_orders	LONG	int				DIRECT	Reserved; future
bad_pct	CHAR	varchar		8			Reserved; future
bad_qoh	LONG	int				DIRECT	Reserved; future
calc_mtbf	CHAR	varchar		10			Reserved; future
cs_good_pct	CHAR	varchar		8			Reserved; future
cs_good_qoh	LONG	int				DIRECT	Reserved; future
cs_serv_level	CHAR	varchar		8			Reserved; future
cs_stockout	CHAR	varchar		8			Reserved; future
cust_qoh	LONG	int				DIRECT	Reserved; future
cust_qoh_age	CHAR	varchar		8
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
exhi_mtbf	CHAR	varchar		10			Reserved; future
field_good_pct	CHAR	varchar		8			Reserved; future
field_good_qoh	LONG	int				DIRECT	Reserved; future
in_transit_pct	CHAR	varchar		8			Reserved; future
in_transit_qoh	LONG	int				DIRECT	Reserved; future
last_cycle_ct	CLK_TIME	datetime					Reserved; future
mttr	CHAR	varchar		8			Reserved; future
next_cycle_ct	CLK_TIME	datetime					Reserved; future
objid	LONG	int	3			DIRECT	Part_stat internal record number
open_order_age	CHAR	varchar		8			Reserved; future
open_orders	LONG	int				DIRECT	Reserved; future
open_reqs	LONG	int				DIRECT	Reserved; future
open_reqs_age	CHAR	varchar		8			Reserved; future
pi_date	CLK_TIME	datetime					Reserved; future
rtv_pct	CHAR	varchar		8			Reserved; future
rtv_qoh	LONG	int				DIRECT	Reserved; future
total_qoh	LONG	int				DIRECT	Reserved; future
turn_ratio	DECIMAL	decimal (19,4)					Part usage for parts included in a cycle count profile	Search (1)
turns_ratio	CHAR	varchar		8			Reserved; future

Table Name:	part_stats
Table Number:	223
Group:	Logistics
Description:	Holds system-wide inventory and performance statistics on part revisions
Flags:
Baseline/Custom:	Baseline

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