Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment
date1	CLK_TIME	datetime					Date value; meaning depends on part type
date2	CLK_TIME	datetime					Date value; meaning depends on part type
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
long1	LONG	int				DIRECT	Integer value; meaning depends on part type
long2	LONG	int				DIRECT	Integer value; meaning depends on part type
long3	LONG	int				DIRECT	Integer value; meaning depends on part type
long4	LONG	int				DIRECT	Integer value; meaning depends on part type
long5	LONG	int				DIRECT	Integer value; meaning depends on part type
long6	LONG	int				DIRECT	Integer value; meaning depends on part type
long7	LONG	int				DIRECT	Integer value; meaning depends on part type
long8	LONG	int				DIRECT	Integer value; meaning depends on part type
machine_id	CHAR	varchar		80			Parent site_part machine ID. Used for SMS compare
objid	LONG	int	3			DIRECT	Internal record number
part_type	LONG	int				DIRECT	Record type; i.e., 1=AuditedSoftware, 2=Disk, 3=Environment, 4=Identification, 5=NetworkCard, 6=Network, 7=OperatingSystem, 8=Processor, 9=Video, 10=WorkstationStatus, 11=Memory
text1	CHAR	varchar		255			Character value; meaning depends on part type
text2	CHAR	varchar		255			Character value; meaning depends on part type
text3	CHAR	varchar		255			Character value; meaning depends on part type
text4	CHAR	varchar		255			Character value; meaning depends on part type
text5	CHAR	varchar		255			Character value; meaning depends on part type
text6	CHAR	varchar		255			Character value; meaning depends on part type
text7	CHAR	varchar		255			Character value; meaning depends on part type
text8	CHAR	varchar		255			Character value; meaning depends on part type
text9	CHAR	varchar		255			Character value; meaning depends on part type

Table Name:	part_detail
Table Number:	5035
Group:	Product Mgr
Description:	Contains record types with part data for systems management. Reserved; option
Flags:
Baseline/Custom:	Baseline

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
part_detail2site_part	OTOF	site_part	site_part2part_detail	Installed part for the detail
detail_key2site_part	OTOP	site_part	part_key2part_detail	Installed part for the detail; used for indexing

Index Name	Fields	Additional Information
objindex	objid	clustered, unique located on PRIMARY
part_detail_ind	detail_key2site_part	nonclustered, 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