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

NOTES

Directory Location: CONTACT SET
Table Description: 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.

Table Indexes
Name Index    
NOTACCNO ACCOUNTNO    
NOTLOPR LOPRECID    
NOTRECID RECID    
NTXNOTUSERCREATE USERID+CREATEDDATE    

Table Relationships
Field Related Table to Field Type Notes
ACCOUNTNO CONTACT1->ACCOUNTNO M-1  
LOPRECID OPMGR->RECID 1-M  
LOPRECID CASES->RECID 1-M  

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

 

Welcome

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

Information

Your IP Address is: 54.80.123.20

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


Apathy is becoming a major problem, but who cares?

 

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

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc