* id alert_type alert_message triggered_on item_id ledger_id invoice_id lead_id branch_id user_id alert_level is_read resolved created_at updated_at

* id name age grade

* id entity_type entity_id version event_type reason branch_id finance_year_id changed_by changed_at changed_ip snapshot diff aux hash prev_hash invoice_no voucher_no voucher_date

* id name

* id group_id permission_id

* id name content_type_id codename

* id password last_login is_superuser username first_name last_name email is_staff is_active date_joined

* id user_id group_id

* id user_id permission_id

* id bank_code bank_name short_name swift_code is_active created_at updated_at

* id customer_id customer_name mobile_number call_type due_amount assigned_agent scheduled_date call_status remarks next_followup_date miss_count created_at updated_at

* id category_name active_status sort_order created_at updated_at

* id branch_id job_date shift operator_code operator_name machine_name job_no notes delete_status created_by created_at updated_at

* id job_id part_name qty operation_remark delete_status created_at updated_at

* id voucher_no voucher_type_id voucher_date contra_type from_account_id to_account_id instrument_type bank_name instrument_number amount narration branch_id finance_year_id created_by updated_by delete_status created_at updated_at

* coupon_code max_global_uses max_uses_per_customer is_scratch valid_from valid_to

* id coupon_code customer_id rule_id order_ref qty amount branch_id redeemed_at

* id enquiry_id medium template_id status scheduled_at sent_at created_by created_at updated_at delete_status

* id role_name is_active

* id enquiry_id link_type target_id created_by created_at

* id lead_type customer_company contact_person phone whatsapp address city pincode source stage next_followup customer_role next_steps description next_action routed_at auto_routed auto_route_json auto_route_conf handled_by branch_id status created_by created_at updated_at delete_status

* id source_name background_class badge_bg_color badge_text_color badge_color is_active

* id stage_name background_class badge_bg_color badge_text_color badge_color is_active

* id enquiry_id customer_company contact_phone city stage remarks created_by created_at updated_at delete_status

* id lead_id service_type machine_model serial_no preferred_visit_date technician_id priority warranty notes created_at updated_at

* id type_name is_active

* id entity_type entity_id task_type title due_at assigned_to status notes branch_id created_by created_at updated_at delete_status

* id ticket_no ticket_type entry_type entry_date ledger_id customer_name contact_person phone whatsapp city pincode address sales_person_id other_reference reference_notes is_exchange new_machine_price total_exchange net_payable exchange_status inspection_by pickup_date pickup_location exchange_remark status_id branch_id finance_year_id company_id created_by updated_by created_at updated_at delete_status

* id ticket_id machine_name model year machine_condition expected_value approved_value is_delete

* ticket_id source_id stage_id next_followup_date plan_date customer_role suggested_action assignee_id description

* ticket_id service_type_id machine_model serial_no preferred_visit_date technician_id priority notes visit_address delete_status created_at updated_at

* id status_code status_label badge_bg_color badge_text_color badge_color is_active delete_status created_at updated_at

* id status_code status_label background_class is_active

* id enquiry_id scheduled_at address city pincode assigned_to status notes created_by created_at updated_at delete_status

* id title description is_default active_status branch_id created_by modified_by created_at updated_at delete_status

* summary_date branch_id total_sales total_purchases total_receipts total_payments

* summary_date ledger_id branch_id dr_amount cr_amount id finance_year_id balance_date ledger_name led_group_id group_title root_group_id root_group_title main_group sub_group

* id branch_id finance_year_id balance_date ledger_id ledger_name led_group_id group_title root_group_id root_group_title main_group sub_group entry_side opening_debit opening_credit day_debit day_credit closing_debit closing_credit closing_balance created_at updated_at

* summary_year summary_month total_sales total_purchases total_sales_return total_purchase_return total_revenue total_expenditure total_profit created_at

* id total_sales total_purchases total_sales_return total_purchase_return total_revenue total_expenditure total_profit top_customer top_item total_customers total_suppliers total_visits total_leads total_employees summary_date last_updated

* summary_year total_sales total_purchases total_sales_return total_purchase_return total_revenue total_expenditure total_profit created_at

* id filter_name query_value is_active

* id entry_type ledger_id category_type category_value is_full_cash_discount is_proportionate item_wise_proportionate is_delete created_at modified_at

* target_id discount_rule_id target_type target_ref_id customer_segment_id discount_value operator_override min_qty_override min_amount_override combine_override priority_override branch_id delete_status created_at updated_at

* id sales_entry_id voucher_type_id delivery_note_no dispatch_doc_no dispatch_date dispatched_through destination carrier_ledger_id bill_of_lading lr_rr_date motor_vehicle_no buyer_order_no buyer_date branch_id created_by created_at updated_at delete_status

* id action_time object_id object_repr action_flag change_message content_type_id user_id

* id app_label model

* id app name applied

* session_key session_data expire_date

* competitor_price_id item_id competitor_name price branch_id last_checked is_active delete_status created_by updated_by created_at updated_at

* id item_id strategy undercut_value branch_id is_active delete_status created_by updated_by created_at updated_at

* id branch_id item_id brand_id category_id pricing_strategy costing_method min_margin_percent allow_competitor_price competitor_alignment_mode competitor_floor_margin_pct stock_low_threshold stock_high_threshold stock_low_markup_pct stock_high_markdown_pct average_sales_lookback_days rounding_rule effective_from effective_to delete_status created_at updated_at

* id rule_name rule_type reference_id discount_type discount_value valid_from valid_to branch_id is_active delete_status created_by updated_by created_at updated_at

* id rule_type reference_id margin_percent branch_id is_active delete_status created_by updated_by created_at updated_at

* id entry_id voucher_type_id invoice_type ack_no ack_date irn status signed_invoice signed_qr_code ewb_no ewb_date ewb_valid_till remarks e_invoice_send_data e_invoice_response e_way_send_data e_way_response e_way_cancelled_date e_invoice_cancelled_date e_way_allow_cancel e_invoice_allow_cancel active created_by modified_by created_at updated_at

* id invoice_type voucher_type_id entry_id irn_no ewb_no cancelled_date added_by added_at

* id mail_driver mail_from_name mail_from_email enable_queue host port username password encryption is_active created_at updated_at

* id employee_code photo full_name designation email mobile_number date_of_joining branch_id user_role_id is_sales_person is_telecaller reporting_manager_id login_user_id address city state_id country_id pincode is_active delete_status created_at updated_at

* id item_name item_code item_description mrp_delete gst_percent_delete exchange_value_delete branch_id delete_status created_at updated_at

* id exchange_id year_from year_to exchange_value is_active created_at modified_at

* id voucher_type_id voucher_no voucher_date ledger_id expense_ledger_id gst_aplicability itc_eligible ref_bill_no amount branch_id user_id narration delete_status created_at updated_at created_by modified_by finance_year_id

* id expense_id invoice_id allocated_amount remarks delete_status created_at updated_at

* id expense_id invoice_id allocated_amount remarks delete_status created_at updated_at

* id voucher_type_id entry_id e_type consignor_name consignor_gstin consignor_state consignor_address1 consignor_pincode consignor_place consignee_name consignee_gstin consignee_state consignee_address1 consignee_pincode consignee_place transporter_name transporter_id transport_mode transport_doc_no vehicle_no transport_date vehicle_type transDistance transactionType is_active created_at updated_at

* ledger_id branch_id finance_year_id opening_balance transaction_dr transaction_cr closing_balance

* ledger_id branch_id finance_year_id opening_balance transaction_dr transaction_cr closing_balance

* id branch_id year fiscal_year start_date end_date delete_status created_at updated_at

* id environment invoice_type ip_address client_id client_secret username password gstin email authtoken_url eInvoice_url eWay_url eWay_cancel_url eInvoice_cancel_url is_active created_at updated_at

* id invoice_type auth_code expiry_time created_at

* id type_name description is_default is_active delete_status created_at updated_at

* id voucher_type_id voucher_id voucher_number ledger_id invoice_date dr_amount cr_amount branch_id finance_year_id narration created_at updated_at delete_status is_cancelled due_date

* id branch_id voucher_type_id template active

* id display_scheme scheme_price item_price required_exchange_discount calc_add_discount_from eway_required_above_amount

* id item_name alias_name item_code packing hsn_sac_id ledger_id item_cat_id godown_id uom_id brand_id company_id item_type valuation_method standard_cost price_basis mrp profit_logic price_type profit_value price average_price last_purchase_price purchase_price sale_price_delete tax_rate stock_quantity opening_value max_qty min_qty reorder_days low_stock_alert is_subsidy_item is_edit_mrp branch_id item_name_key name_norm aliases_norm delete_status created_at updated_at

* id brand_name description branch_id is_active delete_status created_at updated_at

* id category_name is_active sort_order description branch_id delete_status created_at updated_at

* id item_cat_id discount_source source_id discount_type discount_value is_active branch_id created_at updated_at

* id company_name description branch_id is_active delete_status created_at updated_at

* id code title description active_status created_at updated_at

* id category_name description discount_type_id discount_type is_default delete_status created_at updated_at

* id discount_type_name description is_active delete_status created_at updated_at

* id godown_name code description branch_id address city pincode state_id country_id contact_number email incharge_name is_primary active_status delete_status created_at updated_at

* id hsn_sac_code effective_date active_status gst cgst sgst igst cess branch_id is_delete created_at updated_at

* id item_id branch_id finance_year_id opening_qty opening_rate opening_value created_at updated_at

* id scheme_name discount_type_id discount_type applicable_districts effective_from effective_to poster_image branch_id is_active delete_status created_at updated_at

* id item_id branch_id trans_type trans_ref_id trans_date qty_in qty_out balance_qty narration created_at

* id item_id branch_id opening_qty inward_qty outward_qty closing_qty last_updated

* id hsn_sac_code hsn_description hsn_type tax_percentage cgst sgst igst cess tax_type tax_group_name effective_date active_status branch_id company_id state_id country_id is_delete created_at updated_at

* id uom_name uom_code description branch_id created_at updated_at delete_status

* branch_id item_id price_basis base_price unit_price applied_rules_json rules_hash valid_from valid_to updated_at

* id item_id branch_id financial_year_id stock_qty total_in_qty total_in_value total_out_qty wac_rate stock_value last_txn_id updated_at

* id item_id branch_id financial_year_id finance_year_id godown_id voucher_type_id in_out_type quantity rate ref_type ref_id ref_line_id transaction_value transaction_date voucher_id voucher_type reference_table reference_id narration created_at delete_status is_cancelled

* id voucher_number voucher_type_id voucher_date journal_date branch_id finance_year_id narration posting_status delete_status created_by updated_by created_at updated_at

* id journal_voucher_id ledger_id dr_amount cr_amount delete_status created_at updated_at

* id ledger_id branch_id account_name account_no ifsc_code bank_name branch_name account_type upi_id swift_code micr_code bank_details_applies_to is_primary opening_balance balance_type notes active_status delete_status created_at updated_at

* id ledger_id contact_person_name contact_person_last_name designation contact_number whatsapp_number email_address is_primary created_at updated_at

* id ledger_name primary_group_id reverse_charge is_gst_applicable hsn_code_id trade_name contact_person_name mail_to address city pincode state_id district_id country_id customer_type_id caste_category gender gst_verified gst_registration_types_id gst_number pan_number company_contact_number whatsapp_number mobile email_id website tags party_type_id_del party_cat_id parent_group_id account_group_id led_group_id credit_days credit_limit auto_block_on_overdue delivery_source delivery_source_id branch_id delete_status module ledger_key_id voucher_type_id tds_section_code ledger_type sale_order charge_kind is_cash_ledger_override_id system_ledger_applies_to is_carrier_agent is_default_carrier_agent finance_year_id created_at updated_at

* id ledger_name trade_name led_type_id voucher_type_id sales_entry_id caste_category gender address city pincode state_id country_id gst_registration_types_id gst_number pan_number company_contact_number whatsapp_number email_id delivery_source branch_id delete_status created_at updated_at

* id title parent_group_id is_primary is_secondary sub_group entry_side delete_status main_group child_group description active_status created_at updated_at sort_order report_side report_type report_schedule

* id ledger_key header_field description section_code ledger_type editable apply_on_deleted module account_category account_group default_ledger is_active created_at created_by updated_at updated_by external_ref_code

* id ledger_id finance_year_id financial_year opening_debit opening_credit branch_id created_at updated_at delete_status

* id ledger_id is_primary ship_to gst_no address city state_id country_id pincode contact_person contact_no email_id branch_id created_at updated_at

* id posting_date txn_date voucher_id voucher_no voucher_type_id voucher_date ledger_id group_id parent_group_id entry_side dr_amount cr_amount branch_id finance_year_id user_id narration sort_order is_main_row cash_or_bank by_or_to other_details correspondent_ledger_id created_at updated_at delete_status is_cancelled deleted_by deleted_at

* id posting_date voucher_id line_no voucher_no voucher_type_id voucher_date ledger_id ledger_group_id amount_signed currency_code fx_rate amount_base branch_id finance_year_id user_id narration correspondent_ledger_id corr_ledger_group_id instrument_no instrument_date recon_status recon_date cost_center_id project_id source_module source_id tds_deduction_id created_at updated_at delete_status deleted_by deleted_at

* id ledger_id ledger_cash_id parent_led_id shipping_id voucher_type_id is_primary ship_to mailing_name shipping_address shipping_contact shipping_city shipping_state_id shipping_country_id shipping_pincode shipping_gstin contact_person contact_no email_id place_of_supply delivery_source godown_id plant_id branch_id created_at updated_at

* id ref_table ref_id voucher_type_id voucher_type voucher_id voucher_number voucher_date ledger_id ledger_name parent_group_id parent_group_title ledger_group_id ledger_group_title dr_amount cr_amount narration delete_status correspondent_ledger correspondent_ledger_id branch_id created_at updated_at by to is_other_details is_cash_bank_detailsreport correspondent_date alias_ledger_id

* id title group_type is_default description active_status created_at updated_at

* id gstin access_token token_expiry created_at

* id phone_number message_text status created_at

* summary_month branch_id total_sales total_purchases total_receipts total_payments credit_note debit_note finance_year_id

* id part_id part_title part_cost image_path image_url is_active delete_status created_at updated_at

* id party_id comment_type comment_text commenter comment_date branch_id delete_status created_at updated_at

* id title description sale_order_mode active_status branch_id created_by modified_by created_at updated_at delete_status

* id transaction_id voucher_type_id voucher_date ledger_id ledger_account_id ledger_account_name instrument_type instrument_number bank_name amount branch_id narration received_status move_to_receipt is_subsidy_payment delete_status created_at updated_at

* id date time ledger_id type promise_amount promise_date note call_by created_at modified_at

* id ledger_id user_id status lock_date_time

* id payment_transaction_id purchase_entry_id allocated_amount branch_id delete_status created_at updated_at

* id name sort_order is_active created_at updated_at

* id entry_type voucher_type_id cash_or_bank voucher_no voucher_date ledger_id ledger_account_id expense_head gst_aplicability ref_bill_no instrument_type instrument_number amount branch_id user_id narration delete_status created_at updated_at created_by modified_by finance_year_id bank_name account_no ifsc_code reference_id

* id payment_voucher_id voucher_type_id invoice_id allocated_amount remarks delete_status created_at updated_at

* id plant_name plant_code address city pincode state_id country_id contact_number email is_active branch_id delete_status created_at updated_at

* id voucher_id voucher_type table_name row_data deleted_by deleted_at recovered

* id voucher_type_id ref_id ref_table posting_action message posting_time posted_by

* id voucher_type_id voucher_id posting_status posted_by posting_at

* period_start period_end is_locked locked_by locked_at

* id branch_id item_id reason created_at

* id purchase_invoice_no purchase_invoice_date voucher_number voucher_type_id entry_mode grn_ref_id grn_status urd sales_channel sales_person_id source_quotation_id voucher_date voucher_time due_date ledger_id party_cat_id invoice_amount price after_prim_dis_price pri_discount proportionate_discount additional_discount total_discount discount_coupon_code applied_discount_category applied_discount_category_id taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration receiver_name receiver_contact_number branch_id user_id modified_user_id finance_year_id delete_status created_at updated_at round_off total_amount irn ack_no ack_date qr_code einvoice_status einvoice_error ewaybill_no ewaybill_date ewaybill_status ewaybill_error posting_status

* id voucher_number voucher_type voucher_date due_date ledger_id voucher_type_id finance_year_id invoice_no invoice_date price total_discount applied_discount_category_id taxable_amount total_amount tax_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration branch_id delete_status created_at updated_at

* id purchase_entry_id godown_id item_id hsn_sac_id uom_id quantity rate price discount_type discount_source_id discount_value discount_amount proportionate_discount proportionate_discount_selected_items taxable_amount proportionate_add_charges_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status created_at updated_at

* id purchase_entry_id item_id godown_id voucher_type_id hsn_sac_id uom_id quantity rate price discount_type_id discount_value discount_amount taxable_amount gst_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage gst_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status created_at updated_at

* id invoice_id discount_details total_fixed_discount total_prop_discount remarks selected_prop_discount_items delete_status created_at updated_at

* id po_number supplier_id order_date status total_amount branch_id delete_status created_at updated_at

* id purchase_order_id item_id quantity unit_price total_price delete_status modified_by created_at updated_at

* id entry_id voucher_type_id received_date receipt_note_no received_doc received_through godown_id carrier_ledger_id bill_of_lading motor_vehicle_no branch_id created_by created_at updated_at delete_status

* id voucher_number voucher_type_id voucher_date ledger_id discounted_rate pri_discount proportionate_discount total_discount total_deduction_amount taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status posting_status narration receiver_name receiver_contact_number branch_id finance_year_id delete_status created_at user_id updated_at modified_user_id total_amount round_off ewaybill_status

* id purchase_return_id purchase_entry_id purchase_return_reason_id item_id godown_id hsn_sac_id uom_id quantity discounted_rate deduction_type deduction_value deduction_amount discounted_price proportionate_discount taxable_amount proportionate_add_charges_amount gst_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage gst_amount cgst_amount sgst_amount igst_amount cess_amount deduction_reason branch_id delete_status created_at updated_at

* id purchase_return_id purchase_entry_id purchase_entry_item_id item_id branch_id return_quantity unit_price_discounted return_amount return_reason_id remarks delete_status created_at updated_at

* id voucher_number voucher_date ledger_id total_return_qty total_return_amount branch_id return_status approved_by created_by delete_status created_at updated_at

* id voucher_number voucher_type_id sales_channel sales_person_id source_quotation_id voucher_date voucher_time due_date ledger_id party_cat_id invoice_amount price pri_discount proportionate_discount total_discount discount_coupon_code applied_discount_category applied_discount_category_id taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration additional_discount_remarks discount_details receiver_name receiver_contact_number branch_id user_id finance_year_id delete_status created_at updated_at round_off total_amount irn ack_no ack_date qr_code einvoice_status einvoice_error ewaybill_no ewaybill_date ewaybill_status ewaybill_error posting_status

* id sales_entry_id godown_id item_id hsn_sac_id uom_id quantity rate price discount_type discount_source_id discount_value discount_amount proportionate_discount taxable_amount proportionate_add_charges_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status created_at updated_at

* id receipt_transaction_id sales_entry_id allocated_amount created_at updated_at

* id voucher_type_id cash_or_bank voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number bank_name amount tds_amount branch_id user_id finance_year_id reference_type_id advance_reference_id narration delete_status created_by modified_by created_at updated_at

* id receipt_voucher_id voucher_type_id invoice_id advance_voucher_type_id advance_invoice_id allocated_amount remarks delete_status created_at updated_at

* id entry_type entry_id ledger_id transaction_date voucher_number narration debit_amount credit_amount branch_id item_id hsn_code gst_percentage stock_qty stock_value created_at updated_at

* id voucher_type_id voucher_id voucher_number cancelled_date cancelled_reason cancelled_by added_at

* id voucher_number voucher_type_id entry_mode entry_status source_sales_id source_proforma_id source_quotation_id source_delivery_note_id source_sales_order_id source_subsidy_id proforma_status_deleted quotation_moved_status_deleted delivery_note_type sales_channel sales_person_id voucher_date confirm_decline_date voucher_time due_date ledger_id order_no party_cat_id invoice_amount price after_prim_dis_price subsidy_scheme_id subsidy_scheme_discount pri_discount proportionate_discount additional_discount total_discount discount_coupon_code applied_discount_category applied_discount_category_id subsidy_diff_amt taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status narration additional_discount_remarks discount_details receiver_name receiver_contact_number branch_id user_id modified_user_id finance_year_id delete_status is_cancelled created_at updated_at round_off total_amount einvoice_status ewaybill_status posting_status decline_reason confirm_reason

* id sales_entry_id godown_id subsidy_scheme_id subsidy_billed other_discount_applicable item_id hsn_sac_id uom_id requested_qty quantity mrp rc_rate is_rate_edit_applicable rate price discount_type discount_source_id discount_value discount_amount proportionate_discount proportionate_discount_selected_items taxable_amount proportionate_add_charges_amount tax_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage tax_amount cgst_amount sgst_amount igst_amount cess_amount branch_id delete_status is_cancelled created_at updated_at

* id invoice_id exchange_id exchange_item_age exchange_value exchange_company_name discount_coupon_code credit_note_discount_type credit_note_discount_value discount_details total_fixed_discount total_prop_discount remarks selected_prop_discount_items delete_status created_at updated_at

* id discount_id old_item_id machine_name list_price exchange_value remarks

* id discount_id discount_type amount reason

* id invoice_id scheme_id scheme_document_id document_name document_verified remarks branch_id created_by modified_by created_at updated_at

* id voucher_number voucher_type_id voucher_date ledger_id discounted_rate pri_discount proportionate_discount total_discount total_deduction_amount taxable_amount item_tax_amout add_charges_fixed_tax_amount add_charges_proportionate_tax_amount total_tax_amount tds_amount freight_charges add_charges sgst_amount cgst_amount igst_amount cess_amount payment_status return_status narration receiver_name receiver_contact_number branch_id finance_year_id delete_status created_at user_id modified_user_id updated_at round_off total_amount posting_status einvoice_status ewaybill_status

* id sales_return_id sales_entry_id sales_return_reason_id item_id godown_id hsn_sac_id uom_id quantity discounted_rate deduction_type deduction_value deduction_amount discounted_price proportionate_discount taxable_amount proportionate_add_charges_amount gst_percentage cgst_percentage sgst_percentage igst_percentage cess_percentage gst_amount cgst_amount sgst_amount igst_amount cess_amount deduction_reason branch_id delete_status created_at updated_at

* id reason_title description is_active created_at updated_at

* id branch_id price_base discount_base additional_discount_enabled enable_scheme_discount allow_negative_stock default_payment_mode default_terms_days round_off_method invoice_prefix invoice_start_number delete_status created_at updated_at

* id finance_year_id branch_id target_amount

* id delete_status created_at updated_at

* id ip_address description is_active created_at

* id branch_name branch_code address city pincode state_id country_id contact_number email gstin website logo dark_logo light_logo is_main_branch delete_status created_at updated_at

* id country_name short_name is_default delete_status created_at updated_at

* id state_id district_name short_name delete_status is_default created_at updated_at

* id main_menu display_name url icon sequence is_voucher_entry voucher_entry_order is_report delete_status created_at updated_at

* id state_name short_name delete_status is_default created_at updated_at

* id sub_menu display_name mmenu_id is_master master_order is_list list_order is_voucher_entry voucher_entry_order is_report url entry_url sequence search_sequence delete_status created_at updated_at

* id voucher_type_id cash_or_bank voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number bank_name amount tds_amount branch_id user_id finance_year_id reference_type_id advance_reference_id narration delete_status created_by modified_by created_at updated_at

* id receipt_voucher_id voucher_type_id invoice_id advance_voucher_type_id advance_invoice_id allocated_amount remarks delete_status created_at updated_at

* id scheme_name scheme_code active_status is_delete created_by created_at modified_by modified_at

* id scheme_id sales_entries_id application_name_eng application_name_kan address_phone_eng address_phone_kan social_category_eng social_category_kan landholding_category_eng landholding_category_kan land_address_eng land_address_kan survey_extent_eng survey_extent_kan horticulture_crop_details_eng horticulture_crop_details_kan rtc_details_eng rtc_details_kan rtc_applicant_name_present rtc_applicant_name_present_kan rtc_horticulture_crop_mentioned rtc_horticulture_crop_mentioned_kan rtc_crop_extent_eng rtc_crop_extent_kan machine_name_technical_details_eng machine_name_technical_details_kan purchased_from_eng purchased_from_kan purchase_details_eng purchase_details_kan usage_of_equipment_eng usage_of_equipment_kan total_price total_price_kan requested_subsidy_amount requested_subsidy_amount_kan social_category_other_eng social_category_other_kan landholding_category_other_eng landholding_category_other_kan created_at modified_at

* id scheme_id doc_code doc_name is_mandatory sequence_no notes branch_id is_active delete_status created_at updated_at

* id scheme_id caste_category_id gender subsidy_type subsidy_value cap_amount active_status is_delete created_at created_by modified_at modified_by

* id subsidy_scheme_id item_id is_active created_at created_by modified_at modified_by

* id subsidy_scheme_items_id rc_rate tax_percentage rc_rate_include_tax effective_from effective_to delete_status created_at updated_at

* raw_row_id import_batch_id voucher_table voucher_id voucher_no created_at

* id import_batch_id raw_row_id issue_code details created_at

* import_batch_id sheet_name header_row_no h1 h2 h3 h4 h5 h6 h7 h8 h9 h10 created_at

* id import_batch_id sheet_name row_in_sheet c1 c2 c3 c4 c5 c6 c7 c8 c9 c10 created_at

* id import_batch_id raw_row_id txn_date particulars instrument_text vch_type voucher_type_id vch_no debit_amount credit_amount ledger_id correspondent_ledger_id is_ledger is_main_ledger is_main is_correspondent is_others txn_date_forwardfill vch_type_forwardfill vch_no_forwardfill main_ledger_name_ff main_ledger_id_ff is_pair_head is_item item_id item_qty rate_per_item item_uom item_name_key ledger_type created_at

* id ledger_id voucher_type voucher_number voucher_date delete_status type amount narration branch_id created_at updated_at

* id vendor_id ledger_id section_code finance_year_id cumulative_amount created_at updated_at

* id voucher_id voucher_type ledger_id vendor_id section_code amount narration finance_year_id branch_id voucher_date created_at delete_status deleted_by deleted_at

* id section_code description applicable_on rate_percent threshold_per_txn threshold_annual resident_only is_active created_at updated_at

* id agent_id agent_number customer_number caller_id source_module custom_identifier smartflo_uuid status hangup_cause duration_sec recording_url raw_request raw_response raw_webhook created_at updated_at

* id call_id event_type event_time payload_json

* id voucher_type_id transaction_id ledger_id amount hsn_code_id tax_percentage sgst_percentage cgst_percentage igst_percentage cess_percentage tax_amt sgst_amt cgst_amt igst_amt cess_amt is_proportionate branch_id delete_status created_at updated_at

* id title description account_group_id active_status delete_status created_at updated_at

* id voucher_no voucher_date ledger_id ledger_account_id amount gst_amount is_gst_applicable expenditure_category_id branch_id instrument_type instrument_number narration delete_status created_at updated_at expense_date expense_type

* id voucher_type_id voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number amount expense_head gst branch_id user_id narration delete_status created_at updated_at payment_date created_by modified_by finance_year_id bank_name reference_id reference

* id voucher_no voucher_date ledger_id ledger_account_id instrument_type instrument_number amount tds_amount branch_id narration delete_status created_at updated_at received_date user_id finance_year_id bank_name reference_id

* id rule_name rule_scope operator value target_id customer_segment_id coupon_code min_qty min_amount valid_from valid_to priority combine_method is_active branch_id delete_status created_at updated_at

* id user_code name username password email mobile role_id branch_id ledger_id status last_login created_by created_at updated_at delete_status

* id user_id branch_id is_active is_default delete_status created_at updated_at

* id user_email username password_hash role_id emp_id ledger_id default_branch_id financial_year_id delete_status created_at updated_at

* id user_id submenu_id is_voucher_entry sort_order created_at updated_at

* id user_id financial_year_id is_active delete_status created_at updated_at

* id role_id menu_id submenu_id can_add can_edit can_delete can_view branch_id delete_status created_at updated_at

* id role_name dashboard_link dashboard_link_lock_screen is_super_admin branch_id delete_status created_at updated_at

* id applies_to ledger_id tax_proportionate_flag tax_percentage_override_del hsn_sac_code_del remarks branch_id created_at updated_at

* id voucher_type_id financial_year_id branch_id starting_number number_width prefix_zero restart_periodicity restart_applicable_from restart_number prefix_applicable_from prefix_text suffix_applicable_from suffix_text created_at updated_at

* id voucher_code branch_id financial_year_id prefix suffix current_number reset_frequency number_padding

* id voucher_type branch_id financial_year_id prefix suffix current_number

* id voucher_type voucher_id tax_code tax_name tax_rate tax_amount ledger_id branch_id created_at updated_at taxable_value charge_type additional_charge_id

* id voucher_code title abbreviation primary_voucher is_optional is_primary_voucher is_posting is_default update_item_transaction allow_narration auto_print_on_save auto_whatsapp_on_save entry_side is_active is_delete sort_order primary_voucher_type_id created_at updated_at

* id code title abbreviation voucher_mode numbering_method retain_original_number is_optional allow_narration track_additional_costs auto_print_on_save auto_whatsapp_on_save nature is_custom is_active sort_order primary_voucher_type_id created_at updated_at

* id voucher_type_id branch_id finance_year_id voucher_type ledger_id ledger_key_id is_tds_applicable narration_template remarks voucher_flow_type sort_order entry_side is_default is_group_ledger delete_status created_at updated_at

* id provider api_url api_key auth_token sender_number is_active branch_id created_at updated_at

* summary_year branch_id total_sales total_purchases total_receipts total_payments credit_note debit_note finance_year_id

select table alert_logs api_student audit_logs auth_group auth_group_permissions auth_permission auth_user auth_user_groups auth_user_user_permissions bank_master call_followup_master caste_category cnc_jobs cnc_job_parts contra_vouchers coupon_limits coupon_redemptions crm_brochure_queue crm_customer_role crm_enquiry_links_old) crm_leads crm_lead_sources crm_lead_stages crm_quotations crm_service_details crm_service_types crm_tasks crm_tickets crm_tickets_exchange_machine_details crm_ticket_sales crm_ticket_service crm_ticket_status crm_ticket_status_old crm_visits customer_segment daily_financial_summary daily_ledger_balance daily_ledger_movement dashboard_monthly_summary dashboard_summary_snapshot dashboard_yearly_summary date_range_filters discount_categories discount_rule_targets dispatch_details django_admin_log django_content_type django_migrations django_session dynamic_sales_price_competitor_prices dynamic_sales_price_competitor_rules dynamic_sales_price_configs dynamic_sales_price_discounts dynamic_sales_price_margin_rules einvoices_eway_bill einvoice_eway_cancellation email_smtp_settings employees exchange_items exchange_items_value expense_voucher expense_voucher_allocations expense_voucher_allocations_deleted e_invoice_details final_ledger_balance final_ledger_balance_del financial_years gst_api_credentials gst_authcode gst_registration_types invoice_outstanding invoice_print_settings invoice_settings items items_brands items_category items_category_discounts_map items_company items_delivery_sources items_discount_categories items_discount_types items_godowns items_hsn_sac_deleted items_opening_stock items_scheme_discounts items_stock_ledger items_stock_summary items_tax_hsn_sac items_uom item_effective_pricing item_stock_summary item_transactions journal_vouchers journal_voucher_lines ledger_bank_accounts ledger_contact_details ledger_details ledger_entries_cash ledger_groups ledger_keys ledger_opening_balances ledger_party_shipping_details ledger_postings ledger_postings_audit ledger_shipping_details ledger_transactions ledger_types_deleted mastergst_tokens message_queue monthly_financial_summary parts party_comments party_type payment_details_draft payment_followup payment_followup_status payment_purchase_mapping payment_types payment_vouchers payment_voucher_allocations plant_details postings_audit_log posting_audit_log posting_control posting_period_control pricing_recompute_queue purchase_entries purchase_entries_old purchase_entry_items purchase_entry_items_old purchase_invoice_discounts purchase_orders purchase_order_items purchase_received_details purchase_returns purchase_return_items purchase_return_items_old purchase_return_old quotation_entries quotation_entry_items receipt_sales_mapping receipt_vouchers receipt_voucher_allocations report_data_entries sales_cancelled_entries sales_entries sales_entry_items sales_invoice_discounts sales_invoice_exchange sales_invoice_other_discounts sales_invoice_subsidy sales_returns sales_return_items sales_return_reasons sales_settings sales_targets sample_table setting_allowed_ips setting_branch_details setting_countries setting_district setting_main_menu setting_states setting_sub_menu subsidy_receipt_vouchers subsidy_receipt_voucher_allocations subsidy_schemes subsidy_scheme_application_form subsidy_scheme_documents subsidy_scheme_general_caste_rule subsidy_scheme_items subsidy_scheme_items_amount tally_posted_rows tally_posting_issues tally_source_batches tally_source_raw10 tally_source_typed tally_transactions tds_cumulative tds_deductions tds_master telephony_calls telephony_call_events transaction_additional_charges transaction_expenditure_categories transaction_expenditure_vouchers transaction_payment_vouchers_expense transaction_receipt_vouchers_old universal_discount_rules users user_branches user_details user_favorites user_financial_years user_permissions user_roles voucher_additional_charges voucher_numbering_config voucher_series_master voucher_series_master_old voucher_taxes voucher_types voucher_types_old voucher_type_ledger_mappings whatsapp_settings yearly_financial_summary . select column
Show

criteria

Sort	Ascending	Descending
Add as	AND	OR
Op	= > >= < <= != LIKE LIKE %...% NOT LIKE NOT LIKE %...% IN (...) NOT IN (...) BETWEEN NOT BETWEEN IS NULL IS NOT NULL REGEXP REGEXP ^...$ NOT REGEXP	Text Another column
	select table alert_logs api_student audit_logs auth_group auth_group_permissions auth_permission auth_user auth_user_groups auth_user_user_permissions bank_master call_followup_master caste_category cnc_jobs cnc_job_parts contra_vouchers coupon_limits coupon_redemptions crm_brochure_queue crm_customer_role crm_enquiry_links_old) crm_leads crm_lead_sources crm_lead_stages crm_quotations crm_service_details crm_service_types crm_tasks crm_tickets crm_tickets_exchange_machine_details crm_ticket_sales crm_ticket_service crm_ticket_status crm_ticket_status_old crm_visits customer_segment daily_financial_summary daily_ledger_balance daily_ledger_movement dashboard_monthly_summary dashboard_summary_snapshot dashboard_yearly_summary date_range_filters discount_categories discount_rule_targets dispatch_details django_admin_log django_content_type django_migrations django_session dynamic_sales_price_competitor_prices dynamic_sales_price_competitor_rules dynamic_sales_price_configs dynamic_sales_price_discounts dynamic_sales_price_margin_rules einvoices_eway_bill einvoice_eway_cancellation email_smtp_settings employees exchange_items exchange_items_value expense_voucher expense_voucher_allocations expense_voucher_allocations_deleted e_invoice_details final_ledger_balance final_ledger_balance_del financial_years gst_api_credentials gst_authcode gst_registration_types invoice_outstanding invoice_print_settings invoice_settings items items_brands items_category items_category_discounts_map items_company items_delivery_sources items_discount_categories items_discount_types items_godowns items_hsn_sac_deleted items_opening_stock items_scheme_discounts items_stock_ledger items_stock_summary items_tax_hsn_sac items_uom item_effective_pricing item_stock_summary item_transactions journal_vouchers journal_voucher_lines ledger_bank_accounts ledger_contact_details ledger_details ledger_entries_cash ledger_groups ledger_keys ledger_opening_balances ledger_party_shipping_details ledger_postings ledger_postings_audit ledger_shipping_details ledger_transactions ledger_types_deleted mastergst_tokens message_queue monthly_financial_summary parts party_comments party_type payment_details_draft payment_followup payment_followup_status payment_purchase_mapping payment_types payment_vouchers payment_voucher_allocations plant_details postings_audit_log posting_audit_log posting_control posting_period_control pricing_recompute_queue purchase_entries purchase_entries_old purchase_entry_items purchase_entry_items_old purchase_invoice_discounts purchase_orders purchase_order_items purchase_received_details purchase_returns purchase_return_items purchase_return_items_old purchase_return_old quotation_entries quotation_entry_items receipt_sales_mapping receipt_vouchers receipt_voucher_allocations report_data_entries sales_cancelled_entries sales_entries sales_entry_items sales_invoice_discounts sales_invoice_exchange sales_invoice_other_discounts sales_invoice_subsidy sales_returns sales_return_items sales_return_reasons sales_settings sales_targets sample_table setting_allowed_ips setting_branch_details setting_countries setting_district setting_main_menu setting_states setting_sub_menu subsidy_receipt_vouchers subsidy_receipt_voucher_allocations subsidy_schemes subsidy_scheme_application_form subsidy_scheme_documents subsidy_scheme_general_caste_rule subsidy_scheme_items subsidy_scheme_items_amount tally_posted_rows tally_posting_issues tally_source_batches tally_source_raw10 tally_source_typed tally_transactions tds_cumulative tds_deductions tds_master telephony_calls telephony_call_events transaction_additional_charges transaction_expenditure_categories transaction_expenditure_vouchers transaction_payment_vouchers_expense transaction_receipt_vouchers_old universal_discount_rules users user_branches user_details user_favorites user_financial_years user_permissions user_roles voucher_additional_charges voucher_numbering_config voucher_series_master voucher_series_master_old voucher_taxes voucher_types voucher_types_old voucher_type_ledger_mappings whatsapp_settings yearly_financial_summary .	select column