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