|  |
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.
|
|
|
Love is foolish ... but I still might try it sometime.
~ Floyd 'Age 9'
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
