CompanyCodes
Retrieve vendor company code related details.
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 CompanyCodes WHERE SMVendorID = 'S123456'
SELECT * FROM CompanyCodes WHERE ERPVendorId = '1000003560'
SELECT * FROM CompanyCodes WHERE VendorRegistrationStatus = 'Registered'
SELECT * FROM CompanyCodes WHERE VendorQualificationStatus = 'Qualified'
SELECT * FROM CompanyCodes WHERE VendorPreferredLevel = 1
SELECT * FROM CompanyCodes WHERE VendorBusinessUnit = '408'
SELECT * FROM CompanyCodes WHERE VendorCategory = '51'
SELECT * FROM CompanyCodes 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. | |
CompanyCode [KEY] | String | The company code. | |
PaymentMethodsCode | String | The code of the payment method. | |
PlanningGroupCode | String | The code of the planning group. | |
CashDiscountTermsCode | String | The code of the cash discount terms. | |
GeneralLedgerAccountReferenceId | String | The reference id of the general ledger account. | |
WithHoldingTaxes | String | Tax details. | |
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. |