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_type enum('ledger_wise', 'items_wise') utf8mb4_unicode_ci
expense_invoice_no varchar(50) utf8mb4_unicode_ci
expense_invoice_date date
voucher_number varchar(50) utf8mb4_unicode_ci
voucher_type_id bigint(20)
entry_mode enum('Cash', 'Party') utf8mb4_unicode_ci
urd enum('Y', 'N') utf8mb4_unicode_ci
voucher_date date
voucher_time time
due_date date
ledger_id int(10)
party_cat_id int(11)
sgst_amount decimal(10,2)
cgst_amount decimal(10,2)
igst_amount decimal(10,2)
cess_amount decimal(10,2)
round_off decimal(12,2)
price decimal(10,2)
pri_discount decimal(10,2)
after_prim_dis_price decimal(12,2)
proportionate_discount decimal(10,2)
additional_discount decimal(10,2)
total_discount decimal(10,2)
add_charges decimal(10,2)
taxable_amount decimal(12,2)
item_tax_amount decimal(10,2)
add_charges_fixed_tax_amount decimal(10,2)
add_charges_proportionate_tax_amount decimal(10,2)
total_tax_amount decimal(12,2)
tds_amount decimal(10,2)
invoice_amount decimal(12,2)
freight_charges decimal(10,2)
payment_status enum('Pending', 'Paid', 'Partial') utf8mb4_unicode_ci
narration text utf8mb4_unicode_ci
receiver_name varchar(100) utf8mb4_unicode_ci
receiver_contact_number varchar(20) utf8mb4_unicode_ci
branch_id int(11)
user_id bigint(20)
modified_user_id bigint(20)
finance_year_id bigint(20)
delete_status tinyint(1)
is_cancelled enum('Y', 'N') utf8mb4_unicode_ci
created_at datetime
updated_at datetime
posting_status enum('Pending', 'Posted') utf8mb4_unicode_ci
calc_add_discount_from enum('BASE', 'PRIMARY_DISCOUNT') utf8mb4_unicode_ci