Table Name:	dataset
Table Number:	69
Group:	Invoice Interface
Description:	Groups all Invoice Interface objects for administration and control. Each dataset serves an external system interface. Reserved; custom
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_dataset

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
appl_id	CHAR	varchar		20			Clarify application using the dataset
dataset_name	CHAR	varchar		20			Local name for the dataset
description	CHAR	varchar		255			Description of the dataset
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
filter_by	CHAR	varchar		255			Defines the filter criteria that will be used to segregate the data in the dataset for different users
interface	CHAR	varchar		40			Local identifier of the external interface that will use the data
objid	LONG	int	3			DIRECT	Internal record number
strtobjno	LONG	int				DIRECT	Starting object type number

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
dataset2trans_map	OTM	trans_map	map2dataset	Source data mappings belonging to the dataset
dataset2user	MTM	user	user2dataset	Users of the dataset		mtm_user53_ dataset1

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
dataset_index	dataset_name	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
dataset_index	dataset_name	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

dataset

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user