Table Name:	exch_txn
Table Number:	5203
Group:	Exchange Mgr
Description:	Sefines a set of exchange transactions. Initial definitions are of a Standard CSC set and an Enhanced Clarify set
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_exch_txn

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
description	CHAR	varchar		255			Describes the transaction in detail
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
name	CHAR	varchar		80			User defined name describing the transaction
objid	LONG	int	3			DIRECT	Internal record number
standard	CHAR	varchar		80			Name of the exchange standard which supports the named transaction
trans_code	LONG	smallint			0	DIRECT	Code number which identifies the transaction
transaction_id	CHAR	varchar		80			Exchange transaction name as defined by the standard supporting it
version	CHAR	varchar		10			Version of exchange standard

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
exch_txn2cat_txn_role	OTM	cat_txn_role	cat_txn_role2exch_txn	Associated transaction category roles

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
exch_txn_index	standard:transaction_id:version	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
exch_txn_index	standard, transaction_id, version	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

exch_txn

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user