GoldMine Table Definitions

GoldMine web import forms and GoldMine API programming, Automatic Web Update software

NETUpdate Suite -
GMGoldLINK™ a new GoldMine API

The home of IRCDominatorXT, NETUpdate automatic web update and GMGoldLINK the new GoldMine API

» Home Page
» My Forum
» Email Me
» My Shop

»Affiliate Market«
»Featured Product

»GoldMine«
     »GoldFORM
     »GoldMine API
     »GoldMine Tables
     »Services
     »Downloads

»NETUpdate Suite«
     »Client
     »Admin Part1
     »Admin Part2
     »ActiveX
     »Features
     »News
     »Downloads

»Visual Basic Stuff«
     »CodeSmartX
     »PikLink
     »Links

»Fun Stuff«

Old Projects

»IRCDominatorXT«
     »Latest
     »Known Bugs
     »Using Passport
     »Trouble Shoot
     »Downloads

»Legend Of Mir2«
     »Server Config
     »Converter
     »Browser
     »Other

»Work In Progress«

» Downloads

REPORT32

DBase Directory Location: GMBASE
Table Description: Contains listing of all available reports and their settings.

Table Indexes
Name	DBase Index	SQL Index	ID
REPORT32	RECTYPE+USERID+REPDESC	RECTYPE+USERID+REPDESC	-
REPRECID	RECID	RECID	-

Table Relationships

None

Table Fields Structure

RECTYPE

String

Record Type.
Position 1=Report type, C=Crystal, G=GoldMine
Position 2=Report category, C=Contact, F=Calendar, H=Analysis, I=Labels, X=Other

USERID

String

Owner of the report. Blank=’Public’

REPDESC

String

Description of the report

LINKEDDOC

Memo

Several parameters, each separated by two tildes (~~) before and a line feed (ASCII 10) after.
Parameters include: SYNC={0/1 – No/Yes},
CREATETIME=YYYYMMDDHHMM, FILENAME={Full path of directory and file name}.

OPT1

String

Flags for the various Options available to this report. See Table Below.

OPT2

String

Calendar Activity Code + History Activity Code + History Result Code

OPT3

String

All Reports with Options: Calendar Data

Position	Description
1-7	Start Date. ‘DS’ followed by number of days from current
8-14	End Date. ‘DS’ followed by number of days from current
15-22	User (if blank, All users)

OPT4

String

Contact, Analysis and Label Reports: History Data

Position	Description
1-7	Start Date. ‘DS’ followed by number of days from current
8-14	End Date. ‘DS’ followed by number of days from current
15-22	User (if blank, All users)

OPT5

String

OPT6

String

SDBF1

String

Primary Sort table name

SDBF2

String

Secondary Sort table name

SDBF3

String

Tertiary Sort table name

SFIELD1

String

Primary Sort field name

SFIELD2

String

Secondary Sort field name

SFIELD3

String

Tertiary Sort field name

STYPE1

String

GoldMine: Primary Sort field type (Character, Date, Number)
Crystal: Primary Sort order (0=Ascending, 1=Descending)

STYPE2

String

GoldMine: Secondary Sort field type (Character, Date, Number)
Crystal: Secondary Sort order (0=Ascending, 1=Descending)

STYPE3

String

GoldMine: Tertiary Sort field type (Character, Date, Number)
Crystal: Tertiary Sort order (0=Ascending, 1=Descending)

SSTART1

String

Primary Sort starting value

SSTART2

String

Secondary Sort starting value

SSTART3

String

Tertiary Sort starting value

SEND1

String

Primary Sort ending value

SEND2

String

Secondary Sort ending value

SEND3

String

Tertiary Sort ending value

GRPSDBF1

String

Group 1 table (appears to be unused)

GRPSFIELD1

String

Group 1 field name (appears to be unused)

GRPSDBF2

String

Group 2 table (appears to be unused)

GRPSFIELD2

String

Group 2 field name (appears to be unused)

GRPSDBF3

String

Group 3 table (appears to be unused)

GRPSFIELD3

String

Group 3 field name (appears to be unused)

PARAMS

Memo

NOTES

Memo

Report notes

CURREC

String

LASTUSER

String

Last Modified By

LASTDATE

Date

Last Modified Date

LASTTIME

String

Last Modified Time

RECID

String

Record ID

OPT1 Individual Character position definitions (Most are 0 or 1 where 0=No, 1=Yes)
Character	Contact, Analysis, Label Reports	Calendar Reports	Crystal Reports
1	{Blank Space}	Page Layout: 0=Daily Fixed, 1=Weekly, 2=Monthly, 3=Daily Variable
2	0
3	Default Printer (0=Selected, 1=Layout)	Default Printer (0=Selected, 1=Layout)	Default Printer (0=Selected, 1=Layout)
4	Contacts: 0=All, 1=Current, 2=Filter
5	{Blank Space}		{Unused}
6	{Blank Space}		{Unused}
7	Calendar Appointments	Include Appointments	{Unused}
8	Calendar Call Backs	Include Call Backs	{Unused}
9	Calendar Messages	Include Messages	{Unused}
10	Calendar Next Actions	Include Next Actions	{Unused}
11	Calendar Forecast Sales	Include Forecast Sales	{Unused}
12	Calendar Others	Include Others	{Unused}
13	Calendar Events	Include Events	{Unused}
14	Calendar To-Dos	{Blank Space}	{Unused}
15	{Blank Space}	{Blank Space}	{Unused}
16	History Phone Calls	Detail Text - Activity Type	{Unused}
17	History Messages	Detail Text - Activity Code	{Unused}
18	History Next Actions	Detail Text - Time	{Unused}
19	History Appointments	Detail Text - Duration	{Unused}
20	History Sales	Detail Text - Reference	{Unused}
21	History Others	Detail Text - Contact	{Unused}
22	History Forms	Detail Text - Phone	{Unused}
23	History Events	{Unused}	{Unused}
24	History To-Dos	{Unused}	{Unused}
25	{Blank Space}	{Unused}	{Unused}
26	Linked Data - Other Contacts	{Unused}	{Unused}
27	Linked Data - Details	{Unused}	{Unused}
28	Linked Data - Documents	{Unused}	{Unused}
29	Linked Data - Referrals	{Unused}	{Unused}
30	Linked Data - Organizations	{Unused}	{Unused}

Your IP Address is: 216.73.216.59

Questions Answered

Articles Written

Overall Points

Do you want to
exchange links?
Click on my banner
for more information.

The strong take from the week, the rich take from the poor, and the government takes from everyone.

Darren Lawrence aka MrEnigma/AbsoluteGenius