GoldMine Table Structures.
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 | ||
NOTACCNO | ACCOUNTNO | ||
NOTLOPR | LOPRECID | ||
NOTRECID | RECID | ||
NTXNOTUSERCREATE | USERID+CREATEDDATE |
Table Relationships | |||
Field | Related Table to Field | Type | Notes |
ACCOUNTNO | CONTACT1->ACCOUNTNO | M-1 | |
LOPRECID | OPMGR->RECID | 1-M | |
LOPRECID | CASES->RECID | 1-M |
Table Fields Structure | |||||||||||||||||||||
Field Name | Field Type | Length | Description | ||||||||||||||||||
CREATEDDATE | datetime | Date Note was created | |||||||||||||||||||
USERID | String | 8 | Created by User ID | ||||||||||||||||||
MODIFIEDDATE | datetime | Date the note was modified | |||||||||||||||||||
MODIFIEDBY | String | 8 | Modified by UserID | ||||||||||||||||||
LOPRECID | String | 15 | Linked Record ID - of contact1/case/opmgr record | ||||||||||||||||||
ACCOUNTNO | String | 20 | Account No - See Contact1 | ||||||||||||||||||
NOTE | Image | image field containing the binary converted note text | |||||||||||||||||||
RECTYPE | String | 8 |
|
||||||||||||||||||
EXT | String | 5 | Note type - defaul will be "html" | ||||||||||||||||||
RECID | String | 15 | Record ID |