|  |
MAILBOX
GMBASE
Lookup file – contains a record for each defined look-up entry
| MBOXLINK |
LINKRECID |
LINKRECID |
77 |
| MBOXUSER |
USERID+FOLDER+FOLDER2+DTOS(MAILDATE) |
USERID+FOLDER+FOLDER2+MAILDATE |
78 |
| MBOXACCT |
ACCOUNTNO |
ACCOUNTNO |
79 |
| MBXRECID |
RECID |
RECID |
80 |
| RecID |
Cal->LinkRecID |
1-1 |
E-mails still in inbox or waiting to be sent |
| LinkRecID |
Cal->RecID |
1-1 |
E-mails still in inbox or waiting to be sent |
| LinkRecID |
ContHist->RecID |
1-1 |
Filed, sent or otherwise completed e-mails |
| LopRecID |
OpMgr->RecID |
M-1 |
Records related to opportunities/projects |
| AccountNo |
Contact1->AccountNo |
M-1 |
Linked e-mails, does not include folder records in Mailbox. |
| LINKRECID |
String |
15 |
Linked Record ID (from Cal or ContHist RecID) |
| FLAGS |
String |
8 |
The Flags field is a String type, but actually stores a number. When the
number is converted to binary, the following rules apply:
| Bit |
On |
Off |
| 1 |
Read |
Not Read |
| 2 |
In History |
Not In History |
| 3 |
OutBound |
InBound |
| 4 |
Attachment |
No Attachments |
| 5 |
Redirect |
|
| 6 |
As Links |
|
| 7 |
ICAL Marker |
|
| 8 |
Signed |
Not Signed |
| 9 |
Encrypted |
Not Encrypted |
|
| USERID |
String |
8 |
User Name |
| FOLDER |
String |
20 |
The Folder field contains the name of the folder in which mail is stored.
GoldMine uses the following predefined folders
X-GM-INBOX -Inbox
X-GM-OUTBOX -Outbox
X-GM-TEMPLATES -Templates
X-GM-GROUPS - Folder 2 is Distribution List Name
RFC822 holds the members (CACCOUNTNO or Eemailaddress
Each record is seperated by CHAR(1)
Records
CACCOUNTNO = Primary Email
EEmailAddres = Unlinked Email
SRECID = ContSupp Recid
GUSERNAME = GoldMine User
|
| FOLDER2 |
String |
20 |
Subfolder |
| ACCOUNTNO |
String |
20 |
Account Number of linked contact. If '--' and the record is an Email then the email was linked but then subsequently unlinked |
| CREATEON |
Date |
- |
Creation Date |
| MAILSIZE |
String |
8 |
Mail size in bytes |
| MAILDATE |
Date |
- |
Mail date/Date to be sent if in queue |
| MAILTIME |
String |
8 |
Mail time/Time to be sent if in queue |
| MAILREF |
String |
100 |
E-mail reference/subject line |
| LOPRECID |
String |
15 |
Linked Opportunity Manager Record ID |
| RFC822 |
Memo |
- |
Entire Mail Message |
| RECID |
String |
15 |
Record ID |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
Never underestimate the power of human stupidity.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
