TruSoft Consulting

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