|  |
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.
| NOTACCNO |
ACCOUNTNO |
|
|
| NOTLOPR |
LOPRECID |
|
|
| NOTRECID |
RECID |
|
|
| NTXNOTUSERCREATE |
USERID+CREATEDDATE |
|
|
| ACCOUNTNO |
CONTACT1->ACCOUNTNO |
M-1 |
|
| LOPRECID |
OPMGR->RECID |
1-M |
|
| LOPRECID |
CASES->RECID |
1-M |
|
| 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 |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
Door of a plastic surgeons office: "Hello, can we pick your nose?"
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
