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    
CASEACC ACCOUNTNO    
CASENUM NUMBER    
CASEOWNER OWNER    
CASERECID RECID    

Table Relationships
Field Related Table to Field Type Notes
ACCOUNTNO CONTACT1->ACCOUNTNO M-1  

Table Fields Structure
Field Name Field Type Length Description
ACCOUNTNO String 20 Account No - See Contact1
OWNER String 8 Case Owner
NUMBER String 40 Case Number - Generated
IS_TEMPLATE Number 2 0 - Normal Case, 1- Template record
IS_READ Number 2  
STATUS Number 2  
PRIORITY String 40 Priority (User Input)
SOURCE String 40 Source (User Input)
CATEGORY String 40 Category (User Input)
FTYPE String 40 Case Type (User Input)
OFFERING String 200 Offering (User Input)
SUBJECT String 200 Subject of Case (User Input)
DESCRIPTION Memo - Description (User Input)
NOTES Memo - Case Notes (Since 8.5 no longer used See Notes Table)
RESOLUTION_TYPE String 40 Resolution Type (User Input at case close)
RESOLUTION_NOTE Memo - Resolution Note (User Input at Case close)
DUE_DATE datetime   Deadline
RESOLVED_BY String 8 Resolved by UserID
RESOLVED_DATE datetime   Resolved date/time
CREATED_BY String 8 Create by UserID
CREATED_DATE datetime   Create date/time
MODIFIED_BY String 8 Modified by UserID
MODIFIED_DATE datetime   Modified date/time
RECID String 15 Record ID