Retrieve vendor address data phone numbers.

View-Specific Information

Select

The driver uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The driver processes other filters client-side within the driver.

• SMVendorId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM AddressPhoneNumbers WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
AddressId [KEY]	String		The ID of the address.
Id [KEY]	String		The ID of the phone number.
ValidFrom	Date		Validity for phone number start date.
ValidTo	Date		Validity for phone number end date.
Number	String		The phone number.
IsDefault	Bool		Indicator for whether this is the default phone number.
NumberExtension	String		Extension number for the phone number.
IsMobile	Bool		Indicator for whether the phone number is of a mobile.
UsageDeniedIndicator	Bool		Signifies whether of not the phone number can be used for communication.
SmsEnabledIndicator	Bool		Signifies whether of not the phone number can be used for SMS communication.
CountryCode	String		The country code of the phone number.