CONTGRPS

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 SQL Index  
GROUPNO USERID+U_CODE+RECID  
GROUPACC ACCOUNTNO+USERID  
GRPRECID RECID  

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
RECID String 15 Record ID