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)
expense_entry_id bigint(20)
item_id bigint(20)
ledger_id bigint(20)
hsn_sac_id bigint(20)
uom_id bigint(20)
quantity decimal(10,2)
rate decimal(10,2)
price decimal(10,2)
amount decimal(10,2)
discount_type enum('Fixed', 'Percentage') utf8mb4_unicode_ci
discount_value decimal(10,2)
discount_amount decimal(10,2)
proportionate_discount decimal(10,2)
proportionate_discount_selected_items decimal(10,2)
taxable_amount decimal(12,2)
proportionate_add_charges_amount decimal(12,2)
tax_percentage decimal(5,2)
cgst_percentage decimal(5,2)
sgst_percentage decimal(5,2)
igst_percentage decimal(5,2)
cess_percentage decimal(5,2)
tax_amount decimal(10,2)
cgst_amount decimal(10,2)
sgst_amount decimal(10,2)
igst_amount decimal(10,2)
cess_amount decimal(10,2)
branch_id int(10)
delete_status tinyint(3)
is_cancelled enum('Y', 'N') utf8mb4_unicode_ci
created_at timestamp
updated_at timestamp