AddressPhoneNumbers
Retrieve vendor address data phone numbers.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- SMVendorId supports the '=' comparison operator.
SELECT * FROM AddressPhoneNumbers WHERE SMVendorId = 'S123456'
Columns
Name | Type | References | Description |
SMVendorId [KEY] | String |
Vendors.SMVendorId | A unique ID that SAP Ariba assigns automatically. |
AddressNumberInCollection [KEY] | Int | Position of the address object in the response collection. | |
NumberInCollection [KEY] | Int | Position of the address phone number object in the response collection. | |
AddressId | String | The ID of the address. | |
Id | 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. |