RECTYPE |
String |
2 |
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 |
8 |
Owner of the report. Blank=’Public’ |
REPDESC |
String |
60 |
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 |
30 |
Flags for the various Options available to this report. See Table Below. |
OPT2 |
String |
30 |
Calendar Activity Code + History Activity Code + History Result Code |
OPT3 |
String |
30 |
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 |
30 |
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 |
30 |
- |
OPT6 |
String |
30 |
- |
SDBF1 |
String |
8 |
Primary Sort table name |
SDBF2 |
String |
8 |
Secondary Sort table name |
SDBF3 |
String |
8 |
Tertiary Sort table name |
SFIELD1 |
String |
10 |
Primary Sort field name |
SFIELD2 |
String |
10 |
Secondary Sort field name |
SFIELD3 |
String |
10 |
Tertiary Sort field name |
STYPE1 |
String |
1 |
GoldMine: Primary Sort field type (Character, Date, Number)
Crystal: Primary Sort order (0=Ascending, 1=Descending) |
STYPE2 |
String |
1 |
GoldMine: Secondary Sort field type (Character, Date, Number)
Crystal: Secondary Sort order (0=Ascending, 1=Descending) |
STYPE3 |
String |
1 |
GoldMine: Tertiary Sort field type (Character, Date, Number)
Crystal: Tertiary Sort order (0=Ascending, 1=Descending) |
SSTART1 |
String |
20 |
Primary Sort starting value |
SSTART2 |
String |
20 |
Secondary Sort starting value |
SSTART3 |
String |
20 |
Tertiary Sort starting value |
SEND1 |
String |
20 |
Primary Sort ending value |
SEND2 |
String |
20 |
Secondary Sort ending value |
SEND3 |
String |
20 |
Tertiary Sort ending value |
GRPSDBF1 |
String |
8 |
Group 1 table (appears to be unused) |
GRPSFIELD1 |
String |
10 |
Group 1 field name (appears to be unused) |
GRPSDBF2 |
String |
8 |
Group 2 table (appears to be unused) |
GRPSFIELD2 |
String |
10 |
Group 2 field name (appears to be unused) |
GRPSDBF3 |
String |
8 |
Group 3 table (appears to be unused) |
GRPSFIELD3 |
String |
10 |
Group 3 field name (appears to be unused) |
PARAMS |
Memo |
- |
- |
NOTES |
Memo |
- |
Report notes |
CURREC |
String |
1 |
- |
LASTUSER |
String |
8 |
Last Modified By |
LASTDATE |
Date |
8 |
Last Modified Date |
LASTTIME |
String |
5 |
Last Modified Time |
RECID |
String |
15 |
Record ID |
OPT1 Individual Character position definitions (Most are 0 or 1 where 0=No, 1=Yes) |
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} |