TruGOLDCRM Consulting

Finding Gold with your CRM

Google


GoldMine Table Structures.

CONTGRPS

DBase Directory Location: COMMON
Table Description: Groups file—the CONTGRPS file is used for both the group header, which defines each group (see CONTGRPS Structure header records below), and members for each group (see CONTGRPS Structure member records below).

Table Indexes
Name DBase Index SQL Index ID
GROUPNO UPPER(USERID+CODE) USERID+U_CODE+RECID 37
GROUPACC ACCOUNTNO+USERID ACCOUNTNO+USERID 38
GRPRECID RECID RECID 39

Table Relationships
Field Related Table to Field Type Notes
AccountNo Contact1->AccountNo M-1 Member records only *

Table Fields Structure (Header Records)
Field Name Field Type Length Description
USERID String 15 Group user
CODE String 8 Group code
ACCOUNTNO String 20 Header info *
Position Description
1-8 “*M” + group number
15-20 Total members in group
REF String 24 Group reference
U_CODE String 8 Upper-case shadow of Group code (SQL Only)
RECID String 15 Record ID

Table Fields Structure (Members Records)
Field Name Field Type Length Description
USERID String 15 Group number (from group header)
CODE String 8 Member sort value
ACCOUNTNO String 20 Linked contact accountno
REF String 24 Member reference.
U_CODE String 8 Upper-case shadow of Member sort value (SQL Only)
RECID String 15 Record ID

 


Your IP Address is: 54.158.253.134