VendorInquiry
VendorInquiry.asmx
This web service provides a method to return vendor information.
This method uses relational engine to execute SQL command and retrieve information for all vendors.
Usage:
GetAllVendorResult = A.GetAllVendor(UserName, UserPassword, detailLevel, orderBy)
Parameters UserName and UserPassword are not used at this moment.
Input Parameter
|
Parameter |
Type |
Detail |
|
detailLevel |
String |
Required. Must be one of the following values: “M”: Minimal. “B”: Basic. “E”: Extended. “F”: Full. |
|
orderBy |
String |
|
GetAllVendorResult Structure
|
Property |
Type |
Detail |
|
ReturnCode |
Integer |
Contains return code. Zero means OK; for other return codes, please see “EliloginService Return Code” section. |
|
Vendors |
DataSet |
Contains a data table “Vendors.” For detail information of the data table, please refer to the following section. |
Columns in Vendors Data Table
When input detailLevel = “M”:
|
Property |
Detail |
|
VEND_NO |
|
|
VEND_NAME |
|
When input detailLevel = “B”:
|
Property |
Detail |
|
VEND_NO |
|
|
VEND_NAME |
|
|
VEND_ADDRESS1 |
|
|
VEND_ADDRESS2 |
|
|
VEND_CITY |
|
|
VEND_ST |
|
|
VEND_ZIP |
|
|
VEND_COUNTRY |
|
|
VEND_PHONE_NO |
|
|
VEND_CONTACT |
|
|
VEND_TYPE |
|
When input detailLevel = “E”:
|
Property |
Detail |
|
VEND_NO |
|
|
VEND_NAME |
|
|
VEND_ADDRESS1 |
|
|
VEND_ADDRESS2 |
|
|
VEND_CITY |
|
|
VEND_ST |
|
|
VEND_ZIP |
|
|
VEND_COUNTRY |
|
|
VEND_PHONE_NO |
|
|
VEND_CONTACT |
|
|
VEND_FED_ID_TYPE |
|
|
VEND_1099_CAT |
|
|
VEND_TYPE |
|
|
VEND_STATUS |
|
|
VEND_TERMS |
|
|
VEND_AUTO_DIST_FG |
|
|
VEND_BUYER_CONTACT |
|
|
VEND_FOB_CODE |
|
|
VEND_SHIP_VIA_CODE |
|
|
VEND_PRINT_PRICE_FG |
|
|
VEND_ACKNOWLEDGE_FG |
|
|
VEND_CONFIRM_FG |
|
|
VEND_COMM_CODE1 |
|
|
VEND_COMM_CODE2 |
|
|
VEND_COMM_CODE3 |
|
|
VEND_COMM_CODE4 |
|
|
VEND_COMM_CODE5 |
|
|
VEND_SEARCH_NAME |
|
|
VEND_NOTE_1 |
|
|
VEND_NOTE_2 |
|
|
VEND_NOTE_3 |
|
|
VEND_NOTE_4 |
|
|
VEND_NOTE_5 |
|
|
VEND_REMIT_TO |
|
|
FILLER_001 |
|
When input detailLevel = “F”:
|
Property |
Detail |
|
VEND_NO |
|
|
VEND_NAME |
|
|
VEND_ADDRESS1 |
|
|
VEND_ADDRESS2 |
|
|
VEND_CITY |
|
|
VEND_ST |
|
|
VEND_ZIP |
|
|
VEND_COUNTRY |
|
|
VEND_PHONE_NO |
|
|
VEND_CONTACT |
|
|
VEND_FED_ID_NO |
|
|
VEND_FED_ID_TYPE |
|
|
VEND_1099_CAT |
|
|
VEND_TYPE |
|
|
VEND_STATUS |
|
|
VEND_LAST_ACTIVE_DAT |
In YYYYMMDD Format. |
|
VEND_TERMS |
|
|
VEND_DUE_DAYS |
|
|
VEND_DSC_DAYS |
|
|
VEND_DSC_PCT |
|
|
VEND_PURCH_YTD |
|
|
VEND_PURCH_LAST_YR |
|
|
VEND_AMT_PD_YTD |
|
|
VEND_AMT_PD_LAST_YR |
|
|
VEND_DISC_YTD |
|
|
VEND_DISC_LAST_YR |
|
|
VEND_AUTO_DIST_FG |
|
|
VEND_BUYER_CONTACT |
|
|
VEND_FOB_CODE |
|
|
VEND_SHIP_VIA_CODE |
|
|
VEND_PRINT_PRICE_FG |
|
|
VEND_ACKNOWLEDGE_FG |
|
|
VEND_CONFIRM_FG |
|
|
VEND_POS_YTD |
|
|
VEND_LINE_ITEMS_YTD |
|
|
VEND_LATE_LINES_YTD |
|
|
VEND_PCT_LATE_LAST_Y |
|
|
VEND_AVG_COST_VAR_PC |
|
|
VEND_AVG_REJ_ITEMS_P |
|
|
VEND_AVG_LEAD_TIME |
|
|
VEND_AVG_DAYS_LATE |
|
|
VEND_COMM_CODE1 |
|
|
VEND_COMM_CODE2 |
|
|
VEND_COMM_CODE3 |
|
|
VEND_COMM_CODE4 |
|
|
VEND_COMM_CODE5 |
|
|
VEND_CHK_NO |
|
|
VEND_SEARCH_NAME |
|
|
VEND_NOTE_1 |
|
|
VEND_NOTE_2 |
|
|
VEND_NOTE_3 |
|
|
VEND_NOTE_4 |
|
|
VEND_NOTE_5 |
|
|
VEND_USER_DATE |
In YYYYMMDD Format. |
|
VEND_USER_AMOUNT |
|
|
VEND_REMIT_TO |
|
|
VEND_DELIVER_LEAD_TI |
|
|
FILLER_001 |
|
Code Example
The following sample code will return all vendor information into a dataset with detail level M (minimal).
Dim Service As New webServicesVenIq.VendorInquiry
Dim Result As New webServicesVenIq.GetAllVendorResult
Dim detailLevel As String = "M"
Result = _
Service.GetAllVendor("", "", detailLevel, "")
If Result.ReturnCode = 0 Then
lblResult.Text = "First Vendor No.: " + _
Result.Vendors.Tables(0).Rows(0).Item("VEND_NO")
Else
lblResult.Text = "Error code: " + Result.ReturnCode.ToString
End If
0 = OK
10001 = Invalid Detail Level
30001 = No Record Found
CLS