Table Name:	part_inst
Table Number:	239
Group:	Logistics
Description:	Describes an instance of an inventory part. If serialized it is one part in inventory. If tracked-by-quantity, it is a quantity of like parts in an inventory location
Flags:
Baseline/Custom:	Baseline

select * from table_part_inst

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
bad_res_qty	LONG	int				DIRECT	For parts tracked by quantity, the bad reserved quantity	Search (2)
date_in_serv	CLK_TIME	datetime					Date the part was placed in service
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
good_res_qty	LONG	int				DIRECT	For parts tracked by quantity, the good reserved quantity	Search (2)
hdr_ind	LONG	tinyint			0	DIRECT	Whether the part instance is a header which tracks a group of serialized part instances; 0=serial tracked part instance, 1=serial tracked header instance, 2=quantity tracked part instance, 3=empty serial tracked header instance, default=0	Search (2)
last_cycle_ct	CLK_TIME	datetime					Reserved; future
last_mod_time	CLK_TIME	datetime					Reserved; future
last_pi_date	CLK_TIME	datetime					Date of the last inventory count reconciliation for the inventory part
last_trans_time	CLK_TIME	datetime					Date and time of the last transaction against the inventory part	Search (3)
next_cycle_ct	CLK_TIME	datetime					Reserved; future
objid	LONG	int	3			DIRECT	Internal record number	Search (8)
part_bad_qty	LONG	int				DIRECT	For parts tracked by quantity, the quantity not usable	Search (5)
part_bin	CHAR	varchar		20			The inventory bin the part is now located in
part_good_qty	LONG	int				DIRECT	For parts tracked by quantity, the quantity usable	Search (5)
part_mod	CHAR	varchar		10			The part revision number
part_serial_no	CHAR	varchar		30			For parts tracked by serial number, the part serial number	Search (8)
part_status	CHAR	varchar		40			Status of the inventory part	Search (3)
pi_tag_no	CHAR	varchar		8			Tag number associated with the last inventory count reconciliation for the inventory part
pick_request	CHAR	varchar	4	255			The detail numbers for the requests that have currently picked the part	Search (2)
repair_date	CLK_TIME	datetime					Reserved; future
transaction_id	CHAR	varchar		20			The unique number of the part transaction
warr_end_date	CLK_TIME	datetime					Date the warranty expires

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	MTM Table	Used in Views
part_inst2demand_dtl	OTM	demand_dtl	demand_dtl2part_inst	Replace by recd2demand_dtl for all operations except for ECO upgrades, which set this relation from the upgraded part_inst
pick_part2demand_dtl	OTM	demand_dtl	demand_dtl2pick_part	Reserved; obsolete. Replaced by pickd2demand_dtl
fulfill2demand_dtl	MTO	demand_dtl	fulfill_dtl2part_inst	Reserved; obsolete. Replaced by fulflld2demand_dtl
recd2demand_dtl	MTM	demand_dtl	recd_dtl2part_inst	Part requests which have received the part instance	mtm_demand_dtl31_ part_inst11
pickd2demand_dtl	MTM	demand_dtl	pickd_dtl2part_inst	Part requests which have picked (saved) the instance. Note: this relation holds only until the demand_dtl has been fulfilled, at which time it is nulled	mtm_demand_dtl32_ part_inst12
fulflld2demand_dtl	MTM	demand_dtl	fulflld_dtl2part_inst	Part requests which have been fulfilled by the part instance	mtm_demand_dtl33_ part_inst13
part_inst2inv_bin	MTO	inv_bin	inv_bin2part_inst	Inventory bin in which the instance is currently located		Search (5)
part_inst2inv_count	OTM	inv_count	count2part_inst	Inventory counts made of the part instance
n_part_inst2part_mod	MTO	mod_level	n_part_info2part_inst	The part version of the inventory part		Search (9)
part_inst2onsite_log	OTM	onsite_log	onsite_log2part_inst	Repair summary information for the part instance
hdr2part_inst	OTM	part_inst	dtl2part_inst	Serial numbered part_inst tracked by the header instance
dtl2part_inst	MTO	part_inst	hdr2part_inst	Header part inst tracking the detail serial numbered instance
eco_orig2part_inst	OTM	part_inst	eco_new2part_inst	The part instances resulting from an upgrade of the current part instances
eco_new2part_inst	MTO	part_inst	eco_orig2part_inst	The part instance the current part instance was upgraded from
from_inst2part_trans	OTM	part_trans	from_inst2part_inst	Part transactions which decremented a quantity of the inventory part
to_inst2part_trans	OTM	part_trans	to_inst2part_inst	Part transactions which incremented a quantity of the part

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_fulfill2demand_dtl	fulfill2demand_dtl	nonclustered located on PRIMARY
ind_n_part_inst2part_mod	n_part_inst2part_mod	nonclustered located on PRIMARY
ind_part_inst2inv_bin	part_inst2inv_bin	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
19	trans_sum	inv_bin, mod_level, part_inst, part_num, part_trans
23	recv_sum	demand_dtl, demand_hdr, inv_bin, inv_locatn, mod_level, part_inst, part_num, part_trans, recv_parts
62	locs_view	inv_bin, inv_locatn, mod_level, part_inst, part_num
221	repair_sum	demand_dtl, demand_hdr, mod_level, part_inst, part_num
240	parts_view	inv_bin, inv_locatn, mod_level, part_inst, part_num
280	prtins_view	inv_bin, inv_locatn, mod_level, part_inst, part_num
397	sit_prt_view	inv_bin, inv_locatn, inv_role, mod_level, part_inst, part_num, site
409	part_inst_alst	act_entry, gbst_elm, part_inst, part_trans, user
5320	trans_gl_sum	inv_bin, mod_level, part_inst, part_num, part_trans
5330	v_part_bin	inv_bin, inv_locatn, mod_level, part_inst, part_num

My Recent Objects

part_inst

Quick Links

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