Excel Add-In for SAP Ariba Source

Build 24.0.9060

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060