|  |
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.
|
|
|
The statistics on sanity are that one out of every four Americans is suffering from some form of mental illness. Think of your three best friends. If they are okay, then it's you.
Jerry Seinfeld
|
|
|
|
|
This site is copyright © 2005 EnigmaWare Software Inc - 
