GoldMine Table Structures.
CONTSUPP - Web Addresses
RecType in Table: P
GoldMine Location: 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.
Fields In Use in GoldMine | |||
Field Name | GoldMine Field | Type | Field Used For |
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 |