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
voucher_id bigint(20)
line_no int(10)
voucher_no varchar(50) utf8mb4_general_ci
voucher_type_id bigint(20)
voucher_date date
ledger_id bigint(20)
ledger_group_id smallint(5)
amount_signed decimal(18,2)
currency_code char(3) utf8mb4_general_ci
fx_rate decimal(18,8)
amount_base decimal(18,2)
branch_id int(10)
finance_year_id int(10)
user_id bigint(20)
narration text utf8mb4_general_ci
correspondent_ledger_id bigint(20)
corr_ledger_group_id smallint(5)
instrument_no varchar(50) utf8mb4_general_ci
instrument_date date
recon_status tinyint(1)
recon_date date
cost_center_id bigint(20)
project_id bigint(20)
source_module varchar(50) utf8mb4_general_ci
source_id bigint(20)
tds_deduction_id bigint(20)
created_at datetime
updated_at datetime
delete_status tinyint(1)
deleted_by int(11)
deleted_at datetime