# contactview

## Type: view

## Columns

| Column                       | Type      | Attributes | Description |
| ---------------------------- | --------- | ---------- | ----------- |
| accountrowid                 | int       |            |             |
| addressrowid                 | int       |            |             |
| alternatephonenbr            | varchar   |            |             |
| attention                    | varchar   |            |             |
| companyname                  | varchar   |            |             |
| companyrowid                 | int       |            |             |
| contactid                    | varchar   |            |             |
| contacttypeid                | varchar   |            |             |
| contacttypelistitemrowid     | int       |            |             |
| contacttypeuid               | varchar   |            |             |
| description                  | varchar   |            |             |
| emailaddress                 | varchar   |            |             |
| faxnbr                       | varchar   |            |             |
| firstactivitydate            | datetime  |            |             |
| firstname                    | varchar   |            |             |
| isactive                     | tinyint   |            |             |
| jobrowid                     | int       |            |             |
| languagelistitemrowid        | varchar   |            |             |
| lastname                     | varchar   |            |             |
| mailtoname                   | varchar   |            |             |
| middlename                   | varchar   |            |             |
| mobilenbr                    | varchar   |            |             |
| noterowid                    | int       |            |             |
| phonenbr                     | varchar   |            |             |
| relationshiprowid            | int       |            |             |
| rowid                        | int       |            |             |
| salespersonrelationshiprowid | int       |            |             |
| suffix                       | varchar   |            |             |
| taskrowid                    | int       |            |             |
| title                        | varchar   |            |             |
| transactionrowid             | int       |            |             |
| updatetimestamp              | timestamp |            |             |
| userrowid                    | int       |            |             |

v.ismain -- Wed, Feb 28, 2018 2:58 PM