Google
 
Return Home  
GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API wrapper and GoldFORM the GoldMine webimport form builder

   The home of Enigma NETUpdate automatic web update, GoldFORM and GMGoldLINK a GoldMine API wrapper

Hot Links

» Home Page
» Forum Pages
» Email Me

Site Menu
»GoldMine«
     »GoldFORM
     »GMCrystalView
     »GoldMine API
     »GoldMine Tables
     »GoldMine INI
     »Downloads
     »Free Tools

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads
Old Projects
»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links
»IRCDominatorXT«

»Work In Progress«
Links

» Downloads

Home

MAILBOX

DBase Directory Location: GMBASE
Table Description: Lookup file – contains a record for each defined look-up entry

Table Indexes
Name DBase Index SQL Index ID
MBOXLINK LINKRECID LINKRECID 77
MBOXUSER USERID+FOLDER+FOLDER2+DTOS(MAILDATE) USERID+FOLDER+FOLDER2+MAILDATE 78
MBOXACCT ACCOUNTNO ACCOUNTNO 79
MBXRECID RECID RECID 80

Table Relationships
Field Related Table to Field Type Notes
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.

Table Fields Structure
Field Name Field Type Length Description
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


Welcome

Enter a long URL and get it shortened using MyURL.online

Information

Your IP Address is: 54.242.94.204

Experts Exchange
#1
#2
#3
Questions Answered
Overall Points
Exchange Links
Do you want to
exchange links?
Click on my banner
for more information.

EnigmaWare Products - Home of IRCDominatorXT
Messages


Friends may come and go, but enemies accumulate.

 

Other great places to visit
   
Silver Sphere Designs
VPOP3 Mail Server Software  
 
Site Meter  
News

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc