BankInfos
Retrieve vendor bank related data.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- SMVendorId supports the '=,IN' comparison operators.
- ERPVendorId supports the '=,IN' comparison operators.
- VendorLastUpdateDate supports the '<=,<,=,>,>=' comparison operators.
- VendorRegistrationStatus supports the '=,IN' comparison operators.
- VendorQualificationStatus supports the '=,IN' comparison operators.
- VendorPreferredLevel supports the '=,IN' comparison operators.
- VendorBusinessUnit supports the '=,IN' comparison operators.
- VendorCategory supports the '=,IN' comparison operators.
- VendorRegion supports the '=,IN' comparison operators.
SELECT * FROM BankInfos WHERE SMVendorID = 'S123456'
SELECT * FROM BankInfos WHERE ERPVendorId = '1000003560'
SELECT * FROM BankInfos WHERE VendorRegistrationStatus = 'Registered'
SELECT * FROM BankInfos WHERE VendorQualificationStatus = 'Qualified'
SELECT * FROM BankInfos WHERE VendorPreferredLevel = 1
SELECT * FROM BankInfos WHERE VendorBusinessUnit = '408'
SELECT * FROM BankInfos WHERE VendorCategory = '51'
SELECT * FROM BankInfos WHERE VendorRegion = 'USA'
Columns
Name | Type | References | Description |
SMVendorId [KEY] | String |
Vendors.SMVendorId | A unique ID that SAP Ariba assigns automatically. |
ERPVendorId | String | A mandatory ID, which must be unique in combination with the supplier's source system. | |
NumberInCollection [KEY] | Int | Position of the object in the response collection. | |
BankAccountInternalId | String | The internal ID of the bank account. | |
BankAccountStandardId | String | The standard ID of the bank account. | |
BankAccountExternalId | String | The external ID of the bank account. | |
AccountName | String | The name of the account. | |
AccountNumber | String | The number of the account. | |
BankBranch | String | The associated bank branch. | |
Country | String | The country code. | |
Address | String | Address related data. | |
VendorLastUpdateDate | Datetime | Date of the last update. | |
VendorRegistrationStatus | String | Registration status of the record. | |
VendorQualificationStatus | String | Qualification status of the record. | |
VendorPreferredLevel | Int | Preferred status. A number between 1 and 5. 1 is the highest preferred level and 5 is the lowest. | |
VendorBusinessUnit | String | A business unit or department ID loaded in your site as master data and used in supplier management projects. | |
VendorCategory | String | A category ID loaded in your site as master data and used in supplier management projects. | |
VendorRegion | String | A region code loaded in your site as master data and used in supplier management projects. |