Retrieve vendor address data email addresses.

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 AddressEmailAddresses 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 email address object in the response collection.
AddressId	String		The ID of the address, or the position of the address object in the response collection
Id	String		The ID of the email address.
ValidFrom	Date		Validity for email address start date.
ValidTo	Date		Validity for email address end date.
Address	String		The email address.
IsDefault	Bool		Indicator for whether this is the default email address.
UsageDeniedIndicator	Bool		Signifies whether of not the email address can be used for communication.