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)
plan_run_id bigint(20) Browse foreign values Browse foreign values
line_no int(10)
claim_id bigint(20)
invoice_allocation_id bigint(20)
tax_allocation_id bigint(20)
sales_entry_id bigint(20)
sales_entry_item_id bigint(20)
item_id bigint(20)
hsn_sac_id bigint(20)
invoice_voucher_no varchar(60) utf8mb4_unicode_ci
invoice_date date
hsn_sac_code varchar(30) utf8mb4_unicode_ci
hsn_description varchar(255) utf8mb4_unicode_ci
hsn_type varchar(20) utf8mb4_unicode_ci
source_item_taxable_amount decimal(18,2)
discount_taxable_amount decimal(18,2)
tax_percentage decimal(9,4)
cgst_percentage decimal(9,4)
sgst_percentage decimal(9,4)
igst_percentage decimal(9,4)
cess_percentage decimal(9,4)
snapshot_cgst_amount decimal(18,2)
snapshot_sgst_amount decimal(18,2)
snapshot_igst_amount decimal(18,2)
snapshot_cess_amount decimal(18,2)
snapshot_gross_credit_amount decimal(18,2)
trace_mode varchar(60) utf8mb4_unicode_ci
trace_hash char(64) utf8mb4_unicode_ci
branch_id int(10)
finance_year_id int(10)
created_at datetime