| 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} |