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