| |
NOTES
CONTACT SET
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.
CASEACC |
ACCOUNTNO |
|
|
CASENUM |
NUMBER |
|
|
CASEOWNER |
OWNER |
|
|
CASERECID |
RECID |
|
|
ACCOUNTNO |
CONTACT1->ACCOUNTNO |
M-1 |
|
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 |
|
|
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
If it wasn't for C, we would be using BASI, PASAL, LIPPER and OBOL!
|
|
|
|
|