Retrieve vendor supplier accounting information.

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 '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM SupplierAccounting WHERE SMVendorID = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
AccountNumberAtSupplier	String		Account number at the supplier.
ReconciliationAccountNumber [KEY]	String		Reconciliation account number.
CompanyCodeDisplayId	String		Display ID for the company code.
HouseBank	String		House bank information.
CashPlanningGroup	String		Cash planning group.
PaymentMethods	String		Payment methods associated with the record.
WithholdingTaxes	String		Withholding taxes information.
IsMarkedForDeletion	Bool		Indicator for whether the record is marked for deletion.
ModifiedAt	Datetime		Date and time of last modification.
CreatedAt	Datetime		Date and time of creation.
AccountingClerkId	String		ID of the accounting clerk.
AccountingClerkInternetAddress	String		Internet address of the accounting clerk.
InvoiceSortingOrderCode	String		Code for the invoice sorting order.
MinorityGroupCode	String		Code for the minority group.
IsAlternativePayeeUsed	Bool		Indicator for whether alternative payee is used.
AlternativePayees	String		List of alternative payees.
IsDoubleInvoice	Bool		Indicator for whether a double invoice is used.
IsPaymentBlocked	Bool		Indicator for whether payment is blocked.
PaymentBlockingReasonCode	String		Reason code for payment blocking.
IsPostingBlocked	Bool		Indicator for whether posting is blocked.
PostingBlockingReasonCode	String		Reason code for posting blocking.