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
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