OrganizationsAddresses

The physical address of the organization.

Table-Specific Information

SELECT

The 本製品 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 本製品.

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.

SSIS Components for Oracle Service Cloud

OrganizationsAddresses

Table-Specific Information

SELECT

Columns