| |
CONTSUPP - Web Addresses
P
Details Tab, Web Site Address
All web addresses are stored in this table. There are different variations of web addresses and below are definitions of how they are stored. The Contact field is always “Web Site” and the ContSupRef field is usually
the web 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 |
‘Web Site’ |
TITLE |
|
|
|
CONTSUPREF |
Reference |
User |
Web Site Address (See NOTES) |
DEAR |
|
|
|
PHONE |
|
System |
If Primary address, ‘mProfRef’, otherwise
Lookup.LookupSupp value for Web Site. |
EXT |
|
|
|
FAX |
|
|
|
LINKACCT |
|
|
|
NOTES |
|
User |
If the entire web site address will exceed 40
characters,
the user must put the entire address in
the Notes field instead. |
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 |
|
|
|
STATE |
|
|
|
ZIP |
|
|
|
COUNTRY |
|
|
|
MERGECODES |
|
|
|
STATUS |
|
System |
‘00’ for all addresses except those with address in Notes field, then ‘01’
(see Detail/Profile use of this field above). |
LINKEDDOC |
|
|
|
LASTUSER |
|
|
|
LASTEDATE |
|
|
|
LASTTIME |
|
|
|
RECID |
|
System |
Record ID |
|
|
Do you want to
exchange links?
Click on my banner
for more information.
|
|
|
An honest politician is one who STAYS bought!
|
|
|
|
|