| ACCOUNTNO |
String |
20 |
Unique Account Number. This field is automatically generated with the
following values in the specified positions.
| Position |
Description |
| 1-6 |
Date in YYMMDD format (Note 2000=A0, 2001=A1, 2010=B0) |
| 7-11 |
Seconds since midnight |
| 12-17 |
Randomly generated |
| 18-20 |
First three characters of the contact or company name |
|
| COMPANY |
String |
40 |
Company Name |
| CONTACT |
String |
40 |
Contact Name |
| LASTNAME |
String |
15 |
Contact’s Last Name |
| DEPARTMENT |
String |
35 |
Department |
| TITLE |
String |
35 |
Contact Title |
| SECR |
String |
20 |
Secretary |
| PHONE1 |
String |
25 |
Phone 1 |
| PHONE2 |
String |
25 |
Phone 2 |
| PHONE3 |
String |
25 |
Phone 3 |
| FAX |
String |
25 |
Fax |
| EXT1 |
String |
6 |
Phone Extension 1 |
| EXT2 |
String |
6 |
Phone Extension 2 |
| EXT3 |
String |
6 |
Fax Extension (used as EXT3 to maintain compatability with previous
versions) |
| EXT4 |
String |
6 |
Phone Extension 3 |
| ADDRESS1 |
String |
40 |
Address 1 |
| ADDRESS2 |
String |
40 |
Address 2 |
| ADDRESS3 |
String |
40 |
Address 3 |
| CITY |
String |
30 |
City |
| STATE |
String |
20 |
State |
| ZIP |
String |
10 |
Zip Code (Post Code) |
| COUNTRY |
String |
20 |
Country |
| DEAR |
String |
20 |
Salutation |
| SOURCE |
String |
20 |
Source (Lead) |
| KEY1 |
String |
20 |
Key 1 |
| KEY2 |
String |
20 |
Key 2 |
| KEY3 |
String |
20 |
Key 3 |
| KEY4 |
String |
20 |
Key 4 |
| KEY5 |
String |
20 |
Key 5 |
| STATUS |
String |
3 |
Internal Status. Composed of 3, 1-character flags.
| Position |
Description |
| 1 |
This is the format of the phone numbers for the contact. If the first character is U, the phone numbers are formatted for USA-style phone numbers: (999)999-9999. |
| 2 |
The curtain level. (0=none, 1=partial, 2=full) |
| 3 |
A record alert is present if the value is 1. |
|
| NOTES |
Memo |
- |
Notes - Since 8.5 no longer used see Notes Table |
| MERGECODES |
String |
20 |
Merge codes for primary contact |
| CREATEBY |
String |
8 |
Creation user |
| CREATEON |
Date |
8 |
Creation Date |
| CREATEAT |
String |
5 |
Creation Time |
| OWNER |
String |
8 |
Record Owner. If blank, owner is Public. |
| LASTUSER |
String |
8 |
Last modified By |
| LASTDATE |
Date |
8 |
Last modified Date |
| LASTTIME |
String |
6 |
Last modified Time |
| U_COMPANY |
String |
40 |
Upper-case shadow of Company Name |
| U_CONTACT |
String |
40 |
Upper-case shadow of Contact Name |
| U_LASTNAME |
String |
15 |
Upper-case shadow of Contact’s Last Name |
| U_CITY |
String |
26 |
Upper-case shadow of City |
| U_STATE |
String |
20 |
Upper-case shadow of State |
| U_COUNTRY |
String |
20 |
Upper-case shadow of Country |
| U_KEY1 |
String |
20 |
Upper-case shadow of Key 1 |
| U_KEY2 |
String |
20 |
Upper-case shadow of Key 2 |
| U_KEY3 |
String |
20 |
Upper-case shadow of Key 3 |
| U_KEY4 |
String |
20 |
Upper-case shadow of Key 4 |
| U_KEY5 |
String |
20 |
Upper-case shadow of Key 5 |
| RECID |
String |
15 |
Record ID |
This site is copyright © 2005 EnigmaWare Software Inc - 
