# addressview

## Type: view

## Columns

| Column                   | Type      | Attributes | Description |
| ------------------------ | --------- | ---------- | ----------- |
| accountrowid             | int       |            |             |
| addressid                | varchar   |            |             |
| addresstypeaccountrowid  | int       |            |             |
| addresstypeclassrowid    | int       |            |             |
| addresstypedescription   | varchar   |            |             |
| addresstypeid            | varchar   |            |             |
| addresstypeisactive      | tinyint   |            |             |
| addresstypelistitemrowid | int       |            |             |
| addresstyperowid         | int       |            |             |
| addresstypeuid           | varchar   |            |             |
| addresstypexref          | varchar   |            |             |
| attention                | varchar   |            |             |
| city                     | varchar   |            |             |
| companyrowid             | int       |            |             |
| contactrowid             | int       |            |             |
| countrylistitemrowid     | int       |            |             |
| description              | varchar   |            |             |
| isactive                 | tinyint   |            |             |
| isdefault                | smallint  |            |             |
| jobrowid                 | int       |            |             |
| noterowid                | int       |            |             |
| phonenbr                 | varchar   |            |             |
| relationshiprowid        | int       |            |             |
| rowid                    | int       |            |             |
| state                    | varchar   |            |             |
| streetaddress            | varchar   |            |             |
| taskrowid                | int       |            |             |
| transactionrowid         | int       |            |             |
| updatetimestamp          | timestamp |            |             |
| zipcode                  | varchar   |            |             |

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