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)
claim_id bigint(20) Browse foreign values Browse foreign values
scheme_gst_treatment enum('AUTO', 'GST_CREDIT_NOTE', 'COMMERCIAL_CREDIT_NOTE', 'FINANCIAL_ADJUSTMENT') utf8mb4_unicode_ci
document_type enum('GST_CREDIT_NOTE', 'COMMERCIAL_CREDIT_NOTE', 'FINANCIAL_ADJUSTMENT') utf8mb4_unicode_ci
tax_effect enum('REDUCE_OUTPUT_TAX', 'NO_GST_REDUCTION') utf8mb4_unicode_ci
agreement_pre_supply enum('Y', 'N', 'NA') utf8mb4_unicode_ci
invoice_link_confirmed enum('Y', 'N', 'NA') utf8mb4_unicode_ci
taxable_value_reduction enum('Y', 'N', 'NA') utf8mb4_unicode_ci
itc_reversal_required enum('Y', 'N', 'NA') utf8mb4_unicode_ci
decision_reason varchar(500) utf8mb4_unicode_ci
final_discount_amount decimal(18,2)
final_cgst_amount decimal(18,2)
final_sgst_amount decimal(18,2)
final_igst_amount decimal(18,2)
final_cess_amount decimal(18,2)
final_gross_credit_amount decimal(18,2)
reviewed_by int(10)
reviewed_at datetime
branch_id int(10)
delete_status tinyint(1)
created_at datetime
updated_at datetime