Order Summary

Order # Summary

StatementCallback; SQL [SELECT T01.`ORDNO`, T01.`LINNO`, T01.`PRDNO`, T04.`DESCP`, T01.`SHPQTY`, T01.`PRICE`, T01.`QTYORD`, T02.`CUSNO`, T02.`CUSPO`, T02.`ORDDAT`, T02.`SHPDAT`, T02.`ORDTYP`, T02.`ORDSTA`, T02.`ORDAMT`, T02.`ORDVIA`, T02.`ORDSTA2`, T03.`CMPNO`, T03.`CNAME`, T03.`CADD1`, T03.`CADD2`, T03.`CADD3`, T03.`CADD4`, T03.`CSTTE`, T03.`CZIPC`, T03.`COUNTRY`, T03.`CNTAC`, T03.`CPHON`, T03.`CCUS#`, T03.`CTYPE`, T03.`CRLIM`, T03.`AMTDU`, T03.`OROPN`, T03.`MTDDL`, T03.`YTDDL`, T03.`MTDTA`, T03.`YTDTA`, T03.`CSL01`, T03.`CSL02`, T03.`CSL03`, T03.`CSL04`, T03.`CSL05`, T03.`CSL06`, T03.`CSL07`, T03.`CSL08`, T03.`CSL09`, T03.`CSL10`, T03.`CSL11`, T03.`CSL12`, T03.`CSL13`, T03.`REGON`, T03.`SALNO`, T03.`SHVIA`, T03.`YTDSALES`, T03.`CR`, T03.`CPHONI`, (T01.`QTYORD`*T01.`PRICE`) FROM CRAZYBIKES.`ORDDETAIL` T01 left outer join CRAZYBIKES.`ORDERHEAD` T02 ON T01.`ORDNO`=T02.`ORDNO` left outer join CRAZYBIKES.`DMCMP100` T03 ON T02.`CUSNO`=T03.`CUSNO` left outer join CRAZYBIKES.`DMPMP100` T04 ON T01.`PRDNO`=T04.`PRDNO` WHERE (T01.`ORDNO`=800591) ORDER BY T01.`ORDNO` ASC,T01.`LINNO` ASC limit 11]; The last packet successfully received from the server was 47,864,186 milliseconds ago. The last packet sent successfully to the server was 47,864,187 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

Order Details

Order #
Customer #
Customer PO
Ordered on
Shipped on
Order Type

Shipment Details

S H I P T O
	C/O

	,
	Ship Via:

Scan QR to show customer map

Product #	Product	Qty	Price	Extended Price
Totals	Qty:		Price:

Rows per Page

Data Selections

Field	Value
Order Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Order Line Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Product #	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Product	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Qty	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Price	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Quantity Ordered	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Purchase Order #	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Order Date	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Ship Date	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Order Type	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Order Status	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Order Amount	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Ship Via	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Ship Type	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Company Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Name	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Address Line 1	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Address Line 2	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Address Line 3	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Address Line 4	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer state	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer zipcode	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Country	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Contact Name	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Phone Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Corporate Customer Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Customer Type	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Credit Limit in dollars	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Outstanding A/R Balance	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Total open orders in dollars	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Month to date discount lost	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Year to date discount lost	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Month to date taxes	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Year to date taxes	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 1 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 2 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 3 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 4 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 5 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 6 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 7 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 8 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 9 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 10 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 11 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 12 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Period 13 Sales - last year	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Sales Region	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Salesman Number	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Ship Via	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
YTD Sales	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
CR	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
CPHONI	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with
Extended Price	EQ Equal To Not Equal To Greater than or equal Greater than Less than or equal Less than In the list Not in the list In the range Not in the range Contains Does not Contain Contains all Contains any Starts with Does not Start with

Navigation Menu

0 Total Items

Navigation Menu

0 Total Items

Multiple Column Sort

Load Saved Search

Order Summary: Selections