Retrieve vendor address data fax 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 AddressFaxNumbers 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 fax number.
ValidFrom	Date		Validity for fax number start date.
ValidTo	Date		Validity for fax number end date.
Number	String		The fax number.
IsDefault	Bool		Indicator for whether this is the default fax number.
NumberExtension	String		Extension number for the fax number.
UsageDeniedIndicator	Bool		Signifies whether of not the fax number can be used for communication.
CountryCode	String		The country code of the fax number.