Retrieve vendor bank accounts.

View-Specific Information

Select

The connector uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

• SMVendorId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM BankAccounts WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
Id [KEY]	String		The ID of the bank account.
ValidFrom	Date		Validity for bank account start date.
ValidTo	Date		Validity for bank account end date.
IBAN	String		The bank account's International Bank Account Number.
BankAccount	String		This field contains the number under which the account is managed at the bank.
BankNumber	String		The bank key under which the bank data is stored in the appropriate country.
BankAccountName	String		Name of the bank account.
BankAccountHolderName	String		The name of the bank account holder.
BankAccountReference	String		Reference details for the bank account.
AlternatePaymentAccount	String		Alternate payment account.
AdditionalPaymentReference	String		Additional reference details for payments.
BankControlKey	String		A check key for the combination bank number and bank account number.
BankCountryCode	String		The country code of the bank account.
BankAccountCurrencyCode	String		The currency code of the bank account.