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    
CASEACC ACCOUNTNO    
CASENUM NUMBER    
CASEOWNER OWNER    
CASERECID RECID    

Table Relationships
Field Related Table to Field Type Notes
ACCOUNTNO CONTACT1->ACCOUNTNO M-1  

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

 

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


The Borg assimilated my cat...He doesn't act any differently.

 

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

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc