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

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

   The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

Hot Links

» Home Page
» My Forum
» Email Me
» My Shop

Site Menu

»Affiliate Market«
     »Featured Product


»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

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

»Fun Stuff«

Old Projects
»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads
»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«
Links

� Downloads

 

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
Information

Your IP Address is: 172.70.135.72

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


If it wasn't for C, we would be using BASI, PASAL, LIPPER and OBOL!

 

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

     
  This site is copyright © 2005 EnigmaWare Software Inc - Darren Lawrence aka MrEnigma/AbsoluteGenius