TruSoft Consulting

CASES

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