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)
voucher_number varchar(50) utf8mb4_unicode_ci
voucher_type_id bigint(20)
entry_mode enum('Cash', 'Party') utf8mb4_unicode_ci
entry_status enum('SALES', 'PROFORMA', 'QUOTATION', 'DELIVERY_NOTE', 'SALES_ORDER', 'DRAFT', 'DECLINE', 'REQUESTED', 'SERVICE') utf8mb4_unicode_ci
source_sales_id int(11)
source_proforma_id int(11)
source_quotation_id int(10)
source_delivery_note_id int(10)
source_sales_order_id int(11)
source_subsidy_id int(11)
proforma_status_deleted enum('Y', 'N') utf8mb4_unicode_ci
quotation_moved_status_deleted varchar(20) utf8mb4_unicode_ci
delivery_note_type enum('Inhouse', 'Sales_reference', 'Others') utf8mb4_unicode_ci
sales_channel varchar(50) utf8mb4_unicode_ci
sales_person_id int(10)
voucher_date date
confirm_decline_date date
voucher_time time
due_date date
ledger_id int(10)
order_no varchar(50) utf8mb4_unicode_ci
party_cat_id int(11)
invoice_amount decimal(12,2)
price decimal(10,2)
after_prim_dis_price decimal(10,2)
subsidy_scheme_id tinyint(4)
subsidy_scheme_discount decimal(10,2)
pri_discount decimal(10,2)
proportionate_discount decimal(10,2)
additional_discount decimal(10,2)
total_discount decimal(10,2)
discount_coupon_code varchar(50) utf8mb4_unicode_ci
applied_discount_category enum('SCHEME', 'CATEGORY') utf8mb4_unicode_ci
applied_discount_category_id int(11)
subsidy_diff_amt decimal(12,2)
taxable_amount decimal(12,2)
item_tax_amout decimal(10,2)
add_charges_fixed_tax_amount decimal(10,2)
add_charges_proportionate_tax_amount decimal(10,2)
total_tax_amount decimal(10,2)
tds_amount decimal(10,2)
freight_charges decimal(10,2)
add_charges decimal(10,2)
sgst_amount decimal(10,2)
cgst_amount decimal(10,2)
igst_amount decimal(10,2)
cess_amount decimal(10,2)
payment_status enum('Pending', 'Paid', 'Partial') utf8mb4_unicode_ci
narration text utf8mb4_unicode_ci
additional_discount_remarks longtext utf8mb4_unicode_ci
discount_details longtext 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
round_off decimal(12,2)
total_amount decimal(12,2)
einvoice_status enum('PENDING', 'GENERATED', 'CANCELLED') utf8mb4_unicode_ci
ewaybill_status enum('PENDING', 'GENERATED', 'CANCELLED') utf8mb4_unicode_ci
posting_status enum('Pending', 'Posted') utf8mb4_unicode_ci
decline_reason longtext utf8mb4_unicode_ci
confirm_reason longtext utf8mb4_unicode_ci