HNO_PLAIN_TEXT

Description:

This table extracts notes that are stored only in plain text. This table does not contain any notes that are stored in rich text. HNO_NOTE_TEXT should still be used for reporting purposes.

Primary Key

Column Name	Ordinal Position
NOTE_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	NOTE_CSN_ID	NUMERIC	No
	The contact serial number (CSN) of the contact.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	NOTE_ID	VARCHAR	No
	The unique identifier (.1 item) for the note record.
4	NOTE_TEXT	VARCHAR	No
	Content of the plain text note.