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_no varchar(60) utf8mb4_unicode_ci
claim_sequence_no smallint(5)
idempotency_key varchar(64) utf8mb4_unicode_ci
scheme_id bigint(20) Browse foreign values Browse foreign values
agreement_id bigint(20) Browse foreign values Browse foreign values
ledger_id bigint(20)
period_from date
period_to date
turnover_basis enum('TAXABLE_VALUE', 'NET_INVOICE_VALUE', 'COLLECTION_VALUE') utf8mb4_unicode_ci
gross_sales_amount decimal(18,2)
sales_return_amount decimal(18,2)
eligible_turnover_amount decimal(18,2)
collection_amount decimal(18,2)
target_amount decimal(18,2)
achievement_percent decimal(9,4)
applicable_discount_rate decimal(9,4)
fixed_discount_amount decimal(18,2)
discount_amount decimal(18,2)
cgst_amount decimal(18,2)
sgst_amount decimal(18,2)
igst_amount decimal(18,2)
cess_amount decimal(18,2)
round_off decimal(18,2)
gross_credit_amount decimal(18,2)
document_type enum('UNDECIDED', 'GST_CREDIT_NOTE', 'COMMERCIAL_CREDIT_NOTE', 'FINANCIAL_ADJUSTMENT') 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
status enum('DRAFT', 'CALCULATED', 'SUBMITTED', 'APPROVAL_PENDING', 'APPROVED', 'REJECTED', 'CREDIT_NOTE_CREATED', 'POSTED', 'CANCELLED', 'REVERSED') utf8mb4_unicode_ci
calculation_version int(10)
row_version int(10)
source_snapshot_hash char(64) utf8mb4_unicode_ci
snapshot_at datetime
credit_note_entry_id bigint(20)
credit_note_voucher_no varchar(50) utf8mb4_unicode_ci
branch_id int(10)
finance_year_id int(10)
created_by int(10)
updated_by int(10)
submitted_by int(10)
approved_by int(10)
posted_by int(10)
rejected_by int(10)
reversed_by int(10)
submitted_at datetime
approved_at datetime
posted_at datetime
rejected_at datetime
reversed_at datetime
rejection_reason varchar(500) utf8mb4_unicode_ci
reversal_reason varchar(500) utf8mb4_unicode_ci
delete_status tinyint(1)
deleted_by int(10)
deleted_at datetime
created_at datetime
updated_at datetime
discount_basis_mode enum('TAXABLE_BASE', 'DOCUMENT_VALUE') utf8mb4_unicode_ci
discount_base_amount decimal(18,2)
discount_amount_semantics enum('TAXABLE_DISCOUNT', 'GROSS_CREDIT') utf8mb4_unicode_ci
taxable_discount_amount decimal(18,2)
allocation_engine varchar(60) utf8mb4_unicode_ci