vw_account_addresses
Each row represents a physical/mailing address associated with an account.
| Column | Type | Description |
|---|---|---|
| account_id | varchar(64) | Primary Key: System Id of the account |
| address_street | varchar(1024) | First line of the address |
| address_unit | varchar(1024) | Second line of the address |
| address_locality | varchar(1024) | Locality or city |
| address_region | varchar(1024) | Region, state, province |
| address_postal_code | varchar(1024) | Postal code or Zip code |
| address_country | varchar(1024) | Country |
| address_type | varchar(1024) | Type of address (Billing, Mailing, Shipping, etc.) |
| is_primary | tinyint | Is this the primary address for this account? |