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? |