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)
claim_id bigint(20)
claim_no_snapshot varchar(60) utf8mb4_unicode_ci
operation_mode varchar(30) utf8mb4_unicode_ci
document_type varchar(40) utf8mb4_unicode_ci
source_credit_note_entry_id bigint(20)
source_voucher_type_id bigint(20)
source_voucher_no varchar(50) utf8mb4_unicode_ci
source_state_hash char(64) utf8mb4_unicode_ci
source_claim_row_version int(10)
source_claim_snapshot_hash char(64) utf8mb4_unicode_ci
source_posting_family varchar(20) utf8mb4_unicode_ci
source_posting_run_id bigint(20)
source_posting_plan_hash char(64) utf8mb4_unicode_ci
source_itc_status varchar(20) utf8mb4_unicode_ci
reason varchar(500) utf8mb4_unicode_ci
requested_effective_date date
plan_hash char(64) utf8mb4_unicode_ci
idempotency_key char(64) utf8mb4_unicode_ci
status varchar(30) utf8mb4_unicode_ci
expected_allocation_rows int(10)
actual_allocation_rows int(10)
expected_ledger_rows smallint(5)
actual_ledger_rows smallint(5)
expected_audit_rows smallint(5)
actual_audit_rows smallint(5)
expected_outstanding_rows smallint(5)
actual_outstanding_rows smallint(5)
requires_repair tinyint(1)
last_error varchar(1000) utf8mb4_unicode_ci
prepared_by int(10)
last_attempt_by int(10)
completed_by int(10)
branch_id int(10)
finance_year_id int(10)
prepared_at datetime
last_attempt_at datetime
completed_at datetime
created_at datetime
updated_at datetime