SSIS Components for SAP Ariba Source

Build 24.0.9060

BankAccounts

Retrieve vendor bank accounts.

View-Specific Information

Select

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

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

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