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)
posting_date date
txn_date date
voucher_id bigint(20)
voucher_no varchar(50) utf8mb4_unicode_ci
voucher_type_id bigint(20)
voucher_date date
ledger_id bigint(20)
group_id bigint(20)
parent_group_id bigint(20)
entry_side enum('CR', 'DR') utf8mb4_unicode_ci
dr_amount decimal(18,2)
cr_amount decimal(18,2)
branch_id int(10)
finance_year_id int(10)
user_id bigint(20)
narration text utf8mb4_unicode_ci
sort_order tinyint(4)
is_main_row tinyint(4)
cash_or_bank enum('Cash', 'Bank', 'Party') utf8mb4_unicode_ci
by_or_to enum('By', 'To') utf8mb4_unicode_ci
other_details enum('Y', 'N') utf8mb4_unicode_ci
correspondent_ledger_id bigint(20)
created_at datetime
updated_at datetime
delete_status tinyint(1)
is_cancelled enum('Y', 'N') utf8mb4_unicode_ci
deleted_by int(11)
deleted_at datetime