ODBC Driver for SAP Ariba Source

Build 24.0.9060

AddressFaxNumbers

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.
AddressNumberInCollection [KEY] Int Position of the address object in the response collection.
NumberInCollection [KEY] Int Position of the address fax number object in the response collection.
AddressId String The ID of the address.
Id 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.

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