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

Developer Documentations

  1. Received Code 9999 with Web Services Call
  2. Received Return Status Code 3 When Using Elilogin Login Method
  3. Elliott Web Service Requirements
  4. Elliott eStore Checklist
  5. LN API
  6. FN API
  7. RN API
  8. IN and DF API Change (V9.0)
  9. FA API Changes (V9.0)
  10. VA API Changes (V9.0)
  11. CartService
  12. EliarachService
  13. ElicshtxService
  14. EliattrbService
  15. ElisyscdService
  16. EliNoteService
  17. El2rstimService
  18. EliOrderService
  19. ItemInquiry
  20. EliitmiqService
  21. EliShiptoService
  22. El2getfrService
  23. Steps Required to Test ReportWriter in V8.2
  24. Installation of ElliottService, NETcellent’s Web Services for Elliott
  25. ResellerFinder
  26. EliaptrxService
  27. VendorInquiry
  28. EliloginService
  29. ElislsmnService
  30. EliserhsService
  31. EliatpobService
  32. ElievprcService
  33. ElihdtrxService
  34. ElicuswlService
  35. QueryTurnaround
  36. InvoiceInquiry
  37. ElicustmService
  38. EligetcdService
  39. OrderInquiry
  40. EliordiqService
  41. EliecontService
  42. EliautdpService
  43. El2CrCrdService
  44. Log-Timer / ElliottTimer.Ini Support
  45. Alpha Document Number Support (V8.5/V9.0)
  46. ElliottService System.TypeInitializationException
  47. Feature - Printing API to Dynamically Set Number of Copies
  48. The Values and Meanings of Distribution Types - ARDISFIL, APDISFIL, IMDISFIL, BMDISFIL
  49. DD API Changes (V9.0)
  50. PA API (8.5)
  51. Validate License API
  52. AP API
  53. TP API: Temporary Path
  54. Data Structures for Report Desk Defaults and Enforcements
  55. COBOL to VB Interface Programs
  56. IN API: Option to Support Files and Folders Validation
  57. FF API: File Functions
  58. ID API
  59. LK: Links API
  60. FFLNearYou
  61. Report Desk Developing and Debugging
  62. Developing a New Elliott V8.6 Report Desk User Defined Report (UDR)
  63. CustomerInquiry
  64. Elliott API (JSON Web Service)
  65. Animating COBOL Code in Elliott V8.5
  66. Preliminary Programming Changes for Elliott 8.6
  67. CV API
  68. System Lock File Requirements
  69. How to Write Test Codes for C# ESS Projects
  70. Solving the Inability to Debug Elliott on a New Server
  71. Report Desk: Developing Custom Reports
  72. Report Desk Tables
  73. Report Desk Database Delivery Strategy

Feedback and Knowledge Base