OrganizationsAddresses
The physical address of the organization.
Table-Specific Information
SELECT
The connector will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the connector.
SELECT * FROM OrganizationsAddresses WHERE addresstypeId = 12 SELECT * FROM OrganizationsAddresses WHERE addresstypeId > 15 SELECT * FROM OrganizationsAddresses WHERE city LIKE '%test' SELECT * FROM OrganizationsAddresses WHERE addresstypeId IN (12, 23, 123) SELECT * FROM OrganizationsAddresses WHERE city IS NOT NULL
Columns
| Name | Type | Description |
| OrganizationsId | Long | The unique identifier of the organization. |
| AddressTypeId | Long | Id of addressType. The type of address, such as mailing, street, and so on. This is the key for the list entry. |
| AddressTypelookUpName | String | LookUpName of addressType. The type of address, such as mailing, street, and so on. This is the key for the list entry. |
| City | String | The name of the city. |
| CountryId | Long | Id of country. The ID of the country. |
| CountrylookUpName | String | LookUpName of country. The ID of the country. |
| PostalCode | String | The postal code or ZIP code. |
| StateOrProvinceId | Long | Id of stateOrProvince. The ID of the state or province. |
| StateOrProvincelookUpName | String | LookUpName of stateOrProvince. The ID of the state or province. |
| Street | String | The street address. |