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_run_id bigint(20) Browse foreign values Browse foreign values
line_no smallint(5)
source_plan_line_id bigint(20) Browse foreign values Browse foreign values
source_plan_line_no int(10)
source_line_hash char(64) utf8mb4_unicode_ci
role varchar(40) utf8mb4_unicode_ci
ledger_id bigint(20)
ledger_name_snapshot varchar(250) utf8mb4_unicode_ci
ledger_group_id bigint(20)
entry_side enum('DR', 'CR') utf8mb4_unicode_ci
dr_amount decimal(18,2)
cr_amount decimal(18,2)
correspondent_ledger_id bigint(20)
corr_ledger_group_id bigint(20)
sort_order smallint(5)
is_main_row tinyint(3)
cash_or_bank enum('Cash', 'Bank', 'Party') utf8mb4_unicode_ci
by_or_to enum('By', 'To') utf8mb4_unicode_ci
txn_date date
narration varchar(500) utf8mb4_unicode_ci
row_fingerprint char(64) utf8mb4_unicode_ci
ledger_posting_id bigint(20)
audit_posting_id bigint(20)
created_at datetime
updated_at datetime