Table Name:	qq_comment
Table Number:	5079
Group:	Sales Mgr
Description:	Comments which may appear on a quote/contract
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_qq_comment

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
active	LONG	int				DIRECT	Determines whether the comment will appear on the quote i.e., 0=will appear on quote, 1=won't appear on quote
comments	CHAR	varchar		255			Text of the comment
create_date	CLK_TIME	datetime					The create date of the comment
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
objid	LONG	int	3			DIRECT	Internal record number
sequence_num	LONG	int				DIRECT	Sequences the comment for a quick quote

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views
comment2contract	MTO	contract	contract2qq_comment	Related contract
comment2quick_quote	MTO	quick_quote	q_quote2qq_comment	Related quick quote

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables

My Recent Objects

qq_comment

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user