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)
reversal_run_id bigint(20)
line_no smallint(5)
source_posting_family varchar(20) utf8mb4_unicode_ci
source_posting_run_line_id bigint(20)
source_ledger_posting_id bigint(20)
source_audit_posting_id bigint(20)
source_row_fingerprint char(64) utf8mb4_unicode_ci
ledger_id bigint(20)
ledger_group_id bigint(20)
original_entry_side enum('DR', 'CR') utf8mb4_unicode_ci
original_dr_amount decimal(18,2)
original_cr_amount decimal(18,2)
reversal_entry_side enum('DR', 'CR') utf8mb4_unicode_ci
reversal_dr_amount decimal(18,2)
reversal_cr_amount decimal(18,2)
correspondent_ledger_id bigint(20)
corr_ledger_group_id bigint(20)
sort_order smallint(5)
is_main_row tinyint(1)
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
reversal_row_fingerprint char(64) utf8mb4_unicode_ci
reversal_ledger_posting_id bigint(20)
reversal_audit_posting_id bigint(20)
execution_status varchar(20) utf8mb4_unicode_ci
created_at datetime
updated_at datetime