Table Name:	loc_inq
Table Number:	276
Group:	Logistics
Description:	Screen selection criteria of a Logistics query edit form. They enable a user to save a query as an icon
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_loc_inq

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
field1	CHAR	varchar		20			First selection criterion
field2	CHAR	varchar		20			Second selection criterion
field3	CHAR	varchar		20			Third selection criterion
field4	CHAR	varchar		20			Fourth selection criterion
field5	CHAR	varchar		20			Fifth selection criterion
field6	CHAR	varchar		20			Sixth selection criterion
field7	CHAR	varchar		20			Seventh selection criterion
field8	CHAR	varchar		20			Eighth selection criterion
field9	LONG	int				DIRECT	Ninth selection criterion
icon_id	LONG	int	16			DIRECT	ID of the icon assigned to the query
objid	LONG	int	3			DIRECT	Internal record number
title	CHAR	varchar	2	80			Name assigned to the query

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
loc_inq_owner2user	MTO	user	curr_owner2loc_inq	User/originator of the query. Reserved

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
loc_index	loc_inq_owner2user:title	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
loc_index	loc_inq_owner2user, title	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

loc_inq

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user