Table Name:	map_field
Table Number:	67
Group:	Invoice Interface
Description:	Expresses a field to field mapping from the source object to the destination object (trans_record). The mapping guides data transfer from souce to destination. Reserved; custom
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_map_field

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
comments	CHAR	varchar		255			Comments about the mapping
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
focus_fldname	CHAR	varchar		32			Field name (on the focus_type) that trans_fldname maps from
focus_trans_id	CHAR	varchar		20			Used for summary transactions. Identifies the detail (or summary) transaction ID being summarized. Note: for summary transactions focus type is always 68=trans_record
objid	LONG	int	3			DIRECT	Internal record number
trans_fldname	CHAR	varchar		32			Field name (on trans_record) that trans_fldname maps to
unit_type	CHAR	varchar		30			If the mapped field is a quantity, documents the unit the quantity is expressed in; e.g., currency, units, hours, etc

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
map_field2map_path	MTO	map_path	map_path2map_field	Map path to which the field mapping belongs. The object type having the focus_field_name is on the to_focus_type

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags
field_index	map_field2map_path:trans_fldname	UNIQUE

Indexes (Defined in Database):

Index Name	Fields	Additional Information
field_index	map_field2map_path, trans_fldname	nonclustered, unique located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

map_field

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user