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 |
LinkedIn