Table Name:	tbl_def
Table Number:	9765
Group:	Process Manager
Description:	Defines FML field tables used by Process Manager
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_tbl_def

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
base	LONG	int				DIRECT	The *base value for the file, on export
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
internal	LONG	int				DIRECT	Set to 1 if the fields are for internal use, and not available in service requests
modify_flag	LONG	int				DIRECT	Set to 1 if the table has been modified but not exported
name	CHAR	varchar		64			Name of the table file. Note that only simple names should be used (paths defined by FLDTBLDIRS32)	Search (1)
objid	LONG	int	3			DIRECT	Internal record number	Search (1)
process_date	CLK_TIME	datetime					Date/time of last operation (import or export)
type	CHAR	varchar		20			Indicates the type of file, either Export or Import

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
tbl_def2fld_def	OTM	fld_def	fld_def2tbl_def	Fields defined by the file

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
I9765	name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
I9765	name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY
t9765	type	nonclustered located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
9879	fld_tbl_view	fld_def, tbl_def

My Recent Objects

tbl_def

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user