List Customers

Data Listing: Customer Lookup

Enter a message to start chatting with the assistant
Suggestions on what to ask:
"When was the last time All Weather Cycles placed an Order"
"What is the status of Order #400428 ? "
"What items were shipped out for Order #700123?"
"Tell me more about Crazybikes"
"Who can I contact to learn more about m-Power?"

AI is thinking...

Drag and drop documents here or browse

Supported formats: PDF, DOCX, TXT, CSV, JSON, XML (Max 50MB)

Press Enter to send

StatementCallback; SQL [SELECT T01.`CUSNO`, T01.`CNAME`, T02.`SNAME`, T01.`COUNTRY`, ( CASE WHEN T01.`CR` = '5' THEN '5.gif' WHEN T01.`CR` = '4' THEN '4.gif' WHEN T01.`CR` = '3' THEN '3.gif' WHEN T01.`CR` = '2' THEN '2.gif' WHEN T01.`CR` = '1' THEN '1.gif' ELSE '0.gif' END) , T01.`YTDSALES`, T01.`CADD1`, T01.`CADD2`, T01.`CADD3`, T01.`CADD4`, T01.`CSTTE`, T01.`CZIPC`, T01.`CNTAC`, T01.`SALNO`, T01.`CR`, (T01.`YTDSALES`/8000) , (1) FROM CRAZYBIKES.`DMCMP100` T01 left outer join CRAZYBIKES.`SALESMAST` T02 ON T01.`SALNO`=T02.`SALNO` ORDER BY T01.`CNAME` ASC limit 11]; The last packet successfully received from the server was 94,490,952 milliseconds ago. The last packet sent successfully to the server was 94,490,958 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.

View Orders	Customer Number	Customer Name	Salesman	Country	Credit Rating	YTD Sales

Rows per Page

Data Selections

Field	Value
Customer Number	CT 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	CT 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 Rating	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	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
YTD Sales	GE 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

Multiple Column Sort

Load Saved Search

List Customers: Selections