Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: shahiderp »Table: invoice_master
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database Queried time

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (10405 total, Query took 0.0008 seconds.)
SELECT * FROM `invoice_master`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsInvoice_IdmasterinvoiceidQuote_IdInvoice_NoCust_NoCust_RefIdateQdateinvoice_Totalinvoice_Discountt_remarksinvoice_transportationinvoice_servicesinvoice_servicesamtinvoice_vatrateinvoice_vatamtinvoice_roundamtinvoice_Grand_TotalNote1Note2Payment_TermsEstimated_dateValidityDeliveryLPO_NoAvailabilityQStatusCreateUserCreateTimeInvoice_Agemodifyusermodifytimedelivery_countrydelivery_statesdelivery_cityDostatusQuote_typecommentcredit_noteinvoice_paymentstatus
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 1
1 0 603 SIS6/160323/1 3058 Email Inquiry 2016-03-23 2016-03-21 7456.00 0.00 To Dubai 250.00 0.00 0 0.00 7706.00 Cash/CDC with the Confirmation Order Arabian Ranches AR 0000001397 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 2
2 0 516 SIS6/160324/2 1447 Email Inquiry 2016-03-24 2016-03-03 6800.00 0.00 To Dubai 0.00 0.00 0 0.00 6800.00 Cash/CDC with the Confirmation Order Ex. Works Sharjah SSL/03/014 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 3
3 0 626 SIS5/160326/3 1936 Email Inquiry 2016-03-26 2016-03-26 14100.00 0.00 570.00 0.00 0 0.00 14670.00 30 days pdc 2016-04-26 Techno Park 7445 Active 5 NULL -1 2 2017-12-13 14:45:36 0 0 0 Complete Received
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 4
4 0 634 SIS5/160327/4 4835 Telephonic Inquiry 2016-03-27 2016-03-27 4500.00 0.00 250.00 0.00 0 0.00 4750.00 CDC Cheque Fujairah 1 Active 5 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 5
5 0 521 SIS6/160328/5 2369 Email Inquiry 2016-03-28 2016-03-05 4788.00 288.00 To Dubai 250.00 0.00 0 0.00 4750.00 Cash/CDC with the Confirmation Order DIP CAPO016-00168 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 6
6 0 631 SIS2/160328/6 4818 Telephonic Inquiry 2016-03-28 2016-03-27 16330.00 0.00 To Al Ain 300.00 0.00 0 0.00 16630.00 CDC Cheque Al Ain Hospital 1357 Active 2 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 7
7 0 571 SIS6/160331/7 4308 Email Inquiry 2016-03-31 2016-03-16 6950.00 0.00 To Dubai 0.00 0.00 0 0.00 6950.00 Cash/CDC with the Confirmation Order DIP 300104974 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 8
8 0 586 SIS6/160331/8 4458 Email Inquiry 2016-03-31 2016-03-19 2972.00 122.00 To Fujairah (If Required) 0.00 0.00 0 0.00 2850.00 Cash/CDC with the Confirmation Order Ex. Works Sharjah Telephonic Confirmation Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 9
9 0 600 SIS6/160402/9 4273 Email Inquiry 2016-04-02 2016-03-21 6500.00 0.00 To Sharjah 0.00 0.00 0 0.00 6500.00 Cash/CDC with the Confirmation Order Sharjah Emial Confirmation Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 10
10 0 608 SIS2/160402/10 4622 Email Inquiry 2016-04-02 2016-03-22 4300.00 800.00 To Dubai 0.00 0.00 0 0.00 3500.00 CDC Cheque Dubai 5035801(0)/16 Active 2 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 11
11 0 660 SIS5/160404/11 818 Telephonic Inquiry 2016-04-04 2016-03-31 13870.00 0.00 0.00 0.00 0 0.00 13870.00 CDC Cheque Abu Dhabi 016/400 Active 5 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 12
12 0 340 SIS6/160404/12 1718 Email Inquiry 2016-04-04 2016-01-28 5986.00 0.00 To Dubai 300.00 0.00 0 0.00 6286.00 Cash Al Warqa Telephonic Confirmation Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 13
13 0 651 SIS3/160405/13 918 Email Inquiry 2016-04-05 2016-03-30 22876.00 626.00 to DUBAI 0.00 0.00 0 0.00 22250.00 CDC Cheque Naresh-0506318119 ATGI-PO-MG046-2016 Active 3 NULL -1 0 0 0 Complete Received
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 14
14 0 689 SIS5/160405/14 2305 Email Inquiry 2016-04-05 2016-04-05 7294.00 0.00 0 0.00 0.00 0 0.00 7294.00 50% CDC/50% 30 Day PDC Ex. Works Sharjah Telephonic Confirmation Active 5 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 15
15 0 655 SIS5/160406/15 332 Telephonic Inquiry 2016-04-06 2016-03-30 12400.00 0.00 to DUBAI 400.00 0.00 0 0.00 12800.00 CDC Cheque Jabal Ali 15078 Active 5 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 16
16 0 692 SIS6/160406/16 1718 Telephonic Inquiry 2016-04-06 2016-04-06 3195.00 0.00 To Al Warqa 300.00 0.00 0 0.00 3495.00 Cash Al Warqa 1374r1 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 17
17 0 686 SIS6/160406/17 4818 Telephonic Inquiry 2016-04-06 2016-04-05 15540.00 220.00 To Al Ain 300.00 0.00 0 0.00 15620.00 CDC Cheque Al Ain 1374r1 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 18
18 0 691 SIS6/160406/18 1414 Telephonic Inquiry 2016-04-06 2016-04-05 2986.00 166.00 To Dubai 180.00 0.00 0 0.00 3000.00 Cash/CDC with the Confirmation Order Dubai email confirmation Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 20
20 0 693 SIS6/160407/20 1045 Telephonic Inquiry 2016-04-07 2016-04-06 44200.00 0.00 0.00 0.00 0 0.00 44200.00 30 days pdc AL Habtoor Polo Club 661-16 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 21
21 0 694 SIS6/160407/21 1045 Telephonic Inquiry 2016-04-07 2016-04-06 18500.00 0.00 0.00 0.00 0 0.00 18500.00 Cash/CDC with the Confirmation Order Al Habtoor Polo Club 661-16 Active 6 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 22
22 0 718 SIS5/160410/22 2190 Telephonic Inquiry 2016-04-10 2016-04-10 2848.00 0.00 0 0.00 0.00 0 0.00 2848.00 30 days pdc Sharjah EI10995 Active 5 NULL -1 0 0 0 Complete Received
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 23
23 0 659 SIS5/160411/23 3499 Email Inquiry 2016-04-11 2016-03-30 20342.92 0.00 To Al Ain 400.00 0.00 0 0.00 20742.92 CDC Cheque Al Ain 2016/PO/405 Active 5 NULL -1 0 0 0 Complete Received
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 25
25 0 684 SIS5/160412/25 2245 Telephonic Inquiry 2016-04-12 2016-04-05 1800.00 0.00 To Dubai 0.00 0.00 0 0.00 1800.00 30 Days PDC with the Confirmation Order Jumairah L/16/0056 Active 5 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 26
26 0 725 SIS3/160413/26 5331 Email Inquiry 2016-04-13 2016-04-11 4046.00 50.00 0.00 0.00 0 0.00 3996.00 CDC Cheque Palm Jumairah DR/LPO/007/2016 Active 3 NULL -1 0 0 0 Complete Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `invoice_master` WHERE `invoice_master`.`Invoice_Id` = 27
27 0 735 SIS5/160413/27 3893 Telephonic Inquiry 2016-04-13 2016-04-12 3900.00 0.00 0 0.00 0.00 0 0.00 3900.00 Cash Sharjah Meeting Confirmation Active 5 NULL -1 0 0 0 Complete Pending
With selected: With selected:

|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view