OrderInquiry

OrderInquiry.asmx

This web service provides the following methods to return orders: 

·        GetOrder

·        GetOneOrderDetail

With a typical eCommerce website, it is necessary to show customers the outstanding orders and status. This would be the web service to use.

This web service uses a PSQL relational engine and thus is more flexible than the original EliOrdIqService. You may use various filters to retrieve desirable data.

For invoice history, use the InvoiceInquiry web service instead.

 

GetOrder

This method returns a list of orders based on the provided parameters. For example, you may specify the customerNo parameters to return a list of orders for a customer.

In most of the string field parameters, you can pass the “%” in the value to make it a like search:

·        customerNo

·        PONo

·        shipToNo

·        salesmanNo

For example, if you specify the PONo field as “567890%” then it will return all sales orders with a PO number starting with “567890.“  You could also use “%567890%,” after which it will return all sales orders with a PO number containing the value of “567890.”

Usage:

GetOrderResult = A.GetOrder(UserName, UserPassword, detailLevel, numberOfRecords, customerNo, orderNo, orderType, excludePostFlag, startOrderDate, endOrderDate, PONo, shipToNo, salesmanNo, type, orderBy, addidtionalWhereCluse)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Length

Type

Upper

Detail

detailLevel

 

String

 

This field is not used at this moment.

numberOfRecords

 

Integer

 

Maximum number of returned records. If this field is not specified, system will return all matching records.

customerNo

6

String

 

Customer number. System will automatically pad zeros to customer number. For example, if you pass “1,” it will be padded as “000001.”

orderNo

6

Prior to V8.5: Integer

V8.5 and Above: String

 

Required. This is order number.

orderType

 

String

 

This is the sales order type like “O,” “I,” “C,” “Q” and “B.” The value here can be multiple order types separated by a space.

excludePostFlag

1

String

 

“Y” (default): Exclude posted orders.

“N”: Do not exclude posted orders.

startOrderDate

 

Date

 

If you choose to show posted orders, then it may make sense to assign a value here for performance reasons. In that case, this method will only return records with order date >= startOrderDate.

endOrderDate

 

Date

 

For intranet application, salesman may want to see orders for prior month, prior week, etc. If you assigned a value here, this method will only return records with order date <= endOrderDate.

PONo

25

String

 

Purchase order number.

shipToNo

4

String

 

Specify the Ship-to number to limit the orders for this ship-to only.  For example, if you are a store manager of a large chain store, you should only be able to see the orders for your store (ship-to), not the entire chain (customer).  If the login eContact is attached to a ship-to (CPSHPFIL), then you should use this filter.

salesmanNo

3

String

 

You may use this filter if the login eContact is a salesman since you don’t want to show other salesman’s orders. If the value is numeric, system automatically pads leading zeros to this field.

type

1

String

Y

This can be one of the following:

“B” (Default): Get the order information from both Elliott CPORDHDR table and audit WSORDHDR table.

“E”: Only get from Elliott order table CPORDHDR.

“P”: Only get from audit table WSORDHDR

You normally would use “E” here. However, there are some special situations where you want to retrieve orders from the audit table too. Specifically, if an order was written to the audit table but not to the Elliott order table. For example, when you are writing an admin function where you allow staff to fix and retry order creation on previous failed orders.

orderBy

 

String

 

Default to "ORDER_DATE DESC, ORDER_NO DESC." You can specify any fields in CPORDHDR table in this SQL ORDER BY format.

additionalWhereClause

 

String

 

You can specify any additional filters with CPORDHDR able in SQL WHERE clause format.  This filter will be appended to the WHERE clause with AND condition.  For example, you can pass “ORDER_DATE_PICKED > 0” to only show the orders that have been printed with pick tickets.

 

GetOrderResult Structure

Property Name

Type

Detail

ReturnCode

Integer

0 = OK

10001 = Missing Order No.

10002 = Invalid Type

OrderHeaders

DataSet

This data set contains one data table. When input type is “E” or “P,” the table name is “OrderHeaders”; when input “type” is “B,” the table name is “ElliottOrdHdr.”

NumberOfRecordsFound

Integer

Number of records found in order headers.

 

Columns in DataTables

 

The returned data tables have the following columns. For detailed information on each column, please refer to “Input Parameter” section of ViewOrder method in EliOrderService web service:

·        ORDER_NO

·        ORDER_DATE_ENTERED

·        ORDER_DATE

·        ORDER_TYPE

·        ORDER_APPLY_TO_NO

·        ORDER_PURCH_ORDER_NO

·        ORDER_CUSTOMER_NO

·        ORDER_NO_ALT

·        ORDER_CUST_BALANCE

·        ORDER_BILL_TO_NAME

·        ORDER_BILL_TO_ADDR_1

·        ORDER_BILL_TO_ADDR_2

·        ORDER_BILL_TO_CITY

·        BILL_TO_FILLER_1

·        ORDER_BILL_TO_ST

·        BILL_TO_FILLER_2

·        ORDER_BILL_TO_ZIPCD

·        ORD_BILL_TO_COUNTRY

·        ORDER_SHIP_TO_NO

·        ORDER_SHIP_TO_NAME

·        ORDER_SHIP_TO_ADDR_1

·        ORDER_SHIP_TO_ADDR_2

·        ORDER_SHIP_TO_CITY

·        SHIP_TO_FILLER_1

·        ORDER_SHIP_TO_ST

·        SHIP_TO_FILLER_2

·        ORDER_SHIP_TO_ZIPCD

·        ORD_SHIP_TO_COUNTRY

·        ORDER_SHIPPING_DATE

·        ORDER_SHIP_VIA_CODE

·        ORDER_TERMS_CODE

·        ORDER_FRGHT_PAY_CODE

·        ORDER_SHIP_INSTRUC1

·        ORDER_SHIP_INSTRUC2

·        ORDER_SALESMAN_NO_1

·        ORDER_SLS_PCT_COMM_1

·        ORDER_SLS_COMM_AMT_1

·        ORDER_SALESMAN_NO_2

·        ORDER_SLS_PCT_COMM_2

·        ORDER_SLS_COMM_AMT_2

·        ORDER_SALESMAN_NO_3

·        ORDER_SLS_PCT_COMM_3

·        ORDER_SLS_COMM_AMT_3

·        ORDER_TAX_CODE_1

·        ORDER_TAX_PERCENT_1

·        ORDER_TAX_CODE_2

·        ORDER_TAX_PERCENT_2

·        ORDER_TAX_CODE_3

·        ORDER_TAX_PERCENT_3

·        ORDER_DISC_PERCENT

·        ORDER_JOB_NO

·        ORDER_MFGING_LOC

·        ORDER_PROFIT_CENTER

·        ORDER_DEPARTMENT

·        ORDER_AR_REFERENCE

·        ORDER_TOTAL_SALE_AMT

·        ORDER_TOTL_TAXBL_AMT

·        ORDER_TOTAL_COST

·        ORDER_TOTAL_WEIGHT

·        ORDER_MISC_CHRG_AMT

·        ORD_MISC_CHRG_ACT_NO

·        ORD_FREIGHT_AMOUNT

·        ORD_FREIGHT_ACT_NO

·        ORD_SALES_TAX_AMT_1

·        ORD_SALES_TAX_AMT_2

·        ORD_SALES_TAX_AMT_3

·        ORDER_COMM_PERCENT

·        ORDER_COMM_AMOUNT

·        ORDER_COMMENT1

·        ORDER_COMMENT2

·        ORDER_COMMENT3

·        ORDER_PAYMENT_AMOUNT

·        ORDER_PAYMNT_DIS_AMT

·        ORDER_CHECK_NO

·        ORDER_CHECK_DATE

·        ORDER_CASH_ACT_NO

·        ORDER_DATE_PICKED

·        ORDER_DATE_BILLED

·        ORDER_INVOICE_NO

·        ORDER_INVOICE_DATE

·        ORDER_SELECTION_CODE

·        ORDER_POSTED_DATE

·        ORDER_PART_PSTED_FLG

·        ORDSHPTO_FRE_FRM_FLG

·        ORDBILTO_FRE_FRM_FLG

·        ORDER_COPY_TO_BM_FLG

·        ORDER_EDI_FLAG

·        ORDER_CLOSED_FLAG

·        ORDER_ACC_MISC_AMT

·        ORDER_ACC_FREIGHT

·        ORDER_ACC_TOT_TAXBLE

·        ORDER_ACC_SALES_TAX

·        ORDER_ACC_TOT_SALES

·        ORDER_STORE_NO

·        ORDER_BILL_TO_NO

·        ORDER_RMA_STATUS

·        ORDER_PHANTM_INV_FLG

·        ORDER_DEPT_NO

·        ORDER_BOL_PRINTED

·        ORDER_ORGIN_INV_NO

·        ORDER_PAYMENT_TP

·        ORDER_EDI_EXP_FLG

·        ORDER_BOL_NO

·        ORDER_SHIP_ACK_DATE

·        ORDER_PO_REQ_GEN_FL

·        ORDER_PICK_TICK_CUT

·        ORDER_ORD_EDI_EXP_F

·        ORDER_FILLER_001

·        ORDER_SHIP_TO_XREF

·        ORDER_856_EXP_FLG

·        ORDER_ORD_ACK_SENT

·        ORDER_FILLER_002

 

If the input “type” parameter is “P,” the returned data table will contain the above columns, along with the following columns. For detailed information on each column, please refer to the “CreateOrderInput Structure” section of CreateOrder method in EliOrderService web service:

·        OrderID

·        ContactID

·        CreateDate

·        ApprovalID

·        Phone

·        DisplayFreight

·        DisplayTax

·        DisplayMisc

·        DisplayAmtPaid

·        DisplayTaxPercent1

·        DisplayTaxPercent2

·        DisplayTaxPercent3

·        Deleted

·        OrderInstruction

·        IPAddress

·        WebSiteURL

·        HeaderError

·        FinishError

·        ContactError

 

Code Example (VB)

The following sample code will return all open orders for customer “000001” and ship-to “100” where the order type is either “O” or “I.”

 

Dim Service As New webServicesOrderInquiry.OrderInquiry()

Dim Result As New webServicesOrderInquiry.GetOrderResult

Dim customerNo As String = “000001”

Dim orderType As String = “O I”

Dim shipToNo As String = “100”

Dim type As String = “E”

Result = Service.GetOrder(“”,“”, “”, “”, customerNo, “”, orderType, “”, Nothing, Nothing, “”, shipToNo, “”, type, “”, “”)

If Result.ReturnCode = 0 Then

  If Result.NumberOfRecordsFound > 0 Then

     lblResult.Text = “First Order# is” & _ 

      Result.OrderHeaders.Tables(“OrderHeaders”).Rows(0).Item( _

      "ORDER_NO")

  Else

     lblResult.Text = “No Matching Order.”

  End If

Else

  lblResult.Text = “Error While Quering Order.”

  lblErrorCode.Text = Result.ToString

End If

  

Assuming you want to get only picked items for a certain store (Ship-to# 100), you can use the following code:

Dim Service As New webServicesOrderInquiry.OrderInquiry()

Dim Result As New webServicesOrderInquiry.GetOrderResult

Dim customerNo As String = “000001”

Dim orderType As String = “O I”

Dim shipToNo As String = “100”

Dim type As String = “E”

Dim addidtionalWhereCluse As String = “ORDER_DATE_PICKED > 0”

Result = Service.GetOrder(“”,“”, “”, “”, customerNo, “”, orderType, “”, “”, “”, “”, shipToNo, “”, type, “”, addidtionalWhereCluse)

If Result.ReturnCode = 0 Then

  If Result.NumberOfRecordsFound > 0 Then

     lblResult.Text = “First Order# is” & _ 

      Result.OrderHeaders.Tables(“OrderHeaders”).Rows(0).Item( _

      "ORDER_NO")

  Else

     lblResult.Text = “No Matching Order.”

  End If

Else

  lblResult.Text = “Error While Quering Order.”

  lblErrorCode.Text = Result.ToString

End If

 

GetOneOrderDetail

This method runs in a relational engine. It returns one order’s detailed information, including order header, line items, order notes, customer notes, item notes, line item notes, serial number, and order contact.

Usage:

GetInvoiceDetailResult = A.GetOneOrderDetail(UserName, UserPassword, orderNo, dataSource, orderBy)

Parameters UserName and UserPassword are not used at this moment.

 

Input Parameters

Parameter

Type

Upper

Detail

orderNo

Prior to V8.5: Integer

V8.5 and Above: String

 

Required.

dataSource

String

Y

Required.

“ELLIOTT” (Default): Get orders from database table “CPORDHDR” and “CPORDLIN.”

“PSQL”: Get orders from database table “WSORDHDR” and “WSORDLIN” for auditing information.

orderBy

String

 

Can be empty or one of the fields in returned “OrderLineItems” data table.

 

GetOneOrderDetailResult Structure

Property Name

Type

Detail

ReturnCode

Integer

0 = OK

10001 = Missing Order No.

10003 = Invalid Data Source

OrderDetail

DataSet

This DataSet contains the following tables: "OrderHeaders," "OrderLineItems," "Notes," "CustomerNotes," "ItemNotes," "LineItemNotes," "SerialNo," “OrderContact,”

 

Column in Data Tables

dataSource = “ELLIOTT”

dataSource = “PSQL”

Table “OrderHeader” – see EliOrderService for more detail explains on these columns:

ORDER_NO

ORDER_DATE_ENTERED

ORDER_DATE

ORDER_TYPE

ORDER_APPLY_TO_NO

ORDER_PURCH_ORDER_NO

ORDER_CUSTOMER_NO

ORDER_NO_ALT

ORDER_CUST_BALANCE

ORDER_BILL_TO_NAME

ORDER_BILL_TO_ADDR_1

ORDER_BILL_TO_ADDR_2

ORDER_BILL_TO_CITY

BILL_TO_FILLER_1

ORDER_BILL_TO_ST

BILL_TO_FILLER_2

ORDER_BILL_TO_ZIPCD

ORD_BILL_TO_COUNTRY

ORDER_SHIP_TO_NO

ORDER_SHIP_TO_NAME

ORDER_SHIP_TO_ADDR_1

ORDER_SHIP_TO_ADDR_2

ORDER_SHIP_TO_CITY

SHIP_TO_FILLER_1

ORDER_SHIP_TO_ST

SHIP_TO_FILLER_2

ORDER_SHIP_TO_ZIPCD

ORD_SHIP_TO_COUNTRY

ORDER_SHIPPING_DATE

ORDER_SHIP_VIA_CODE

ORDER_TERMS_CODE

ORDER_FRGHT_PAY_CODE

ORDER_SHIP_INSTRUC1

ORDER_SHIP_INSTRUC2

ORDER_SALESMAN_NO_1

ORDER_SLS_PCT_COMM_1

ORDER_SLS_COMM_AMT_1

ORDER_SALESMAN_NO_2

ORDER_SLS_PCT_COMM_2

ORDER_SLS_COMM_AMT_2

ORDER_SALESMAN_NO_3

ORDER_SLS_PCT_COMM_3

ORDER_SLS_COMM_AMT_3

ORDER_TAX_CODE_1

ORDER_TAX_PERCENT_1

ORDER_TAX_CODE_2

ORDER_TAX_PERCENT_2

ORDER_TAX_CODE_3

ORDER_TAX_PERCENT_3

ORDER_DISC_PERCENT

ORDER_JOB_NO

ORDER_MFGING_LOC

ORDER_PROFIT_CENTER

ORDER_DEPARTMENT

ORDER_AR_REFERENCE

ORDER_TOTAL_SALE_AMT

ORDER_TOTL_TAXBL_AMT

ORDER_TOTAL_COST

ORDER_TOTAL_WEIGHT

ORDER_MISC_CHRG_AMT

ORD_MISC_CHRG_ACT_NO

ORD_FREIGHT_AMOUNT

ORD_FREIGHT_ACT_NO

ORD_SALES_TAX_AMT_1

ORD_SALES_TAX_AMT_2

ORD_SALES_TAX_AMT_3

ORDER_COMM_PERCENT

ORDER_COMM_AMOUNT

ORDER_COMMENT1

ORDER_COMMENT2

ORDER_COMMENT3

ORDER_PAYMENT_AMOUNT

ORDER_PAYMNT_DIS_AMT

ORDER_CHECK_NO

ORDER_CHECK_DATE

ORDER_CASH_ACT_NO

ORDER_DATE_PICKED

ORDER_DATE_BILLED

ORDER_INVOICE_NO

ORDER_INVOICE_DATE

ORDER_SELECTION_CODE

ORDER_POSTED_DATE

ORDER_PART_PSTED_FLG

ORDSHPTO_FRE_FRM_FLG

ORDBILTO_FRE_FRM_FLG

ORDER_COPY_TO_BM_FLG

ORDER_EDI_FLAG

ORDER_CLOSED_FLAG

ORDER_ACC_MISC_AMT

ORDER_ACC_FREIGHT

ORDER_ACC_TOT_TAXBLE

ORDER_ACC_SALES_TAX

ORDER_ACC_TOT_SALES

ORDER_STORE_NO

ORDER_BILL_TO_NO

ORDER_RMA_STATUS

ORDER_PHANTM_INV_FLG

ORDER_DEPT_NO

ORDER_BOL_PRINTED

ORDER_ORGIN_INV_NO

ORDER_PAYMENT_TP

ORDER_EDI_EXP_FLG

ORDER_BOL_NO

ORDER_SHIP_ACK_DATE

ORDER_PO_REQ_GEN_FL

ORDER_PICK_TICK_CUT

ORDER_ORD_EDI_EXP_F

ORDER_FILLER_001

ORDER_SHIP_TO_XREF

ORDER_856_EXP_FLG

ORDER_ORD_ACK_SENT

ORDER_FILLER_002

Table “OrderHeaders”:

Contains the same columns as left side, and also the following columns:

OrderID

ContactID

CreateDate

ApprovalID

Phone

DisplayFreight

DisplayTax

DisplayMisc

DisplayAmtPaid

DisplayTaxPercent1

DisplayTaxPercent2

DisplayTaxPercent3

Deleted

OrderInstruction

OrderTimeRelease

ErrorDupPOFlag

UseAutoFreight

UserAutoMiscChrg

CustomerEmail

IPAddress

WebSiteURL

HeaderError

FinishError

ContactError

Table “OrderLineItems” – See EliOrderService for more detailed explanations of these columns:

LINE_ITM_ORDER_NO

LINE_ITM_SEQ_NO

LINE_ITM_ITEM_NO

LINE_ITM_ORD_NO_ALT1

LINE_ITM_ORD_NO_ALT2

LINE_ITM_PICK_SEQ

LINE_ITM_DESC1

LINE_ITM_DESC2

LINE_ITM_SERL_LOT_NO

LINE_ITM_SER_EFF_DT

LINE_ITM_LOT_EXP_CN

LINE_ITM_LOT_EXP_YR

LINE_ITM_LOT_EXP_MN

LINE_ITM_LOT_EXP_DAY

LINE_ITM_QTY_ORDRD

LINE_ITM_QTY_TO_SHIP

LINE_ITM_UNIT_PRICE

LINE_ITM_DISC_PCT

LINE_ITM_REQST_DATE

LINE_ITM_QTY_BCK_ORD

LINE_QTY_RET_TO_STCK

LINE_ITM_BACKORD_FG

LINE_ITM_UOM

LINE_ITM_UNIT_COST

LINE_ITM_UNIT_WEIGHT

LINE_COMM_CALC_TYPE

LINE_COMM_PCT_OR_AMT

LINE_ITM_PROMISE_DT

LINE_ITM_TAXABLE_FG

LINE_ITM_STOCKED_FG

LINE_ITM_CONTRL_FG

LINE_ITM_SELECT_CD

LINE_TOTAL_QTY_ORDRD

LINE_TOTAL_QTY_SHIPD

LINE_ITM_TAXBLE_FLG1

LINE_ITM_TAXBLE_FLG2

LINE_ITM_TAXBLE_FLG3

LINE_ITM_PRICE_ORG

LINE_ITM_CPY_TO_BM_F

LINE_ITM_EXPLODE_KIT

LINE_ITM_BM_ORDER_NO

LINE_ITM_MUL_FTR_FG

LINE_ITM_PRC_FIXD_FG

LINE_ITM_NO_PACKAGE

LINE_ITM_PO_XR_SEQNO

LINE_ITM_PROD_CATE

LINE_ITM_REASON_CODE

LINE_ITM_PRC_LVL_NO

LINE_ITM_BKT_ORD_NO

LINE_ITM_BKT_SEQ_NO

LINE_ITM_STLY_TMP_FG

LINE_ITM_VENDOR_NO

LINE_ITM_ORG_ITM_NO

LINE_ITM_EDI_TURNAR

LINE_ITM_CANCEL_CLS

ITEM_PRICE_RATIO

ITEM_PRICE_UOM

ITEM_ORDER_MULTIPLE

ITEM_USER_AMOUNT

Table “OrderLineItems”:

Contains the same columns as left side, and also the following columns:

OrderItemID

OrderID

DisplayUnitPrice

Deleted

LineError

IMHLTFIL_TRX_ID

Table  "Notes," "CustomerNotes," "ItemNotes" and "LineItemNotes":

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

Table "Notes," "CustomerNotes," "ItemNotes" and "LineItemNotes":

Contains the same columns as left side.

 

Table “SerialNo” – see EliOrderService for more detailed explanations of these columns:

ORD_LINE_LS_ORD_NO

ORD_LINE_LS_LIN_NO

ORD_LINE_LS_S_L_NO

ORD_LINE_LS_ITEM_NO

ORD_LINE_LS_S_L_ALT

ORD_LINE_LS_QTY

ORD_LINE_LS_BIN_NO

FILLER_001

Table “SerialNo”:

Contains the same columns as left side.

 

Table “OrderContact” – see EliecontService for more detailed explanations of these columns:

SYCONTCT_ID

SYCONTCT_EMAIL_ADDR

SYCONTCT_NAME

SYCONTCT_LNK_ADR_FLG

SYCONTCT_ADDR_1

SYCONTCT_ADDR_2

SYCONTCT_CITY

SYCONTCT_STATE

SYCONTCT_ZIP

SYCONTCT_COUNTRY

SYCONTCT_LNK_TEL_FLG

SYCONTCT_PHONE

SYCONTCT_PHONE_EXT

SYCONTCT_LNK_FAX_FLG

SYCONTCT_FAX

SYCONTCT_PASSWD_HINT

SYCONTCT_PASSWD_HT_V

SYCONTCT_BLK_ACCESS

SYCONTCT_BLK_REASON

SYCONTCT_BLK_ACCS_DT

SYCONTCT_BLK_EMAIL

SYCONTCT_BLK_EM_DT

SYCONTCT_FILLER_01

SYCONTCT_BILLTO_NAME

SYCONTCT_FILLER_02

SYCONTCT_LNK_BT_ADR

SYCONTCT_BT_ADDR_1

SYCONTCT_BT_ADDR_2

SYCONTCT_BT_CITY

SYCONTCT_BT_STAT

SYCONTCT_BT_ZIP

SYCONTCT_BT_COUNTRY

SYCONTCT_SRCH_NAME

SYCONTCT_CREATE_DT

SYCONTCT_CREATE_TIME

SYCONTCT_Accept_HTML

SYCONTCT_HOME_PHONE

SYCONTCT_MOBIL_PHONE

SYCONTCT_BOUNCEBACKS

SYCONTCT_COMPANY_NA

SYCONTCT_BIRTH_YEAR

SYCONTCT_BIRTH_MON

SYCONTCT_BIRTH_DAY

SYCONTCT_CREATED_BY

SYCONTCT_FILLER_03

There is no data table “OrderContact” when dataSource = “PSQL.”

 

Table “Payment” – see EliarachService for a more detailed explanation of these columns:

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

 

Table “OrderContact”:

Contains the same columns as left side.

 

 

Code Example (VB)

The following sample code will return order detail for order number “157896.”

 

Dim Service As New webServicesOrderInquiry.OrderInquiry()

Dim Result As New webServicesOrderInquiry. GetOneOrderDetailResult

Dim orderNo As Integer = 157896

Result = Service.GetOneOrderDetail(“”, “”, orderNo, “”, “”)

If Result.ReturnCode = 0

  If Result.OrderDetail.Tables("OrderLineItems").Rows.Count > 0 Then

      lblResult.Text = "First Order Line Item is" & _

      Result.OrderDetail.Tables("OrderLineItems").Rows(0).Item( _

      "LINE_ITM_ITEM_NO")

  Else

      lblResult.Text = "No Line Item Found"

  End If

Else

  lblResult.Text = “Error While Querying Order.”

  lblErrorCode.Text = Result.ReturnCode.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