 |
CONTSUPP - E-Mail Addresses
P
Details Tab, E-Mail Manager
All e-mail addresses are stored in this table. There are different variations of emails and below are the settings of the various fields that define them. The Contact field is always “E-Mail Address” and the ContSupRef field is always
the e-mail address.
Definitions/Descriptions:
GoldMine Field: Field name when viewed in GoldMine. If blank, not visible in GoldMine.
User/System: Defines whether the User or the System sets and maintains this value.
Used For: The type of data stored in this field. If a value in single quotes (' '), this is the actual value stored in this field.
| ACCOUNTNO |
|
System |
Link to Contact1 Record |
| RECTYPE |
|
System |
P |
| CONTACT |
Detail |
User |
‘E-Mail Address’ |
| TITLE |
|
|
|
| CONTSUPREF |
Reference |
User |
E-Mail Address |
| DEAR |
|
|
|
| PHONE |
|
System |
If Un-Attached E-Mail, the Lookup.LookupSupp value for E-Mail addresses |
| EXT |
|
|
|
| FAX |
|
|
|
| LINKACCT |
|
|
If E-Mail of secondary contact, then RecID of that contact record. |
| NOTES |
|
|
|
| ADDRESS1 |
|
User |
If E-Mail address is too long, this stores the remainder of the address. |
| ADDRESS2 |
|
User |
Contact name for addressing e-mail. Shown in <>
when viewing the E-Mail address in the Reference field. |
| ADDRESS3 |
|
|
|
| CITY |
|
User |
|
| STATE |
|
|
|
| ZIP |
|
User |
Binary Switch
Position 1 = TEXT (0) or HTML (1)
Position 2 = Primary address (1) or normal (0)
Position 3 = Wrap Lines(1) no wrap (0)
Position 4 = MIME(1) or not MIME(0) - if set to 0 then position 1 must also be 0
e.g.
1001 = MIME and HTML Email
1101 = MIME and HTML Email - Primary
|
| COUNTRY |
|
|
|
| MERGECODES |
|
|
|
| STATUS |
|
System |
Blank if attached Address, If Un-attached, ‘00’ |
| LINKEDDOC |
|
|
|
| LASTUSER |
|
|
|
| LASTEDATE |
|
|
|
| LASTTIME |
|
|
|
| RECID |
|
System |
Record ID |
|
 |