ACCOUNTNO |
String |
20 |
Account Number |
RECTYPE |
String |
1 |
Record Type
|
CONTACT |
String |
40 |
Contact Name |
TITLE |
String |
35 |
Contact Title |
CONTSUPREF |
String |
35 |
Reference |
DEAR |
String |
20 |
Dear (Salutation) |
PHONE |
String |
20 |
Phone |
EXT |
String |
6 |
Phone Extension |
FAX |
String |
20 |
Fax number |
LINKACCT |
String |
20 |
Linked Account |
NOTES |
Memo |
- |
Notes |
ADDRESS1 |
String |
40 |
Additional Contact Address 1 |
ADDRESS2 |
String |
40 |
Additional Contact Address 2 |
ADDRESS3 |
String |
40 |
Additional Contact Address 3 |
CITY |
String |
30 |
Additional Contact City |
STATE |
String |
20 |
Additional Contact State |
ZIP |
String |
10 |
Additional Contact Zip (Post Code) |
COUNTRY |
String |
20 |
Additional Contact Country |
MERGECODES |
String |
20 |
Merge Codes |
STATUS |
String |
4 |
First character is flag, second char =1 if notes exist |
LINKEDDOC |
Memo |
- |
Linked Document |
LASTUSER |
String |
8 |
Last Modified By |
LASTEDATE |
Date |
8 |
Last Modified Date |
LASTTIME |
String |
5 |
Last Modified Time |
U_CONTACT |
String |
40 |
Upper-case shadow of Contact Name |
U_CONTSUPREF |
String |
35 |
Upper-case shadow of Reference |
U_ADDRESS1 |
String |
40 |
Upper-case shadow of Address1 |
RECID |
String |
15 |
Record ID |