| |
CONTHIST
COMMON
Contact history file—contains a record for each completed activity
CONTHIST |
ACCOUNTNO+DTOS(ONDATE)+RECID |
ACCOUNTNO+ONDATE+RECID |
33 |
CONTHUSR |
USERID+SRECTYPE+DTOS(ONDATE)+RECID |
USERID+SRECTYPE+ONDATE+RECID |
34 |
CNHRLINK |
LOPRECID+DTOS(ONDATE) |
LOPRECID+ONDATE |
35 |
CNHRECID |
RECID |
RECID |
36 |
AccountNo |
Contact1->AccountNo |
M-1 |
|
LopRecID |
OpMgr->RecID |
M-1 |
Records related to opportunities/projects |
RecID |
MailBox->LinkRecID |
1-1 |
|
LinkRecID |
MailBox->RecID |
1-1 |
|
USERID |
String |
8 |
User |
ACCOUNTNO |
String |
20 |
Account Number. If '--' and the record is an Email then the email was linked but then subsequently unlinked |
SRECTYPE |
String |
1 |
First character of RecType |
RECTYPE |
String |
10 |
Record Type. Contains up to 5 characters. The following are definitions for each segment of this field. See Table Below |
ONDATE |
Date |
8 |
Action Date |
ONTIME |
String |
5 |
Action Time |
ACTVCODE |
String |
3 |
Activity Code |
RESULTCODE |
String |
3 |
Result Code |
STATUS |
String |
2 |
First character is flag, second char =1 if notes exist |
DURATION |
String |
8 |
Duration of activity. Formatted as hh:mm:ss. If none, either blank or ‘0’. Also used for forecasted sale value. |
UNITS |
String |
8 |
Units of a Forecasted Sale |
REF |
String |
65 |
Reference. Contact name is stored at end in parenthesis, preceeded by ‘oc:’.
Example: ‘This is the reference (oc: Bob Smith)’. |
NOTES |
Image |
- |
Notes |
LINKRECID |
String |
15 |
E-Mail Linked Record ID |
LOPRECID |
String |
8 |
Linked Opportunity. Manager. Record |
CREATEBY |
String |
8 |
Creation 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 |
6 |
Last Modified Time |
RECID |
String |
15 |
Record ID |
Characters 1-2 (Record Type) |
Character 4 (Private, RSVP Flags) |
A |
Appointment |
(Space) |
Non-Private, Non-RSVP |
C |
Phone call |
P |
Private |
CC |
Call Back |
R |
RSVP |
CI |
Incomming Call |
B |
Private and RSVP |
CM |
Returned Message |
Character 5 (Colour of Original Activity) |
CO |
Outgoing Call |
D |
To-Do |
(Space) |
Blue (Default) |
E |
Event |
! |
Magenta |
F |
Literature |
" |
Red |
L |
Form |
# |
Cyan |
M |
Sent Message |
$ |
Green |
MG |
E-Mail Message |
% |
Yellow |
MI |
Received E-mail |
& |
Dark Cyan |
MO |
Sent E-Mail |
‘ (Apostrophe) |
White |
O |
Other |
( |
Light Grey |
S |
Sale |
) |
Maroon |
T |
Next Action |
* |
Dark Green |
U |
Unknown |
+ |
Dark Yellow |
Character 3 (Result of the Activity) |
, |
Dark Blue |
- |
Purple |
(Space) |
Successful |
. |
Dark Grey |
U |
Unsuccessful |
/ |
Black |
|
|
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
DEFINITION FOR THE DAY:
FILING CABINET: A place to lose things alphabetically.
|
|
|
|
|