TruSoft Consulting

NOTES

Directory Location: CONTACT SET
Table Description: Notes Table—contains the notes of contact record. Each complete contact record has a record in this file. User-defined field data is stored in this file.

Table Indexes
Name	Index
NOTACCNO	ACCOUNTNO
NOTLOPR	LOPRECID
NOTRECID	RECID
NTXNOTUSERCREATE	USERID+CREATEDDATE

Table Relationships
Field	Related Table to Field	Type	Notes
ACCOUNTNO	CONTACT1->ACCOUNTNO	M-1
LOPRECID	OPMGR->RECID	1-M
LOPRECID	CASES->RECID	1-M

Table Fields Structure
Field Name	Field Type	Length	Description
CREATEDDATE	datetime		Date Note was created
USERID	String	8	Created by User ID
MODIFIEDDATE	datetime		Date the note was modified
MODIFIEDBY	String	8	Modified by UserID
LOPRECID	String	15	Linked Record ID - of contact1/case/opmgr record
ACCOUNTNO	String	20	Account No - See Contact1
NOTE	Image		image field containing the binary converted note text
RECTYPE	String	8	Value Description C1 Contact Note OP Opportunity Note PR Project Note CS Cases (Service) Note CR Case Resolution Notes
EXT	String	5	Note type - defaul will be "html"
RECID	String	15	Record ID