Retrieve vendor address data websites.

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 AddressWebsites 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 website object in the response collection.
AddressId	String		The ID of the address.
Id	String		The ID of the website.
ValidFrom	Date		Validity for website start date.
ValidTo	Date		Validity for website end date.
Url	String		The website's URL.
UriType	String		The type of the URI.
IsDefault	Bool		Indicator for whether this is the default website.