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)
purchase_invoice_no varchar(50) utf8mb4_unicode_ci
purchase_invoice_date date
voucher_number varchar(50) utf8mb4_unicode_ci
voucher_type_id bigint(20)
entry_mode enum('Cash', 'Party') utf8mb4_unicode_ci
grn_ref_id int(11)
grn_status enum('Y', 'N') utf8mb4_unicode_ci
sales_channel varchar(50) utf8mb4_unicode_ci
sales_person_id int(10)
source_quotation_id bigint(20)
voucher_date date
voucher_time time
due_date date
ledger_id int(10)
party_cat_id int(11)
invoice_amount decimal(12,2)
price decimal(10,2)
pri_discount decimal(10,2)
proportionate_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)
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)
finance_year_id bigint(20)
delete_status tinyint(1)
created_at datetime
updated_at datetime
round_off decimal(12,2)
total_amount decimal(12,2)
irn varchar(64) utf8mb4_unicode_ci
ack_no bigint(20)
ack_date datetime
qr_code text utf8mb4_unicode_ci
einvoice_status enum('PENDING', 'GENERATED', 'FAILED') utf8mb4_unicode_ci
einvoice_error text utf8mb4_unicode_ci
ewaybill_no bigint(20)
ewaybill_date datetime
ewaybill_status enum('PENDING', 'GENERATED', 'FAILED') utf8mb4_unicode_ci
ewaybill_error text utf8mb4_unicode_ci
posting_status enum('Pending', 'Posted') utf8mb4_unicode_ci