GoldMine Table Structures.
CONTACT1
DBase Directory Location: COMMON
Table Description: Primary Contact table - holds the primary contact data
Table Indexes | |||
Name | DBase Index | SQL Index | ID |
CONTACC | ACCOUNTNO | ACCOUNTNO | 15 |
CONTCOMP | UPPER(COMPANY)+SUBSTR(ACCOUNTNO,10,4) | U_COMPANY+ACCOUNTNO | 16 |
CONTNAME | UPPER(CONTACT)+SUBSTR(ACCOUNTNO,10,4) | U_CONTACT+ACCOUNTNO | 17 |
CONTZIP | ZIP+SUBSTR(ACCOUNTNO,10,4) | ZIP+ACCOUNTNO | 18 |
CONTCITY | UPPER(CITY)+SUBSTR(ACCOUNTNO,10,4) | U_CITY+ACCOUNTNO | 19 |
CONTKEY1 | UPPER(KEY1)+SUBSTR(ACCOUNTNO,10,4) | U_KEY1+ACCOUNTNO | 20 |
CONTKEY2 | UPPER(KEY2)+SUBSTR(ACCOUNTNO,10,4) | U_KEY2+ACCOUNTNO | 21 |
CONTKEY3 | UPPER(KEY3)+SUBSTR(ACCOUNTNO,10,4) | U_KEY3+ACCOUNTNO | 22 |
CONTKEY4 | UPPER(KEY4)+SUBSTR(ACCOUNTNO,10,4) | U_KEY4+ACCOUNTNO | 23 |
CONTKEY5 | UPPER(KEY5)+SUBSTR(ACCOUNTNO,10,4) | U_KEY5+ACCOUNTNO | 24 |
CONTLAST | UPPER(LASTNAME)+SUBSTR(ACCOUNTNO,10,4) | U_LASTNAME+ACCOUNTNO | 25 |
CONTSTAT | UPPER(STATE+CITY)+SUBSTR(ACCOUNTNO,10,4) | U_STATE+U_CITY+ACCOUNTNO | - |
CONTCNTY | UPPER(COUNTRY+STATE)+SUBSTR(ACCOUNTNO,10,4) | U_COUNTRY+U_STATE+ACCOUNTNO | - |
CONTPHON | PHONE1+SUBSTR(ACCOUNTNO,10,4) | PHONE1+ACCOUNTNO | 26 |
CN1RECID | RECID | RECID | 27 |
Table Relationships | |||
Field | Related Table to Field | Type | Notes |
AccountNo | Contact2->AccountNo | 1-1 | Contact2 holds additional fields |
AccountNo | ContSupp->AccountNo | 1-M | |
AccountNo | ContHist->AccountNo | 1-M | |
AccountNo | Cal->AccountNo | 1-M | Only for activities linked to a contact record |
AccountNo | MailBox->AccountNo | 1-M | Linked e-mails, does not include folder records in Mailbox. |
Table Fields Structure | |||||||||||||
Field Name | Field Type | Length | Description | ||||||||||
ACCOUNTNO | String | 20 | Unique Account Number. This field is automatically generated with the following values in the specified positions.
|
||||||||||
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.
|
||||||||||
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 (SQL Only) | ||||||||||
U_CONTACT | String | 40 | Upper-case shadow of Contact Name (SQL Only) | ||||||||||
U_LASTNAME | String | 15 | Upper-case shadow of Contact’s Last Name (SQL Only) | ||||||||||
U_CITY | String | 26 | Upper-case shadow of City (SQL Only) | ||||||||||
U_STATE | String | 20 | Upper-case shadow of State (SQL Only) | ||||||||||
U_COUNTRY | String | 20 | Upper-case shadow of Country (SQL Only) | ||||||||||
U_KEY1 | String | 20 | Upper-case shadow of Key 1 (SQL Only) | ||||||||||
U_KEY2 | String | 20 | Upper-case shadow of Key 2 (SQL Only ) | ||||||||||
U_KEY3 | String | 20 | Upper-case shadow of Key 3 (SQL Only ) | ||||||||||
U_KEY4 | String | 20 | Upper-case shadow of Key 4 (SQL Only ) | ||||||||||
U_KEY5 | String | 20 | Upper-case shadow of Key 5 (SQL Only ) | ||||||||||
RECID | String | 15 | Record ID |