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

Integer

 

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

Integer

 

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

Feedback and Knowledge Base