Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: shahiderp »Table: rental_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 (3485 total, Query took 0.0009 seconds.)
SELECT * FROM `rental_invoice_master`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsInvoice_IdQuote_IdInvoice_seqidInvoice_genidmasterinvoiceidInvoice_NoCust_NoCust_RefIdateQdateinvoice_Totalinvoice_Discountt_remarksinvoice_transportationinvoice_vatrateinvoice_vatamtinvoice_roundamtinvoice_Grand_Totald_remarksinvoice_dismatlingNote1Note2Payment_TermsEstimated_dateValidityDeliveryLPO_NoAvailabilityQStatusCreateUserCreateTimeInvoice_Ageinvoice_startdateEstimated_productInvoice_proView_detailsmodifyusermodifytimedelivery_countrydelivery_statesdelivery_cityDostatuspriorityinvoice_paymentstatuscommentcredit_note
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 1
1 101 0 0 SRIS6/160320/1 4313 Email Inquiry 2016-03-20 2016-03-16 495.00 0.00 0.00 0 0.00 495.00 0.00 Cash/CDC with the Confirmation Order 2017-01-01 Cheque 4500 AED without date Refundable Jebel Ali Free Zone Telephonic Confirmation Active 6 NULL Final 2016-03-20 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 3
3 124 0 0 SRIS2/160331/3 4993 Telephonic Inquiry 2016-03-31 2016-03-31 260.00 0.00 To DIP, 1 Time Delivery & 1 Time Pick only 400.00 0 0.00 660.00 0.00 Cash/CDC with the Confirmation Order 2017-01-01 Cheque 6000 AED without date Refundable Jabal Ali Emial Confirmation Active 2 NULL Final 2016-03-31 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 4
4 116 0 0 SRIS6/160402/4 3334 Telephonic Inquiry 2016-04-02 2016-03-29 3400.00 0.00 0.00 0 0.00 3400.00 0.00 Cash 2017-01-01 Cheque 13000 AED without date Refundable Jabal Ali 2101 Active 6 NULL Final 2016-04-02 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 5
5 113 0 0 SRIS5/160403/5 1584 Email Inquiry 2016-04-03 2016-03-27 1000.00 0.00 To Mall of Emirates, 1 Time Delivery & 1 Time Pick... 300.00 0 0.00 1300.00 0.00 As Before 2017-01-01 Rental Agreement Mall of Emirates 00-112780 Active 5 NULL Final 2016-04-03 2017-01-01 Complete View Details 0 0 0 Complete No Received
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 6
6 127 0 0 SRIS6/160403/6 5055 Telephonic Inquiry 2016-04-03 2016-04-02 1350.00 150.00 0.00 0 0.00 1200.00 0.00 Cash 2017-01-01 Cheque 9500 AED without date Refundable Sharjah Meeting Confirmation Active 6 NULL Final 2016-04-03 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 7
7 128 0 0 SRIS5/160403/7 2190 Telephonic Inquiry 2016-04-03 2016-04-03 250.00 0.00 To Dubai, 1 Time Delivery & Pickup Only 200.00 0 0.00 450.00 0.00 30 days pdc 2017-01-01 Cheque 2300 AED without date Refundable Deira City Center EI10932 Active 5 NULL Final 2016-04-03 2017-01-01 Complete View Details 0 0 0 Complete No Received
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 8
8 106 0 0 SRIS6/160407/8 4580 Telephonic Inquiry 2016-04-07 2016-03-21 2710.00 200.00 0.00 0 0.00 2510.00 0.00 Cash 2017-01-01 Cheque 6500 AED without date Refundable Palm Jumairah Emial Confirmation Active 6 NULL Final 2016-04-07 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 9
9 151 0 0 SRIS6/160417/9 5487 Telephonic Inquiry 2016-04-17 2016-04-16 450.00 0.00 To Ras Al Khaimah, 1 Time Delivery & Pickup Only 600.00 0 0.00 1050.00 0.00 Cash 2017-01-01 Cheque 3500 AED without date Refundable Ras Al Khaima Meeting Confirmation Active 6 NULL Final 2016-04-17 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 10
10 133 0 0 SRIS3/160602/10 5651 Telephonic Inquiry 2016-06-02 2016-04-05 12840.00 2890.00 To Dubai Festival City, 1 Time Delivery & Pickup O... 0.00 0 0.00 9950.00 0.00 30 days pdc 2017-01-01 Cheque 15000 AED without Date Refundable Festival City EI10979 Active 6 NULL Final 2016-06-02 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 11
11 158 0 0 SRIS2/160420/11 1159 Telecom Discussion 2016-04-20 2016-04-20 900.00 0.00 delivery to Emirates Tower 300.00 0 0.00 1200.00 0.00 Cash 2017-01-01 10000 security cheque refundable Emirates Towers Telephonic Confirmation Active 2 NULL Final 2016-04-20 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 13
13 162 0 0 SRIS5/160423/13 1431 Email Inquiry 2016-04-23 2016-04-23 1450.00 250.00 To Jabel Ali, 1 Time Delivery & Pickup Only 400.00 0 0.00 1600.00 0.00 Cash/CDC 2017-01-01 Cheque 7000 AED without date Refundable Jabal Ali 1 Active 5 NULL Final 2016-04-23 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 14
14 165 0 0 SRIS6/160428/14 1936 Email Inquiry 2016-04-28 2016-04-24 3200.00 400.00 To Dubai, 1 Time Delivery & Pickup Only 600.00 0 0.00 3400.00 0.00 60 Days PDC 2017-01-01 Rental Agreement Techno Park 1831 Active 6 NULL Final 2016-04-28 2017-01-01 Complete View Details 0 0 0 Complete No Received
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 15
15 177 0 0 SRIS6/160503/15 5990 Telephonic Inquiry 2016-05-03 2016-05-02 975.00 0.00 To Dubai, 1 Time Delivery & Pickup Only 0.00 0 0.00 975.00 0.00 Cash 2017-01-01 Rental Agreement Ex. Works Sharjah JO6147 Active 6 NULL Final 2016-05-03 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 16
16 183 0 0 SRIS3/160504/16 2460 Email Inquiry 2016-05-04 2016-05-04 1500.00 0.00 To Jumeirah, 1 Time Delivery  Only 300.00 0 0.00 1800.00 0.00 CDC Cheque 2017-01-01 Cheque 6000 AED without date Refundable Jumairah email confirmation Active 3 NULL Final 2016-05-04 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 18
18 194 0 0 SRIS6/160510/18 4878 Telephonic Inquiry 2016-05-10 2016-05-09 450.00 0.00 To Jabel Ali, 1 Time Delivery & Pickup Only 450.00 0 0.00 900.00 0.00 30 days pdc 2017-01-01 Cheque 5000 AED without date Refundable Jabal Ali Free Zone 016/J83/659 Active 6 NULL Final 2016-05-10 2017-01-01 Complete View Details 0 0 0 Complete No Received
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 19
19 163 0 0 SRIS6/160510/19 5728 Telephonic Inquiry 2016-05-10 2016-04-23 190.00 0.00 0.00 0 0.00 190.00 0.00 Cash 2017-01-01 Emirates ID Ex. Works Sharjah Telephonic Confirmation Active 6 NULL Final 2016-05-10 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 20
20 193 0 0 SRIS6/160515/20 1482 Email Inquiry 2016-05-15 2016-05-15 1480.00 80.00 Transportation Charges to Sharjah (1 Time Delivery... 350.00 0 0.00 1750.00 0.00 Cash/CDC 2017-01-01 Cheque 10,000 AED without date Refundable Sharjah email confirmation Active 6 NULL Final 2016-05-15 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 22
22 211 0 0 SRIS6/160521/22 6275 Email Inquiry 2016-05-21 2016-05-19 460.00 0.00 To Dubai, 1 Time Delivery & Pickup Only 400.00 0 0.00 860.00 0.00 CDC Cheque 2017-01-01 Cheque 5500 AED without date Refundable Al Qouz CF/16 Active 6 NULL Final 2016-05-21 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 23
23 217 0 0 SRIS3/160523/23 6326 Email Inquiry 2016-05-23 2016-05-23 1130.00 0.00 To Dubai, 1 Time Delivery & Pickup Only 800.00 0 0.00 1930.00 0.00 30 days pdc 2017-01-01 Rental Agreement Abu Dhabi Emirates Palace 2087 Active 3 NULL Final 2016-05-23 2017-01-01 Complete View Details 0 0 0 Complete No Received
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 24
24 223 0 0 SRIS6/160528/24 1286 Telephonic Inquiry 2016-05-28 2016-05-25 3980.00 0.00 To Abu Dhabi, 2 Time Delivery & 2 Time Pick only 1200.00 0 0.00 5180.00 0.00 Cash 2017-01-01 Cheque 5500 AED without date Refundable Abu Dhabi
 Emial Confirmation Active 6 NULL Final 2016-05-28 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 25
25 235 0 0 SRIS6/160531/25 6441 Meeting Inquiry 2016-05-31 2016-05-31 1850.00 0.00 0.00 0 0.00 1850.00 0.00 Cash/CDC with the Confirmation Order 2017-01-01 Cheque 6000 AED without date Refundable Meeting Confirmation Active 6 NULL Final 2016-05-31 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 26
26 224 0 0 SRIS6/160601/26 3691 Email Inquiry 2016-06-01 2016-05-26 2025.00 0.00 To Jabel Ali, 1 Time Delivery & Pickup Only 300.00 0 0.00 2325.00 0.00 Cash/CDC with the Confirmation Order 2017-01-01 Cheque 6500 AED without date Refundable Jabal Ali Free Zone Emial Confirmation Active 6 NULL Final 2016-06-01 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 28
28 228 0 0 SRIS5/160601/28 6414 Telephonic Inquiry 2016-06-01 2016-05-29 435.00 0.00 To Dubai, 1 Time Delivery & Pickup Only 700.00 0 0.00 1135.00 0.00 CDC Cheque 2017-01-01 Cheque 5400 AED without date Refundable Hatta L017/1001 Active 5 NULL Final 2016-06-01 2017-01-01 Complete View Details 0 0 0 Complete No Pending
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 30
30 133 0 0 SRIS3/160602/30 5651 Telephonic Inquiry 2016-06-02 2016-05-15 950.00 0.00 To Dubai Festival City, 1 Time Delivery & Pickup O... 0.00 0 0.00 950.00 0.00 30 days pdc 2017-01-01 Cheque 15000 AED without Date Refundable DFC EI 11546 Active 3 NULL Final 2016-06-02 2017-01-01 Complete View Details 0 0 0 Complete No Received
Edit EditCopy CopyDelete Delete
DELETE FROM `rental_invoice_master` WHERE `rental_invoice_master`.`Invoice_Id` = 31
31 234 0 0 SRIS3/160602/31 6438 Email Inquiry 2016-06-02 2016-05-31 175.00 0.00 To Dubai, 1 Time Delivery & Pickup Only 350.00 0 0.00 525.00 0.00 CDC Cheque 2017-01-01 Cheque 5000 AED without date Refundable Al Qouz Emial Confirmation Active 3 NULL Final 2016-06-02 2017-01-01 Complete View Details 0 0 0 Complete No 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