VendorInquiry

VendorInquiry.asmx

This web service provides a method to return vendor information.


GetAllVendor

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

 

VendorInquiry Return Code

0 = OK

10001 = Invalid Detail Level

30001 = No Record Found

CLS

Feedback and Knowledge Base