Suppliers
Lists Suppliers based on the search criteria.
Table Specific Information
Select
To query this table, the WHERE clause must contain the Id or one of the following sets of columns:
- Name_p
- Phone_p
- Address_p, City_p, and State_p
The add-in will use the SAP Concur APIs to filter by either Id or by any combination of Name_p, Address_p, Address2_p, City_p, State_p, Zip_p, Country_p, Phone_p, McCode_p, TaxId_p, MerchantType_p, MerchantID_p, IataCode_p, and Relevance_p. The add-in processes other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM Suppliers WHERE Id = 'sampleSuppliersId' SELECT * FROM Suppliers WHERE Name_p = 'sampleName' AND Address_p = 'exampleAddress' AND Address2_p = 'exampleAddress2' AND City_p = 'exampleCity' AND State_p = 'exampleState' AND Zip_p = 'exampleZip' AND Country_p = 'exampleCountry' AND Phone_p = '123456789' AND McCode_p = 'exampleMcCode' AND TaxId_p = 'exampleTaxId' AND MerchantType_p = 'Visa' AND MerchantID_p = 'exampleMerchantID' AND IataCode_p = 'code' AND Relevance_p = 5
Columns
Name | Type | References | Description |
ID [KEY] | String | The unique identifier of the resource. | |
AmadeusId | String | Amadeus Id | |
CreditCardVendorId | String | Creditcard Vendor Id | |
GalileoId | String | Galileo Id | |
NorthstarId | String | Northstar Id | |
PegasusId | String | Pegasus Id | |
SabreId | String | Sabre Id | |
TaxId | String | Tax Id | |
WorldspanId | String | Worldspan Id | |
AustinTetra | String | Austin Tetra | |
BusinessName | String | Name | |
ChainCode | String | Chain Code | |
ChainName | String | Chain Name | |
City | String | City | |
CountryCode | String | Country Code | |
DunsNumber | String | Duns Number | |
String | |||
Fax | String | Fax | |
MccCode | String | MCC Code (Ex: Delta Airline - 3058) | |
Phone | String | Phone | |
PostalCode | String | Zip | |
PrimaryNaics | String | Primary Naics Code | |
PrimarySic | String | Primary Sic Code | |
PropertyCode | String | undefined:ConnectSwaggerDocs-SUP_PARAM_PROPERTY_CODE | |
SecondaryNaics | String | Secondary Naics Code | |
SecondarySic | String | Secondary Sic Code | |
State | String | State | |
StreetAddress | String | Address | |
StreetAddress2 | String | Address2 | |
TollFree | String | Toll Free | |
URI | String | The URI to the resource. | |
WebUrl | String | Web Address |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description | |
IataCode_p | String | IATA Code | |
MerchantType_p | String | Merchant Type Code(Ex: Visa - VI, Amex - AX) | |
MerchantID_p | String | Merchant Id | |
Zip_p | String | Zip | |
Relevance_p | String | Relevance of the Search results | |
Name_p | String | Name | |
Address_p | String | Address | |
McCode_p | String | MCC Code (Ex: Delta Airline - 3058) | |
TaxId_p | String | Tax Id | |
Address2_p | String | Address | |
Country_p | String | Country Code |