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 |