Retrieve vendor customer 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 Customers WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
IsMarkedForDeletion	Bool		Indicator for whether this customer information is marked for deletion.
RepresentativeName	String		The name of the representative.
CustomerTradingPartnerId	String		The customer trading partner ID.
CustomerCorporateGroup	String		The customer corporate group.
ExpressTrainStationName	String		The name of the train station that the customer uses to receive express deliveries.
AlternativePayerIsAllowed	Bool		Indicator for whether an alternative payer is allowed.
SalesArrangements	String		Data on sales arrangements.
SalesBlockForCustomer	Bool		Sales block status for the customer.
IsOrderBlocked	Bool		Indicator for whether the order is currently blocked.
OrderBlockedReasonCode	String		Reason code for the blocked order.
IsBillingBlocked	Bool		Indicator for whether billing is currently blocked.
BillingBlockedReasonCode	String		Reason code for the blocked billing.
IsDeliveryBlocked	Bool		Indicator for whether delivery is currently blocked.
DeliveryBlockedReasonCode	String		Reason code for the blocked delivery.
PostingIsBlocked	Bool		Indicator for whether posting is currently blocked.
NielsenRegionCode	String		Nielsen region code.
InternationalLocationNumber1	String		First international location number.
InternationalLocationNumber2	String		Second international location number.
InternationalLocationNumber3	String		Third international location number.
FiscalAddress	String		An additional master record in which the official address is stored.
FiscalYearVariant	String		The fiscal year represents the accounting year or annual accounting period. A fiscal year variant defines your company's accounting posting periods.
PlannedAnnualSalesYear	String		Planned annual sales year.
PlannedAnnualSalesAmount	Decimal		The planned annual sales amount.
PlannedAnnualSalesCurrency	String		The planned annual sales currency.
CfopCategoryCode	String		The CFOP category code. The CFOP is a code defined by the Brazilian tax authorities that describes the type of business transaction.
VatLiability	Bool		Indicator for whether liable for VAT.
AccountTaxTypeCode	String		The account's tax type code.
TaxClassifications	String		Classifications for tax.
IsEqualizationTaxSubject	Bool		Indicator for whether tax is applicable to equalization for the subject.
CustomerAccountGroupCode	String		Code for customer account group.
CustomerClassificationCode	String		Code for customer classification.
CustomerExtensionCode01	String		Code 01 for customer extension.
CustomerExtensionCode02	String		Code 02 for customer extension.
CustomerExtensionCode03	String		Code 03 for customer extension.
CustomerExtensionCode04	String		Code 04 for customer extension.
CustomerExtensionCode05	String		Code 05 for customer extension.
CustomerExtensionCode06	String		Code 06 for customer extension.
CustomerExtensionCode07	String		Code 07 for customer extension.
CustomerExtensionCode08	String		Code 08 for customer extension.
CustomerExtensionCode09	String		Code 09 for customer extension.
CustomerExtensionCode10	String		Code 10 for customer extension.
CustomerConditionGroup1Code	String		Code 1 for customer condition group.
CustomerConditionGroup2Code	String		Code 2 for customer condition group.
CustomerConditionGroup3Code	String		Code 3 for customer condition group.
CustomerConditionGroup4Code	String		Code 4 for customer condition group.
CustomerConditionGroup5Code	String		Code 5 for customer condition group.
DataExchangeInstructionCode	String		Instruction code for data medium exchange.
DataMediumExchangeIndicatorCode	String		Indicator code for data medium exchange.
BusinessType	String		The type of business.
IndustryType	String		The type of industry.
IndustryCode1Code	String		Code 1 for the industry type.
IndustryCode2Code	String		Code 2 for the industry type.
IndustryCode3Code	String		Code 3 for the industry type.
IndustryCode4Code	String		Code 4 for the industry type.
IndustryCode5Code	String		Code 5 for the industry type.