|  |
CAL
GMBASE
Calendar file— contains a record for each scheduled activity. The different record types
are distinguished by the contents of the RECTYPE field. Different RECTYPEs may use
each field for a different purpose.
| CAL |
RECTYPE+USERID+DTOS(ONDATE)+ONTIME |
RECTYPE+USERID+ONDATE+ONTIME+RECID |
02 |
| CALCONT |
ACCOUNTNO+RECTYPE+DTOS(ONDATE)+ONTIME |
ACCOUNTNO+RECTYPE+ONDATE+ONTIME+RECID |
03 |
| CALDATE |
USERID+DTOS(ONDATE)+ONTIME |
USERDATE+ONDATE+ONTIME+RECID |
04 |
| CALPROB |
RECTYPE+USERID+STR(999-DURATION,3) |
RECTYPE+USERID |
05 |
| CALALARM |
ALARMFLAG+USERID+DTOS(ALARMDATE)+ALARMTIME |
ALARMFLAG+USERID+ALARMDATE+ALARMTIME |
06 |
| CALRLINK |
LOPRECID+RECTYPE+DTOS(ONDATE)+ONTIME |
LOPRECID+RECTYPE+ONDATE+ONTIME |
07 |
| CNURECID |
RECID |
RECID |
08 |
| AccountNo |
Contact1->AccountNo |
M-1 |
Only for activities linked to a contact record |
| RecID |
MailBox->LinkRecID |
1-1 |
|
| LinkRecID |
MailBox->RecID |
1-1 |
|
| LopRecID |
OpMgr->RecID |
M-1 |
Records related to opportunities/projects |
| USERID |
String |
8 |
User Name or resource |
| ACCOUNTNO |
String |
20 |
Account Number of linked contact. If blank, record is un-linked (typical
of to-dos). If formatted as ‘PB:’Username then pegboard information. If '--' and the record is an Email then the email was linked but then subsequently unlinked |
| ONDATE |
Date |
8 |
Activity Date |
| ONTIME |
String |
5 |
Activity Time |
| ENDDATE |
Date |
8 |
Ending date of scheduled activity |
| ALARMFLAG |
String |
1 |
Alarm Flag (Y/N) |
| ALARMTIME |
String |
5 |
Alarm Time |
| ALARMDATE |
Date |
8 |
Alarm Date |
| ACTVCODE |
String |
3 |
Activity Code |
| RSVP |
String |
1 |
RSVP Notification (Y/N) |
| DURATION |
Integer |
3 |
Duration (time in total minutes)/Forecasted sale probability |
| RECTYPE |
String |
1 |
Record Type. Possible values are listed below.
| Value |
Description |
| A |
Appointment |
| C |
Call Back |
| D |
To-do |
| E |
Event |
| M |
Message |
| O |
Other |
| Q |
Queued e-mail |
| S |
Sales potential |
| T |
Next action |
| {Blank} |
Peg Board record |
|
| ACONFIRM |
String |
3 |
Meeting Confirmation |
| APPTUSER |
String |
10 |
Meeting Confirmation User (Character 10 indicates color – options
listed below)
| Value |
Description |
| (Space) |
Blue (Default) |
| ! |
Magenta |
| " |
Red |
| # |
Cyan |
| $ |
Green |
| % |
Yellow |
| & |
Dark Cyan |
| ‘ (Apostrophe) |
White |
| ( |
Light Grey |
| ) |
Maroon |
| * |
Dark Green |
| + |
Dark Yellow |
| , |
Dark Blue |
| - |
Purple |
| . |
Dark Grey |
| / |
Black |
|
| STATUS |
String |
4 |
First character is flag, second char =1 if notes exist |
| DIRCODE |
String |
10 |
DirCode of the current contact file |
| NUMBER1 |
Integer |
8 |
Sales Potential. Also used to mark private records, if value is ‘16’. |
| NUMBER2 |
Integer |
8 |
Units of a Forecasted Sale |
| COMPANY |
String |
60 |
Company/Contact Name (also used for pegboard times) |
| REF |
String |
80 |
Reference |
| NOTES |
Image |
- |
Notes |
| LINKRECID |
String |
15 |
Linked Record ID |
| LDOCRECID |
String |
15 |
Reserved for future use |
| LOPRECID |
String |
15 |
Linked Opportunity Manager Record ID |
| CREATEBY |
String |
8 |
Created by User |
| CREATEON |
Date |
8 |
Creation Date |
| CREATEAT |
String |
6 |
Creation Time |
| LASTUSER |
String |
8 |
Last Modified By |
| LASTDATE |
Date |
8 |
Last Modified Date |
| LASTTIME |
String |
5 |
Last Modified Time |
| RECID |
String |
15 |
Record ID |
|
 |
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
Laddie's Law of Mathematical Science:
Variables won't; constants aren't.
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
