> For the complete documentation index, see [llms.txt](https://infinisuite.gitbook.io/sdk/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://infinisuite.gitbook.io/sdk/data-model-and-schema/views/contactview.md).

# 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