Table Name:	mail_list
Table Number:	5019
Group:	Sales Mgr
Description:	Describes a mailing list. Reserved; not used
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_mail_list

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 mail list
description	CHAR	varchar		255			Description of the mailing list
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
name	CHAR	varchar	2	50			Name of the list
objid	LONG	int	3			DIRECT	Internal record number
start_date	CLK_TIME	datetime					Date the list became active

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
list2lst_con_role	OTM	lst_con_role	con_role2mail_list	Contact roles for the mailing list. Reserved; not used
list2lst_per_role	OTM	lst_per_role	per_role2mail_list	Person roles for the mailing list. Reserved; not used

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

mail_list

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user