JDBC Driver for Oracle Service Cloud

Build 22.0.8462

AccountsPhones

The details related to the phone number.

Table-Specific Information

SELECT

The driver 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 driver.

SELECT * FROM AccountsPhones WHERE accountsId = 12
SELECT * FROM AccountsPhones WHERE accountsId > 15
SELECT * FROM AccountsPhones WHERE number LIKE '%test'
SELECT * FROM AccountsPhones WHERE accountsId IN (12,23,123)
SELECT * FROM AccountsPhones WHERE number IS NOT NULL

Columns

Name Type Description
AccountsId Long Id of Accounts.
Number String The free-form phone number including non-numeric characters. For example, 1 (406) 522-4200.
PhoneTypeId Long Id of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry.
PhoneTypelookUpName String LookUpName of phoneType. The type of phone number such as Home, Mobile, Office, and so on. This is the key for the list entry.
RawNumber String The automatically populated numeric string derived by excluding the non-numeric characters from the value of the Number attribute. For example, if the Number attribute has a value of 1 (406) 522-4200, this field is populated as 14065224200. This attribute is read-only.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462