Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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 :
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.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `einvoices_eway_bill`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id entry_id voucher_type_id invoice_type ack_no ack_date irn status signed_invoice signed_qr_code ewb_no ewb_date ewb_valid_till remarks e_invoice_send_data e_invoice_response e_way_send_data e_way_response e_way_cancelled_date e_invoice_cancelled_date e_way_allow_cancel e_invoice_allow_cancel active created_by modified_by created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 1
1 1467 1 E-Invoice 112630861592743 2026-06-08 17:17:00 1b9f9d3d68e483338337db93a6ec164d548fab8bb65c914e9f... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112630861592743,"Ack... 2026-06-08 17:35:00 Y Y N 5 2026-06-08 17:17:23 2026-06-08 17:35:23
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 2
2 1492 1 E-Invoice 112630881099952 2026-06-09 18:19:00 83ff5d1577b9bc6a1cb873f06dd272f9522a2f043bdf3f0860... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112630881099952,"Ack... Y N Y 6 2026-06-09 18:19:07 2026-06-11 11:25:49
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 3
3 1496 1 E-Invoice 112630882213045 2026-06-09 19:19:00 9809935232c0c7cb8daa3a504c64e27eeda1882cdfa90d13cb... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112630882213045,"Ack... Y N Y 3 2026-06-09 19:19:24 2026-06-11 11:25:49
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 4
4 1494 1 E-Invoice 112630882246317 2026-06-09 19:22:00 b5299654d3feafd6d944a0c95f69f952e1d985d104e737fef2... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112630882246317,"Ack... Y N Y 5 2026-06-09 19:21:57 2026-06-11 11:25:49
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 5
5 1650 1 E-Way ACT NULL NULL 142459693180 16/06/2026 06:08:00 PM 17/06/2026 11:59:00 PM NULL NULL {"supplyType":"O","subSupplyType":1,"subSupplyDesc... {"data":{"ewayBillNo":142459693180,"ewayBillDate":... N Y Y 2 2026-06-16 18:07:50 2026-06-18 13:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 6
6 1653 1 E-Invoice 112630985840175 2026-06-16 18:22:00 7ae671810b9b7ff4531d3cc05ed0563c35f7716e4315f83aba... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 182459709562 2026-06-16 18:22:00 2026-06-17 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112630985840175,"Ack... {"Irn":"7ae671810b9b7ff4531d3cc05ed0563c35f7716e43... {"irp":"NIC1","data":{"EwbNo":182459709562,"EwbDt"... N N Y 6 6 2026-06-16 18:21:44 2026-06-18 13:14:16
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 7
7 2456 1 E-Invoice 112631370325767 2026-07-09 16:10:00 47c049919be32a8e670b763fa44ffade271f5214286e4e9e05... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 142481965440 2026-07-09 16:10:00 2026-07-10 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631370325767,"Ack... {"Irn":"47c049919be32a8e670b763fa44ffade271f521428... {"irp":"NIC1","data":{"EwbNo":142481965440,"EwbDt"... N N Y 6 6 2026-07-09 16:09:28 2026-07-10 16:18:54
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 8
8 2713 1 E-Invoice 112631486075693 2026-07-17 12:33:00 72b5cc615c6d576abcf078ea4fe7e86f07d0b4ce3b1a07a1ff... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631486075693,"Ack... Y N Y 8 2026-07-17 12:33:18 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 9
9 2716 1 E-Invoice 112631487618033 2026-07-17 13:56:00 e76d86da52135dda678f19720f2c87215e439610c4dfe8c764... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 102489850638 2026-07-17 14:09:00 2026-07-18 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631487618033,"Ack... {"Irn":"e76d86da52135dda678f19720f2c87215e439610c4... {"irp":"NIC1","data":{"EwbNo":102489850638,"EwbDt"... N N Y 6 6 2026-07-17 13:56:17 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 10
10 2717 1 E-Invoice 112631488462608 2026-07-17 14:46:00 8852242d0409e9a252cd41ac417fb51821127d6c2fc2748d94... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 102489889166 2026-07-17 14:46:00 2026-07-18 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631488462608,"Ack... {"Irn":"8852242d0409e9a252cd41ac417fb51821127d6c2f... {"irp":"NIC1","data":{"EwbNo":102489889166,"EwbDt"... N N Y 8 8 2026-07-17 14:45:47 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 11
11 2727 1 E-Invoice 112631491678528 2026-07-17 17:10:00 dba42a4d1add363271ee37707bc07c47a560722db712e7e359... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631491678528,"Ack... Y N Y 8 2026-07-17 17:09:58 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 12
12 2736 1 E-Invoice 112631492673654 2026-07-17 17:50:00 096156ba04b2d5b749e2a7cab0561bd68318181ab23d472d31... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631492673654,"Ack... Y N Y 8 2026-07-17 17:50:21 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 13
13 2737 1 E-Way ACT NULL NULL 162490155294 17/07/2026 05:57:00 PM 18/07/2026 11:59:00 PM Total invoice value is more than the sum of total ... NULL NULL {"supplyType":"O","subSupplyType":1,"subSupplyDesc... {"data":{"ewayBillNo":162490155294,"ewayBillDate":... N Y Y 8 2026-07-17 17:57:14 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 14
14 2737 1 E-Invoice 112631492819593 2026-07-17 17:57:00 f430563d515278748bc238a4d882bbd919dfb336d69d970bd7... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631492819593,"Ack... Y Y Y 8 2026-07-17 17:57:26 2026-07-17 17:57:26
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 15
15 2748 1 E-Invoice 112631493747521 2026-07-17 18:45:00 31817ba570f3b09627e434c7ac76b6455414f78779a3e816c1... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631493747521,"Ack... Y N Y 8 2026-07-17 18:44:52 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 16
16 2753 1 E-Way ACT NULL NULL 162490228525 17/07/2026 07:02:00 PM 18/07/2026 11:59:00 PM Total invoice value is more than the sum of total ... NULL NULL {"supplyType":"O","subSupplyType":1,"subSupplyDesc... {"data":{"ewayBillNo":162490228525,"ewayBillDate":... N Y Y 8 2026-07-17 19:02:13 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 17
17 2753 1 E-Invoice 112631494022854 2026-07-17 19:02:00 8937af1d5aaa536533a72914100cd9344f60f3d7fef51657c5... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631494022854,"Ack... Y Y Y 8 2026-07-17 19:02:27 2026-07-17 19:02:27
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 18
18 2756 1 E-Way ACT NULL NULL 122490232719 17/07/2026 07:07:00 PM 18/07/2026 11:59:00 PM NULL NULL {"supplyType":"O","subSupplyType":1,"subSupplyDesc... {"data":{"ewayBillNo":122490232719,"ewayBillDate":... N Y Y 8 2026-07-17 19:06:45 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 19
19 2756 1 E-Invoice 112631494094499 2026-07-17 19:07:00 ce94c6226d159fc38e94551d7901bd96de594b3c98b3fbe93a... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631494094499,"Ack... Y Y Y 8 2026-07-17 19:07:07 2026-07-17 19:07:07
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 20
20 2775 1 E-Invoice 112631502386514 2026-07-18 12:34:00 89f6ae2dc30a8735e1517de44f634131d9fcfe1db54a764643... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 142490848525 2026-07-18 12:48:00 2026-07-19 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631502386514,"Ack... {"Irn":"89f6ae2dc30a8735e1517de44f634131d9fcfe1db5... {"irp":"NIC1","data":{"EwbNo":142490848525,"EwbDt"... N N Y 8 8 2026-07-18 12:34:00 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 21
21 2778 1 E-Invoice 112631502825101 2026-07-18 12:56:00 ec666dfa4022e5e1b095c6b6ec559978813984832789ebe507... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631502825101,"Ack... Y N Y 8 2026-07-18 12:55:40 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 22
22 2771 1 E-Invoice 112631502861033 2026-07-18 12:58:00 e108df7f136a36df51799d5b8480704ce58fff474ab87fc167... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 132490860571 2026-07-18 12:58:00 2026-07-19 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631502861033,"Ack... {"Irn":"e108df7f136a36df51799d5b8480704ce58fff474a... {"irp":"NIC1","data":{"EwbNo":132490860571,"EwbDt"... N N Y 8 8 2026-07-18 12:57:47 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 23
23 2768 1 E-Invoice 112631504283521 2026-07-18 14:20:00 9a144d35d8299fe45f1328c13add6a9e6a3fcc38f60eb2b977... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631504283521,"Ack... Y N Y 8 2026-07-18 14:19:46 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 24
24 2804 1 E-Invoice 112631505364823 2026-07-18 15:22:00 2e41813de724a747a9459e50f5825cb7420552f6858324b79e... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... 162491013160 2026-07-18 15:22:00 2026-07-19 23:59:00 NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631505364823,"Ack... {"Irn":"2e41813de724a747a9459e50f5825cb7420552f685... {"irp":"NIC1","data":{"EwbNo":162491013160,"EwbDt"... N N Y 8 8 2026-07-18 15:21:38 2026-07-20 10:43:38
Edit Edit Copy Copy Delete Delete
DELETE FROM einvoices_eway_bill WHERE `einvoices_eway_bill`.`id` = 25
25 2797 1 E-Invoice 112631506780000 2026-07-18 16:32:00 34bfb1183da35c02ee92c17e0f13517b899ae4e962dc64e624... ACT eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... eyJhbGciOiJSUzI1NiIsImtpZCI6IkNEMDFBQzJCNkU3MjBDRj... NULL NULL NULL NULL {"Version":"1.1","TranDtls":{"TaxSch":"GST","SupTy... {"irp":"NIC1","data":{"AckNo":112631506780000,"Ack... Y N Y 8 2026-07-18 16:32:02 2026-07-20 10:43:38
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query