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

OPMGR

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
OPMGR UPPER(RECTYPE+USERID+STAGE) RECTYPE+USERID+U_STAGE 95
OPID OPID+RECTYPE OPID+RECTYPE 96
OPACCNO ACCOUNTNO+RECTYPE+OPID ACCOUNTNO+RECTYPE+OPID 97
OPRECID RECID RECID 98

Table Relationships
Field Related Table to Field Type Notes
OpID OpMgrFld->LopID 1-M Link to sub-table containing additional details
AccountNo Contact1->AccountNo M-1  
RecID ContHist->LopRecID 1-M History activities related to opportunities / projects
RecID MailBox->LopRecID 1-M E-mails related to opportunities / projects
RecID Cal->LopRecID 1-M Pending activities related to opportunities / projects

Table Fields Structure
Field Name Field Type Length Description
OPID String 15 Opportunity ID
RECTYPE String 3 Record Type
Position 1 Description
O Opportunities
P Projects
Position 2 Description
C Contact
P Competitor
T Team member
I Issue
F Field
K Task
X Template
ACCOUNTNO String 20 Account Number of linked contact.
USERID String 8 User Name
FLAGS String 10 Flags
COMPANY String 40 Company
CONTACT String 40 Contact
NAME String 50 Name
STATUS String 50 Status
CYCLE String 50 Cycle
STAGE String 30 Stage
SOURCE String 30 Source
F1 String 20 -
F2 String 20 -
F3 String 10 -
STARTDATE Date 8 Start Date
CLOSEDDATE Date 8 Close Date
CLOSEBY Date 8 Close by
FORAMT Float 10 For Amount
FORPROB Integer 4 Probability
CLOSEAMT Float 10 Close Amount
NOTES Memo - Notes - Since 8.5 no longer used see Notes Table
PRODUCTNAME String 50 Introduced in 8.5
U_STAGE String 30 Upper-case shadow of Stage (SQL Only)
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


We shall never understand one another until we reduce the language to seven words.

- Kahlil Gabran

 

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

     
  This site is copyright © 2005-2008 EnigmaWare Software Inc