InvoiceInquiry

InvoiceInquiry.asmx

This web service provides two methods to access Elliott Invoice History database:

·        GetInvHdrByCusNo: Get a list of invoices for a certain customer number.

·        GetOneInvoiceDetail: Get the details of one invoice by specifying the invoice number. This includes the invoice header, line items and more.

 

GetInvHdrByCusNo

This method returns invoice headers by providing customer number by using a relational engine.

Usage:

GetInvHdrByCusNoResult = A.GetInvHdrByCusNo(UserName, UserPassword, customerNo, invoiceCutoffDate, orderBy)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Type

Detail

customerNo

String

Required. ====== last stop here ==============????

invoiceCutoffDate

Date

If this value is provided, only invoices with invoice date greater than this value will be returned.

orderBy

String

Can be empty or one of the fields in returned invoice header table CPINVHDR.

 

GetInvHdrByCusNoResult Structure

Property Name

Type

Detail

ReturnCode

Integer

0 = OK

10001 = Missing Customer No

InvoiceHeaders

DataSet

This dataset has a data table “InvoiceHeaders.”. Please refer to the following section for its structure.

 Columns in “InvoiceHeaders” DataTable – see ????? for more details of these columns:

INV_NO

INV_DATE_ENTERED

INV_ORDER_DATE

INV_TYPE

INV_APPLY_TO_NO

INV_PURCHASE_ORD_NO

INV_CUSTOMER_NO

INV_NO_ALT

INV_CUST_BAL_METHOD

INV_BILL_TO_NAME

INV_BILL_TO_ADDR_1

INV_BILL_TO_ADDR_2

INV_BILL_TO_CITY

BILL_TO_FILLER1

INV_BILL_TO_ST

BILL_TO_FILLER2

INV_BILL_TO_ZIPCD

INV_BILL_TO_COUNTRY

INV_SHIP_TO_NO

INV_SHIP_TO_NAME

INV_SHIP_TO_ADDR_1

INV_SHIP_TO_ADDR_2

INV_SHIP_TO_CITY

SHIP_TO_FILLER1

INV_SHIP_TO_ST

SHIP_TO_FILLER2

INV_SHIP_TO_ZIPCD

INV_SHIP_TO_COUNTRY

INV_SHIPPING_DATE

INV_SHIP_VIA_CODE

INV_TERMS_CODE

INV_FRT_PAY_CODE

INV_SHIP_INSTRUCT1

INV_SHIP_INSTRUCT2

INV_SALESMAN_NO1

INV_SALESMAN_PCT_CO1

INV_SALESMAN_COM_AM1

INV_SALESMAN_NO2

INV_SALESMAN_PCT_CO2

INV_SALESMAN_COM_AM2

INV_SALESMAN_NO3

INV_SALESMAN_PCT_CO3

INV_SALESMAN_COM_AM3

INV_TAX_CODE_1

INV_TAX_PERCENT_1

INV_TAX_CODE_2

INV_TAX_PERCENT_2

INV_TAX_CODE_3

INV_TAX_PERCENT_3

INV_DISCOUNT_PERCENT

INV_JOB_NO

INV_MFG_LOCATION

INV_PROFIT_CENTER

INV_DEPARTMENT

INV_AR_REFERENCE

INV_TOT_SALE_AMT

INV_TOT_TAX_AMT

INV_TOT_COST

INV_TOT_WEIGHT

INV_MISC_CHG_AMT

INV_MISC_CHG_ACCT_NO

INV_FRT_AMT

INV_FRT_ACCT_NO

INV_SALES_TAX_AMT_1

INV_SALES_TAX_AMT_2

INV_SALES_TAX_AMT_3

INV_COMM_PERCENT

INV_COMM_AMOUNT

INV_COMMENT1

INV_COMMENT2

INV_COMMENT3

INV_PAYMENT_AMT

INV_PAYMENT_DISC_AMT

INV_CHECK_NO

INV_CHECK_DATE

INV_CASH_ACCT_NO

INV_DATE_PICKED

INV_DATE_BILLED

INV_ORDER_NO

INV_DATE

INV_SELECTION_CODE

INV_POSTED_DATE

INV_PART_POSTED_FLAG

INV_SHIP_TO_FR_FO_FG

INV_BILL_TO_FR_FO_FG

INV_COPY_TO_BM_FG

INV_EDI_FG

INV_EDI_PO_NO_CONT

INV_CLOSED_FG

INV_ACC_MISC_CHG_AMT

INV_ACC_FRT_AMT

INV_ACC_TOT_TAX_AMT

INV_ACC_SALE_TAX_AMT

INV_ACC_TOT_SALE_AMT

INV_STORE_NO

INV_BILL_TO_NO

INV_RMA_STATUS

INV_PHATM_INV_FLAG

INV_DEPT_NO

INV_BOL_PRINTED

INV_REF_DOC_NO

INV_PAYMENT_TP

INV_EDI_EXP_FLG

INV_BOL_NO

INV_FULL_PAY_DATE

INV_PO_REQ_GEN_FLG

INV_PICK_TIC_CUTOFF

INV_ORD_EDI_EXP_FLG

INV_FILLER_001

INV_SHIP_TO_XREF_NO

INV_FILLER_002

 

Code Example (VB)

The following sample code will return invoice headers for customer “000001” after 02/28/2010.

 

Dim Service As New webServicesInvoiceInquiry.InvoiceInquiry()

Dim Result As New webServicesInvoiceInquiry.GetInvHdrByCusNoResult

Dim customerNo As String = “000001”

Dim invoiceCutoffDate As Date = New Date(2010,2,28)

Dim orderBy As String = “INV_DATE_ENTERED”

Result = Service.GetInvHdrByCusNo(“”, “”,customerNo, invoiceCutoffDate, orderBy)

If Result.ReturnCode = 0 Then

  If Result.InvoiceHeaders.Tables(0).Rows.Count > 0 Then

     lblResult.Text = “First Invoice No. is” & _

      Result.InvoiceHeaders.Tables(0).Rows(0).Item("INV_NO").ToString

  Else

     lblResult.Text = “No Matching Invoice.”

  End If

Else

  lblResult.Text = “Error While Quering Invoice.”

  lblErrorCode.Text = Result.ToString

End If

 

GetOneInvoiceDetail

This method returns one invoice’s details by providing invoice number.

Usage:

GetInvoiceDetailResult = A.GetInvoiceDetail(UserName, UserPassword, invoiceNo, orderBy)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Type

Detail

invoiceNo

String

Required.

orderBy

String

This field only affects the order of “InvoiceLineItem” data table.

The value her can be empty or one of the fields in table CPINVLIN.

 

GetInvoiceDetailResult Structure

Property Name

Type

Detail

ReturnCode

Integer

0 = OK

10002 = Missing Invoice No

InvoiceDetail

DataSet

This dataset has four data tables: “InvoiceHeader,” “InvoiceLineItem,” “Notes,” “InvoiceSerialNo” and “Payment.” Please refer to the following sections for their structures.

 

Columns in “InvoiceHeader” DataTable

INV_NO

INV_DATE_ENTERED

INV_ORDER_DATE

INV_TYPE

INV_APPLY_TO_NO

INV_PURCHASE_ORD_NO

INV_CUSTOMER_NO

INV_NO_ALT

INV_CUST_BAL_METHOD

INV_BILL_TO_NAME

INV_BILL_TO_ADDR_1

INV_BILL_TO_ADDR_2

INV_BILL_TO_CITY

BILL_TO_FILLER1

INV_BILL_TO_ST

BILL_TO_FILLER2

INV_BILL_TO_ZIPCD

INV_BILL_TO_COUNTRY

INV_SHIP_TO_NO

INV_SHIP_TO_NAME

INV_SHIP_TO_ADDR_1

INV_SHIP_TO_ADDR_2

INV_SHIP_TO_CITY

SHIP_TO_FILLER1

INV_SHIP_TO_ST

SHIP_TO_FILLER2

INV_SHIP_TO_ZIPCD

INV_SHIP_TO_COUNTRY

INV_SHIPPING_DATE

INV_SHIP_VIA_CODE

INV_TERMS_CODE

INV_FRT_PAY_CODE

INV_SHIP_INSTRUCT1

INV_SHIP_INSTRUCT2

INV_SALESMAN_NO1

INV_SALESMAN_PCT_CO1

INV_SALESMAN_COM_AM1

INV_SALESMAN_NO2

INV_SALESMAN_PCT_CO2

INV_SALESMAN_COM_AM2

INV_SALESMAN_NO3

INV_SALESMAN_PCT_CO3

INV_SALESMAN_COM_AM3

INV_TAX_CODE_1

INV_TAX_PERCENT_1

INV_TAX_CODE_2

INV_TAX_PERCENT_2

INV_TAX_CODE_3

INV_TAX_PERCENT_3

INV_DISCOUNT_PERCENT

INV_JOB_NO

INV_MFG_LOCATION

INV_PROFIT_CENTER

INV_DEPARTMENT

INV_AR_REFERENCE

INV_TOT_SALE_AMT

INV_TOT_TAX_AMT

INV_TOT_COST

INV_TOT_WEIGHT

INV_MISC_CHG_AMT

INV_MISC_CHG_ACCT_NO

INV_FRT_AMT

INV_FRT_ACCT_NO

INV_SALES_TAX_AMT_1

INV_SALES_TAX_AMT_2

INV_SALES_TAX_AMT_3

INV_COMM_PERCENT

INV_COMM_AMOUNT

INV_COMMENT1

INV_COMMENT2

INV_COMMENT3

INV_PAYMENT_AMT

INV_PAYMENT_DISC_AMT

INV_CHECK_NO

INV_CHECK_DATE

INV_CASH_ACCT_NO

INV_DATE_PICKED

INV_DATE_BILLED

INV_ORDER_NO

INV_DATE

INV_SELECTION_CODE

INV_POSTED_DATE

INV_PART_POSTED_FLAG

INV_SHIP_TO_FR_FO_FG

INV_BILL_TO_FR_FO_FG

INV_COPY_TO_BM_FG

INV_EDI_FG

INV_CLOSED_FG

INV_ACC_MISC_CHG_AMT

INV_ACC_FRT_AMT

INV_ACC_TOT_TAX_AMT

INV_ACC_SALE_TAX_AMT

INV_ACC_TOT_SALE_AMT

INV_STORE_NO

INV_BILL_TO_NO

INV_RMA_STATUS

INV_PHATM_INV_FLAG

INV_DEPT_NO

INV_BOL_PRINTED

INV_REF_DOC_NO

INV_PAYMENT_TP

INV_EDI_EXP_FLG

INV_BOL_NO

INV_FULL_PAY_DATE

INV_PO_REQ_GEN_FLG

INV_PICK_TIC_CUTOFF

INV_ORD_EDI_EXP_FLG

INV_FILLER_001

INV_SHIP_TO_XREF_NO

INV_FILLER_002

 

Columns in “InvoiceLineItem” DataTable

INV_ITM_INV_NO

INV_ITM_SEQ_NO

INV_ITM_ITM_NO

INV_ITM_INV_DATE

INV_ITM_CUST_NO

INV_ITM_ITM_NO_ALT

INV_ITM_INV_DATE_ALT

INV_ITM_DESC_1

INV_ITM_DESC_2

INV_ITM_SER_LOT_NO

INV_ITM_SER_EFF_DATE

INV_ITM_S_L_EXP_CNTY

INV_ITM_S_L_EXP_YEAR

INV_ITM_S_L_EXP_MON

INV_ITM_S_L_EXP_DAY

INV_ITM_QTY_ORDER

INV_ITM_QTY_TO_SHIP

INV_ITM_UNIT_PRICE

INV_ITM_DISCOUNT_PCT

INV_ITM_REQUEST_DATE

INV_ITM_QTY_BACK_ORD

INV_ITM_QTY_RT_TO_ST

INV_ITM_BACK_FLAG

INV_ITM_UOM

INV_ITM_UNIT_COST

INV_ITM_UNIT_WEIGHT

INV_ITM_COMM_CALA_TP

INV_ITM_COMM_P_O_AMT

INV_ITM_PROMISE_DATE

INV_ITM_TAXABLE_FLAG

INV_ITM_STOCKED_FLAG

INV_ITM_CONTROL_FLAG

INV_ITM_SELECT_CODE

INV_ITM_TOT_QTY_ORD

INV_ITM_TOT_QTY_SHP

INV_ITM_TAX_FLAG_1

INV_ITM_TAX_FLAG_2

INV_ITM_TAX_FLAG_3

INV_ITM_PRICE_ORG

INV_ITM_CPY_TO_BM_FG

INV_ITM_EXPLODE_KIT

INV_ITM_BM_ORDER_NO

INV_ITM_MULT_FTR_FLG

INV_ITM_PRICE_FLAG

INV_ITM_NO_PACKAGE

INV_ITM_PO_XRF_SEQNO

INV_ITM_PROD_CATE

INV_ITM_REASON_CODE

INV_ITM_PRC_LVL_NO

INV_ITM_ORG_BK_ORDNO

INV_ITM_ORG_BK_SEQNO

INV_ITM_STY_TMP_FLAG

INV_ITM_VENDOR_NO

FILLER_001

 

Columns in “Notes” DataTable

NOTE_FILE_REF_NO

NOTE_FOLDER

NOTE_CREATE_DATE

NOTE_CREATE_TIME_HH

NOTE_CREATE_TIME_MM

NOTE_CREATE_TIME_SS

NOTE_TYPE

NOTE_CREATE_BY_USER

NOTE_TASK_STATUS

NOTE_FOLLOWUP_BY_NAM

NOTE_FOLLOWUP_DATE

NOTE_FOLLOWUP_TIME

NOTE_FILE_NAME_ALT

NOTE_FILE_REF_NO_ALT

NOTE_TOPIC

NOTE_CONTENT_1

NOTE_CONTENT_2

NOTE_CONTENT_3

NOTE_CONTENT_4

NOTE_CONTENT_5

NOTE_CONTENT_6

NOTE_CONTENT_7

NOTE_CONTENT_8

NOTE_CONTENT_9

NOTE_CONTENT_10

NOTE_MODIFY_DATE

NOTE_MODIFY_HH

NOTE_MODIFY_MM

NOTE_MODIFY_SS

NOTE_MODIFY_BY_USER

NOTE_READABLE_FLAG

NOTE_CHANGEABLE_FLAG

NOTE_DELETEABLE_FLAG

NOTE_ORIG_FOLL_UP_DT

NOTE_TIME_FOLL_DT_CH

FILLER_001

 

Columns in “InvoiceSerialNo” DataTable

INV_HIS_LS_KEY_55

INV_HIS_LS_ITEM_NO

INV_HIS_LS_S_L_ALT_1

INV_HIS_LS_INV_DATE

INV_HIS_LS_S_L_ALT_2

INV_HIS_LS_T_ITM_NO3

INV_HIS_LS_T_DATE_3

INV_HIS_LS_T_TIME_3

INV_HIS_LS_T_S_NO_3

INV_HIS_LS_TRX_LOT_3

INV_HIS_LS_LOCATION

INV_HIS_LS_QTY

INV_HIS_LS_VE_CUS_NO

INV_HIS_LS_RC_INV_NO

INV_HIS_LS_PO_NO

INV_HIS_LS_BIN_NO

INV_HIS_LS_VEN_CUS_F

FILLER_001

 

Columns in “Payment” DataTable

CPORDPMT_FILE_NAME

CPORDPMT_REF_NO

CPORDPMT_SEQ_NO

CPORDPMT_CUST_NO

CPORDPMT_DOC_DATE

CPORDPMT_DOC_NO

CPORDPMT_DOC_TYPE

CPORDPMT_APPLY_TO_NO

CPORDPMT_PAYMENT_AMT

CPORDPMT_COMMENT_1

CPORDPMT_COMMENT_2

CPORDPMT_CC_APROV_NO

CPORDPMT_CR_CARD_NO

CPORDPMT_CC_EXP_DT

CPORDPMT_CR_CARD_TYP

CPORDPMT_REFERENCE

CPORDPMT_CC_SWIPE_DA

CPORDPMT_PROC_COMPL

CPORDPMT_NAME

CPORDPMT_ADDRESS_1

CPORDPMT_ADDRESS_2

CPORDPMT_CITY

CPORDPMT_STATE

CPORDPMT_ZIP_CODE

CPORDPMT_COUNTRY

CPORDPMT_USER_ID

CPORDPMT_TRX_DATE

CPORDMPT_WORKSTATION

CPORDPMT_SESSION_ID

CPORDPMT_PAYMENT_TYP

CPORDPMT_TRX_TIME

CPORDPMT_SEQ_NO_ALT

CPORDPMT_PAYMENT_SRC

CPORDPMT_ACH_KEY

SYACHACT_FILE_NAME

SYACHACT_CUST_NO

SYACHACT_SHIP_TO_NO

SYACHACT_CREATE_DATE

SYACHACT_CREATE_TIME

SYACHACT_BANK_RTG_NO

SYACHACT_BANK_ACCTNO

SYACHACT_ACCT_NNAME

SYACHACT_MAIN_ACCT

SYACHACT_STATUS

SYACHACT_STS_REASON

SYACHACT_STS_DATE

SYACHACT_STS_TIME

SYACHACT_STS_BY_USER

SYACHACT_STS_BY_WRKS

SYACHACT_LST_TRX_DT

SYACHACT_LST_TRX_AMT

SYACHACT_TRX_SNC_CR

SYACHACT_AMT_SNC_CR

SYACHACT_NO_TRX_YTD

SYACHACT_AMT_YTD

SYACHACT_TRX_LSTYR

SYACHACT_AMT_LSTYR

SYACHACT_TRX_2_YR

SYACHACT_AMT_2_YR

 

Code Example (VB)

The following sample code will return invoice detail for invoice number “639422” and sort returned invoice line items by column INV_ITM_QTY_ORDER.

 

Dim Service As New webServicesInvoiceInquiry.InvoiceInquiry()

Dim Result As New webServicesInvoiceInquiry.GetOneInvoiceDetailResult

Dim invoiceNo As String = “639422”

Dim orderBy As String = “INV_ITM_QTY_ORDER”

Result = Service.GetoneInvoiceDetail(“”, “”,invoiceNo, orderBy)

If Result.ReturnCode = 0 Then

  If Result.InvoiceDetail.Tables("InvoiceLineItem").Rows.Count > 0 Then

     lblResult.Text = “First Line Item is” & _ 

      Result.InvoiceDetail.Tables(“InvoiceLineItem”).Rows(0).Item( _

      "INV_ITM_ITM_NO")

  Else

     lblResult.Text = “No Matching Invoice.”

  End If

Else

  lblResult.Text = “Error While Quering Invoice.”

  lblErrorCode.Text = Result.ToString

End If

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