Table Name:	part_used
Table Number:	306
Group:	Logistics
Description:	Records a part install/deinstall transaction in ClearSupport
Flags:	CACHEOBJIDS
Baseline/Custom:	Baseline

select * from table_part_used

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
case_id_number	CHAR	varchar		255			Case number for transaction	Search (5)
detail_number	CHAR	varchar	4	20			The part request number for the part used action. Same as the part request, detail number	Search (5)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
dtl_condtn	CHAR	varchar		80			Used for temporary storage of the related part request's condition	Search (5)
failure_status	CHAR	varchar		40			Type of part failure. This is a user-defined pop up list with default name=FAILURE_CODE	Search (5)
ins_notes	CHAR	varchar		60			Notes for the staged installed part transaction
ins_stand_cost	DECIMAL	decimal (19,4)				CURRENCY	Standard cost of the part number used in the installed part transaction
ins_trans_type	LONG	smallint				DIRECT	Staged transaction type of the installed part; i.e., 1=fulfill, 2=receive, 3=remove, 4=transfer, 5=install	Search (2)
install_qty	LONG	int				DIRECT	Number of parts installed	Search (5)
install_serial	CHAR	varchar		30			Serial number of the installed part	Search (5)
inv_status	CHAR	varchar		40			Status of the inventory update for the part used activity; i.e., new=not attempted, failed=attempted and failed, complete=completed successfully	Search (5)
objid	LONG	int	3			DIRECT	Internal record number	Search (6)
part_price	DECIMAL	decimal (19,4)				CURRENCY	The price from the part request	Search (2)
part_used_date	CLK_TIME	datetime					Date/time of transaction	Search (5)
price	CHAR	varchar		20			Reserved; obsolete	Search (5)
rem_mod_level	CHAR	varchar		10			Revision number of removed product	Search (5)
rem_move_type	LONG	int				DIRECT	Movement type for the staged removed part transaction; i.e., 1=good to good, 2=good to bad, 3=bad to good, 4=bad to bad
rem_notes	CHAR	varchar		60			Notes for the staged removed part transaction
rem_part_name	CHAR	varchar		255			Part description of removed part	Search (5)
rem_part_num	CHAR	varchar		30			Part number of removed product	Search (5)
rem_stand_cost	DECIMAL	decimal (19,4)				CURRENCY	Standard cost of the part number used in the removed part transaction
rem_status	LONG	smallint				DIRECT	Condition of the removed part; i.e., 1=good, 2=bad
rem_trans_type	LONG	smallint				DIRECT	Staged transaction type of the removed part; i.e., 1=fulfill, 2=receive, 3=remove, 4=transfer, 5=install
remove_qty	LONG	int				DIRECT	Number of parts removed	Search (5)
remove_serial	CHAR	varchar		30			Serial number of the removed part	Search (5)
status	CHAR	varchar		40			Status of the transaction	Search (5)
trans_type	CHAR	varchar		40			Transaction type- from user-defined pop up with default name TRANS_TYPE	Search (5)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views
part_used2bin_role	OTM	bin_role	bin_role2part_used	Inventory bins that are staged for an inventory update transaction. Removed once transaction has been completed
part_used2case	MTO	case	case2part_used	Case which initiated the parts used
part_used2demand_dtl	MTO	demand_dtl	demand_dtl2part_used	Demand_dtl that is staged for an inventory update transaction stemming from the part_used. Removed once the transaction has been completed
part_used2inst_part_info	MTO	mod_level	inst_part_info2part_used	Part revision installed with the part used transaction	Search (4)
part_used2rem_part_info	MTO	mod_level	rem_part_info2part_used	Part revision replaced with the part used transaction	Search (2)
part_used2remove_trans	OTOP	part_trans	remove_trans2part_used	Remove logistics part transaction for the part used transaction. Reserced
part_used2install_trans	OTOP	part_trans	install_trans2part_used	Install logistics part transaction for the part used transaction
part_used2site_part	MTO	site_part	site_part2part_used	Part under which to install the installed part	Search (5)
part_used2rem_site_part	MTO	site_part	rem_site_part2part_used	Part replaced for the part used transaction
part_used2inst_site_part	MTO	site_part	inst_site_part2part_used	Site_part installed with the part_used transaction
part_used2assigned_eng	MTO	user	assigned_eng2part_used	User that performed the part used transaction	Search (2)

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
ind_part_used2inst_part_info	part_used2inst_part_info	nonclustered located on PRIMARY
ind_part_used2install_trans	part_used2install_trans	nonclustered located on PRIMARY
ind_part_used2remove_trans	part_used2remove_trans	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
pu2isp0306	part_used2inst_site_part, part_used2rem_part_info	nonclustered located on PRIMARY
pu2rpi0306	part_used2rem_part_info, part_used2inst_site_part	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
307	prtused_view	mod_level, part_num, part_used, site_part
308	prtuse1_view	mod_level, part_num, part_used, site_part
309	prtuse2_view	mod_level, part_num, part_used, site_part
6027	prtuse_view1	mod_level, part_num, part_used, site_part, user
6028	prtuse_view2	mod_level, part_used, site_part, user
6029	part_used_view	part_used

My Recent Objects

part_used

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