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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
id bigint(20)
entry_type enum('PAYMENT', 'EXPENSE') utf8mb4_unicode_ci
voucher_type_id int(11)
cash_or_bank enum('Cash', 'Bank') utf8mb4_unicode_ci
voucher_no varchar(50) utf8mb4_unicode_ci
voucher_date date
ledger_id bigint(20)
ledger_account_id bigint(20)
expense_head varchar(200) utf8mb4_unicode_ci
gst_aplicability varchar(100) utf8mb4_unicode_ci
ref_bill_no varchar(50) utf8mb4_unicode_ci
instrument_type enum('CASH', 'CHEQUE', 'NEFT', 'RTGS', 'IMPS', 'UPI', 'DD', 'OTHERS', 'ONLINE') utf8mb4_unicode_ci
instrument_number varchar(100) utf8mb4_unicode_ci
amount decimal(12,2)
branch_id int(10)
user_id int(11)
narration text utf8mb4_unicode_ci
delete_status tinyint(1)
created_at datetime
updated_at datetime
created_by int(11)
modified_by int(11)
finance_year_id int(11)
bank_name varchar(50) utf8mb4_unicode_ci
account_no varchar(20) utf8mb4_unicode_ci
ifsc_code varchar(20) utf8mb4_unicode_ci
reference_id int(11)