TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

OPMGRFLD

DBase Directory Location: GMBASE
Table Description: Contains additional information for Opportunity/Project templates.

Table Indexes
Name DBase Index SQL Index ID
OPFLD LOPID+RECTYPE+UPPER(FNAME) LOPID+RECTYPE+U_FNAME -
OFRECID RECID RECID -

Table Relationships
Field Related Table to Field Type Notes
LopID OpMgr->OpID M-1  

Table Fields Structure
Field Name Field Type Length Description
LOPID String 15 Link to RecID of OpMgr Header
RECTYPE String 1 Record Type
FNAME String 40 Item Name
FVALUE String 80 Item Value
NOTES Memo - General notes
LINKEDDOC Memo - Several parameters, each separated by two tildes (~~) before and a line feed (ASCII 10) after.
Parameters include: SYNC={0/1 – No/Yes},
CREATETIME=YYYYMMDDHHMM, FILENAME={Full path of directory and file name}.
U_FNAME String 40 Upper-case shadow of FName field (SQL Only)
RECID String 15 Record ID

Your IP Address is: 54.167.44.32