* 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 subsidy_scheme_id item_id delete_status created_at created_by modified_at modified_by

* 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 logo_url 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 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 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 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 entity_type entity_id task_type title due_at assigned_to status notes branch_id created_by created_at updated_at delete_status

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

* id title description 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

* 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

* 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 mail_driver mail_from_name mail_from_email enable_queue host port username password encryption is_active created_at updated_at

* id employee_code full_name designation email mobile_number date_of_joining branch_id user_role_id is_sales_person 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 gst_percent exchange_value branch_id delete_status created_at updated_at

* id voucher_type_id 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 payment_date created_by modified_by finance_year_id bank_name reference_id

* id expense_id invoice_id allocated_amount remarks delete_status created_at updated_at

* 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 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 due_date

* id item_name item_code packing hsn_sac_id item_cat_id godown_id uom_id brand_id company_id price mrp cost purchase_price sale_price tax_rate stock_quantity max_qty min_qty reorder_days low_stock_alert branch_id delete_status created_at updated_at valuation_method item_type item_name_key name_norm aliases_norm

* id brand_name description branch_id is_active delete_status created_at updated_at

* id category_name is_active 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 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 finance_year_id godown_id voucher_type_id in_out_type quantity rate transaction_value transaction_date voucher_id voucher_type reference_table reference_id narration created_at delete_status

* 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 trade_name contact_person_name mail_to address city pincode state_id state_code country_id gst_verified gst_registration_types_id gst_number pan_number company_contact_number whatsapp_number mobile email_id website tags party_cat_id parent_group_id account_group_id led_group_id credit_days credit_amount 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 charge_kind system_ledger_applies_to is_carrier_agent is_default_carrier_agent opening_balance opening_balance_type created_at updated_at

* id ledger_name trade_name led_type_id voucher_type_id sales_entry_id 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 delete_status main_group parent_group_title description active_status created_at updated_at

* id ledger_key header_field description section_code ledger_type editable apply_on 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 credit_period branch_id created_at updated_at delete_status

* 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 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 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 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 transaction_id voucher_type_id voucher_date ledger_id ledger_account_id ledger_account_name instrument_type instrument_number amount branch_id narration received_status move_to_receipt delete_status created_at updated_at

* id payment_transaction_id purchase_entry_id allocated_amount branch_id delete_status 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 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 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 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 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 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 total_amount round_off

* 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_id narration delete_status created_by modified_by created_at updated_at

* id receipt_voucher_id voucher_type_id 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_number voucher_type_id entry_mode proforma_ref_id proforma_status sales_channel sales_person_id source_quotation_id source_sales_id quotation_moved_status voucher_date voucher_time due_date ledger_id party_cat_id invoice_amount price subsidy_scheme_id 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 subsidy_scheme_id subsidy_billed other_discount_applicable 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 invoice_id branch_id exchange_id subsidy_id discount_coupon_code other_discount_amount total_discount remarks selected_other_discount_items selected_subsidy_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 updated_at round_off total_amount posting_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 main_menu display_name url icon sequence is_voucher_entry 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 is_list is_voucher_entry is_report url sequence search_sequence delete_status created_at updated_at

* id scheme_name scheme_code description subsidy_type subsidy_rate subsidy_flat_amount cap_amount active_status

* id scheme_id doc_code doc_name is_mandatory sequence_no notes branch_id 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 voucher_type_id transaction_id ledger_id amount tax_percentage 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 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 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 voucher_type_id ledger_id tax_proportionate_flag tax_percentage_override hsn_sac_code 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

* 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 numbering_method retain_original_number is_optional is_primary_voucher is_posting is_default update_item_transaction allow_narration track_additional_costs auto_print_on_save auto_whatsapp_on_save entry_side is_active 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 voucher_type ledger_id ledger_key_id is_tds_applicable narration_template remarks voucher_flow_type sort_order entry_side is_default 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 assign_item_to_subsidy_scheme audit_logs auth_group auth_group_permissions auth_permission auth_user auth_user_groups auth_user_user_permissions bank_master call_followup_master cnc_jobs cnc_job_parts contra_vouchers coupon_limits coupon_redemptions crm_brochure_queue crm_enquiry_links crm_leads crm_quotations crm_service_details crm_tasks crm_visits customer_segment daily_financial_summary daily_ledger_balance dashboard_monthly_summary dashboard_summary_snapshot dashboard_yearly_summary date_range_filters 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 email_smtp_settings employees exchange_items expense_voucher expense_voucher_allocations final_ledger_balance financial_years gst_registration_types invoice_outstanding 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 items_opening_stock items_scheme_discounts items_stock_ledger items_stock_summary items_tax_hsn_sac items_uom item_effective_pricing 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_postings ledger_postings_audit ledger_shipping_details ledger_transactions ledger_types_deleted mastergst_tokens message_queue monthly_financial_summary parts party_comments payment_details_draft payment_purchase_mapping 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_orders purchase_order_items 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_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_main_menu setting_states setting_sub_menu subsidy_schemes subsidy_scheme_documents tally_posted_rows tally_posting_issues tally_source_batches tally_source_raw10 tally_source_typed tally_transactions tds_cumulative tds_deductions tds_master 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 assign_item_to_subsidy_scheme audit_logs auth_group auth_group_permissions auth_permission auth_user auth_user_groups auth_user_user_permissions bank_master call_followup_master cnc_jobs cnc_job_parts contra_vouchers coupon_limits coupon_redemptions crm_brochure_queue crm_enquiry_links crm_leads crm_quotations crm_service_details crm_tasks crm_visits customer_segment daily_financial_summary daily_ledger_balance dashboard_monthly_summary dashboard_summary_snapshot dashboard_yearly_summary date_range_filters 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 email_smtp_settings employees exchange_items expense_voucher expense_voucher_allocations final_ledger_balance financial_years gst_registration_types invoice_outstanding 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 items_opening_stock items_scheme_discounts items_stock_ledger items_stock_summary items_tax_hsn_sac items_uom item_effective_pricing 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_postings ledger_postings_audit ledger_shipping_details ledger_transactions ledger_types_deleted mastergst_tokens message_queue monthly_financial_summary parts party_comments payment_details_draft payment_purchase_mapping 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_orders purchase_order_items 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_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_main_menu setting_states setting_sub_menu subsidy_schemes subsidy_scheme_documents tally_posted_rows tally_posting_issues tally_source_batches tally_source_raw10 tally_source_typed tally_transactions tds_cumulative tds_deductions tds_master 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