TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

SPFILES

DBase Directory Location: GMBASE
Table Description: Contact files directory—contains a record for each set of GoldMine’s contact sets

Table Indexes
Name DBase Index SQL Index ID
SPFILES UPPER(DIRPATH) U_DIRPATH 43
SFLCODE DIRCODE DIRCODE 44
SFLRECID RECID RECID 45

Table Relationships
Field Related Table to Field Type Notes
None      

Table Fields Structure
Field Name Field Type Length Description
DIRNAME String 35 Contact file desc
DIRPATH String 100 Contact file path
USERID String 8 Contact file user
DIRCODE String 10 Contact Set Code
DBPASSWORD String 36 Database Password
DRIVER String 25 Database Driver
U_DIRPATH String 100 Upper-case shadow of Contact file path (SQL Only)
RECID String 15 Record ID

Your IP Address is: 54.167.44.32