Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: addmrn
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
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 (9297 total, Query took 0.0006 seconds.) [id: 9299... - 9275...]
SELECT * FROM `addmrn` ORDER BY `id`  DESC 

Full texts id Descending Ascending 1 MRNNo MRNVoucherDate MRNDate ReceivedAgainst MaterialReceiptOnBasis rmrs_no StoreCode site StoreName PO_WO_MTO OrderDate ReceivedFrom req_no DocumentType BillNo BillDate GetPassNo Inwardsdate Transp_name VehicleNo TimeIn Timeout LRno LRdate TotalWeight form_type form_no RemarksIfAny Remarks createdby mrnstatus site_name totalqty total_Item_Amount pkg_perc pkg_charges vat_cst vat_cst_val sur_oct_per sur_oct_amt tot_freight add_charges grandtotal round_off order_no Type Cancel_Status OrderFromSite gatepassdate MRVS_status companyID loading workorderno workorderitem userstype CustomDuty custondutyval insurancecharges insurancecharges_amt overseasfrieght overseasfrieght_amt localfreight localfreight_amt clearingforwarding calclearingforwarding_amt detetioncharges detetioncharges_amt othercharges Grn_Type Po_category Modified_by Modified_date duty_type batch_no Approval_status totalRecQty totalBillQty purch_ord_category transaction_time site_tranf_status totalamount cash_payment credit_payment
9299 APH/24-25//0219 2024-07-27 2024-07-29 PO NULLNULL2 APH NULLNULLNULL271 0 Bill 89 NULL6971 NULL0 Day 11:35:43 2024-07-29 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9851 DO N NULL2024-07-29 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 10200.00 10200.00 NULL2024-07-29 11:37:03 NULLNULL0.00 0.00
9298 APH/24-25//0218 2024-07-25 2024-07-29 PO NULLNULL2 APH NULLNULLNULL7 0 Bill IL24-00939 NULL6972 NULL0 Day 10:11:54 2024-07-29 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9850 DO N NULL2024-07-29 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 700.00 700.00 NULL2024-07-29 10:14:48 NULLNULL0.00 0.00
9297 AEH/24-25//0304 2024-06-28 2024-07-27 PO NULLNULL1 AEH NULLNULLNULL367 0 Bill 05,22,03 NULL6650 NULL0 Day 11:53:11 2024-07-27 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9842 DO N NULL2024-03-26 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 16.00 16.00 NULL2024-07-27 11:54:31 NULLNULL0.00 0.00
9296 AEH/24-25//0303 2024-06-28 2024-07-27 PO NULLNULL1 AEH NULLNULLNULL367 0 Bill 333 NULL6650 NULL0 Day 11:50:54 2024-07-27 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9839 DO N NULL2024-03-26 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 19.00 19.00 NULL2024-07-27 11:51:57 NULLNULL0.00 0.00
9295 AEH/24-25//0302 2024-07-26 2024-07-27 PO NULLNULL1 AEH NULLNULLNULL367 0 Bill 068,445,07 NULL6650 NULL0 Day 11:48:04 2024-07-27 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9845 DO N NULL2024-03-26 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 4.00 4.00 NULL2024-07-27 11:49:35 NULLNULL0.00 0.00
9294 AEH/24-25//0301 2024-06-28 2024-07-27 PO NULLNULL1 AEH NULLNULLNULL367 0 Bill 421 NULL6650 NULL0 Day 11:45:32 2024-07-27 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9845 DO N NULL2024-03-26 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 5.00 5.00 NULL2024-07-27 11:47:05 NULLNULL0.00 0.00
9293 AEH/24-25//0300 2024-07-20 2024-07-27 PO NULLNULL1 AEH NULLNULLNULL69 0 Bill 398 NULL6964 NULL0 Day 11:43:28 2024-07-27 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9818 DO N NULL2024-07-24 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 6.00 6.00 NULL2024-07-27 11:44:18 NULLNULL0.00 0.00
9292 AEH/24-25//0299 2024-07-23 2024-07-27 PO NULLNULL1 AEH NULLNULLNULL435 0 Bill 0077 NULL6727 NULL0 Day 11:40:19 2024-07-27 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9832 DO N NULL2024-03-19 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 1.00 1.00 NULL2024-07-27 11:42:14 NULLNULL0.00 0.00
9291 APH/24-25//0217 2024-07-26 2024-07-27 PO NULLNULL2 APH NULLNULLNULL16 0 Bill A006978 NULL6969 NULL0 Day 09:44:28 2024-07-27 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9847 DO N NULL2024-07-27 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 350.00 350.00 NULL2024-07-27 09:51:18 NULLNULL0.00 0.00
9290 AEH/24-25//0298 2024-07-16 2024-07-26 PO NULLNULL1 AEH NULLNULLNULL442 0 Bill 319 NULLMANI MANDI NULL0 Day 11:40:42 2024-07-26 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9840 DO N NULL2024-07-16 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 1382.00 1382.00 NULL2024-07-26 11:42:30 NULLNULL0.00 0.00
9289 AEH/24-25//0297 2024-07-09 2024-07-26 PO NULLNULL1 AEH NULLNULLNULL442 0 Bill 316 NULLMANI MANDI NULL0 Day 11:37:25 2024-07-26 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9836 DO N NULL2024-07-09 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 1531.50 1531.50 NULL2024-07-26 11:39:13 NULLNULL0.00 0.00
9288 AEH/24-25//0296 2024-06-27 2024-07-26 PO NULLNULL1 AEH NULLNULLNULL442 0 Bill 313 NULLMANI MANDI NULL0 Day 11:34:50 2024-07-26 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9835 DO N NULL2024-06-27 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 2517.00 2517.00 NULL2024-07-26 11:36:33 NULLNULL0.00 0.00
9287 AEH/24-25//0295 2024-07-13 2024-07-26 PO NULLNULL1 AEH NULLNULLNULL442 0 Bill 318 NULLMANI MANDI NULL0 Day 11:30:20 2024-07-26 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9838 DO N NULL2024-07-13 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 2303.00 2303.00 NULL2024-07-26 11:31:36 NULLNULL0.00 0.00
9286 AEH/24-25//0294 2024-07-10 2024-07-26 PO NULLNULL1 AEH NULLNULLNULL442 0 Bill 317 NULLMANI MANDI NULL0 Day 11:27:37 2024-07-26 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9837 DO N NULL2024-07-10 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 2258.50 2258.50 NULL2024-07-26 11:29:21 NULLNULL0.00 0.00
9285 APH/24-25//0216 2024-07-22 2024-07-26 PO NULLNULL2 APH NULLNULLNULL15 0 Challan T001204 NULL6967 NULL0 Day 10:03:59 2024-07-26 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9827 DO N NULL2024-07-25 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 4000.00 4000.00 NULL2024-07-26 10:22:06 NULLNULL0.00 0.00
9284 APH/24-25//0215 2024-07-23 2024-07-25 PO NULLNULL2 APH NULLNULLNULL11 0 Bill DDPL/2469/ NULL6966 NULL0 Day 02:55:42 2024-07-25 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9825 DO N NULL2024-07-25 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 2010.00 2010.00 NULL2024-07-25 14:58:03 NULLNULL0.00 0.00
9283 APH/24-25//0214 2024-07-23 2024-07-25 PO NULLNULL2 APH NULLNULLNULL11 0 Bill DDPL/2468/ NULL6966 NULL0 Day 02:51:46 2024-07-25 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9825 DO N NULL2024-07-25 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 300.00 300.00 NULL2024-07-25 14:54:27 NULLNULL0.00 0.00
9282 APH/24-25//0213 2024-07-25 2024-07-25 PO NULLNULL3 APH NULLNULLNULL62 0 Bill 4336 NULL6965 NULL0 Day 12:00:25 2024-07-25 NULLNULL13 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9834 DO N NULL2024-07-25 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 352.00 352.00 NULL2024-07-25 12:06:50 NULLNULL0.00 0.00
9281 APH/24-25//0212 2024-07-22 2024-07-24 PO NULLNULL2 APH NULLNULLNULL10 0 Bill JN02OP25-1 NULL6963 NULL0 Day 04:07:06 2024-07-24 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9826 DO N NULL2024-07-24 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 250.00 250.00 NULL2024-07-24 16:30:56 NULLNULL0.00 0.00
9280 APH/24-25//0211 2024-07-22 2024-07-24 PO NULLNULL2 APH NULLNULLNULL2 0 Bill T24/1226 NULL6962 NULL0 Day 10:07:58 2024-07-24 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9831 DO N NULL2024-07-23 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 840.00 840.00 NULL2024-07-24 10:12:06 NULLNULL0.00 0.00
9279 AEH/24-25//0293 2024-07-17 2024-07-23 PO NULLNULL1 AEH NULLNULLNULL49 0 Bill 40 NULL6955 NULL0 Day 10:05:25 2024-07-23 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9814 DO N NULL2024-07-17 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 5004.00 5004.00 NULL2024-07-23 10:06:11 NULLNULL0.00 0.00
9278 AEH/24-25//0292 2024-07-04 2024-07-23 PO NULLNULL1 AEH NULLNULLNULL58 0 Bill 2219 NULL6957 NULL0 Day 10:03:04 2024-07-23 NULLNULL111 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9784 DO N NULL2024-07-19 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 23.00 23.00 NULL2024-07-23 10:03:58 NULLNULL0.00 0.00
9277 APH/24-25//0210 2024-07-19 2024-07-22 PO NULLNULL2 APH NULLNULLNULL2 0 Bill T24/1198 NULL6960 NULL0 Day 10:09:09 2024-07-22 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9816 DO N NULL2024-07-20 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 1300.00 1300.00 NULL2024-07-22 10:11:07 NULLNULL0.00 0.00
9276 APH/24-25//0209 2024-07-19 2024-07-22 PO NULLNULL2 APH NULLNULLNULL2 0 Bill T24/1197 NULL6960 NULL0 Day 10:05:52 2024-07-22 NULLNULL17 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9815 DO N NULL2024-07-20 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 260.00 260.00 NULL2024-07-22 10:07:35 NULLNULL0.00 0.00
9275 APH/24-25//0208 2024-07-20 2024-07-20 PO NULLNULL3 APH NULLNULLNULL62 0 Bill 4324 NULL6958 NULL0 Day 03:09:26 2024-07-20 NULLNULL13 Pending NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL9817 DO N NULL2024-07-20 0 3 NULLNULLNULLNULL0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Indirect MT 0 0000-00-00 Consolidated 0 9.00 9.00 NULL2024-07-20 15:15:07 NULLNULL0.00 0.00