TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTSUPP - Linked Documents

RecType in Table: L
GoldMine Location: Links Tab

Contains the information needed to open a linked document as well as the synchronization settings.

Definitions/Descriptions:
GoldMine Field: Field name when viewed in GoldMine. If blank, not visible in GoldMine.
User/System: Defines whether the User or the System sets and maintains this value.
Used For: The type of data stored in this field. If a value in single quotes (' '), this is the actual value stored in this field.

Fields In Use in GoldMine
Field Name GoldMine Field Type Field Used For
ACCOUNTNO   System AccountNo of Linked Company
RECTYPE   System L
CONTACT   System Username, Document extension and Date Created
TITLE Type System Description of document type
CONTSUPREF Document User Description of document
DEAR Date System Date, Time document linked. Format: YYYYMMDDHH:MM:SS
PHONE      
EXT      
FAX      
LINKACCT   System RecID of E-Mail record for e-mailed attachments.
NOTES   User Linked Doc Notes
ADDRESS1   User Document directory and name
ADDRESS2   User Continuation of document directory and name.
ADDRESS3      
CITY      
STATE      
ZIP      
COUNTRY      
MERGECODES      
STATUS   System Position 1=’0’ if no notes, ‘1’ if notes, ‘A’ if the linked document is from an e-mail. The second position is sometimes used, it is typically ‘0’, but it’s use is unknown.
LINKEDDOC   User/System Up to three parameters defining:
SYNC 0=No, 1=Yes
CREATETIME Format YYYYMMDDHHMM
FILENAME Full file name of the document.
LASTUSER      
LASTEDATE      
LASTTIME      
RECID   System Record ID

Your IP Address is: 54.167.44.32