Recent
`sgm_crm`.`purchase_order_items`
`rajkamal_crm`.`voucher_series_master_old`
`rajkamal_crm`.`django_admin_log`
`rajkamal_crm`.`subsidy_scheme_documents`
`payitsea_jnablr`.`a02_set_academic_year`
`payitsea_jnablr`.`a12_set_ltnwise_asign_exam_grp`
`phpmyadmin`.`pma__usergroups`
`payitsea_jnablr`.`a01_set_locations`
`payitsea_jnablr`.`b01_set_exam_parta_group`
`payitsea_jnablr`.`b03_set_exam_parta_mainsubject`
Favourites
There are no favourite tables.
New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
surena_code_editor
surena_crm
edbroad
surena_edbroad_1
surena_edbroad_old
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise appearance of the navigation panel.
Navigation panel
Show databases navigation as tree
In the navigation panel, replaces the database tree with a selector
Link with main panel
Link with main panel by highlighting the current database or table.
Display logo
Show logo in navigation panel.
Logo link URL
URL where logo in the navigation panel will point to.
Logo link target
Open the linked page in the main window (
main
) or in a new one (
new
).
main
new
Enable highlighting
Highlight server under the mouse cursor.
Maximum items on first level
The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box
Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables
Maximum number of recently used tables; set 0 to disable.
Favourite tables
Maximum number of favourite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customise the navigation tree.
Navigation tree
Maximum items in branch
The number of items that can be displayed on each page of the navigation tree.
Group items in the tree
Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion
Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree
Whether to show tables under database in the navigation tree
Show views in tree
Whether to show views under database in the navigation tree
Show functions in tree
Whether to show functions under database in the navigation tree
Show procedures in tree
Whether to show procedures under database in the navigation tree
Show events in tree
Whether to show events under database in the navigation tree
Expand single database
Whether to expand single database in the navigation tree automatically.
Servers
Servers display options.
Servers
Display servers selection
Display server choice at the top of the navigation panel.
Display servers as a list
Show server listing as a list instead of a drop down.
Databases
Databases display options.
Databases
Minimum number of databases to display the database filter box
Database tree separator
String that separates databases into different tree levels.
Tables
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: surena_edbroad_old
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme
Collapse
Expand
Requery
Edit
Explain
Profiling
Bookmark
Query failed
Database :
Queried time :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`alert_logs`.*
`alert_logs`.`id`
`alert_logs`.`alert_type`
`alert_logs`.`alert_message`
`alert_logs`.`triggered_on`
`alert_logs`.`item_id`
`alert_logs`.`ledger_id`
`alert_logs`.`invoice_id`
`alert_logs`.`lead_id`
`alert_logs`.`branch_id`
`alert_logs`.`user_id`
`alert_logs`.`alert_level`
`alert_logs`.`is_read`
`alert_logs`.`resolved`
`alert_logs`.`created_at`
`alert_logs`.`updated_at`
`api_student`.*
`api_student`.`id`
`api_student`.`name`
`api_student`.`age`
`api_student`.`grade`
`assign_item_to_subsidy_scheme`.*
`assign_item_to_subsidy_scheme`.`id`
`assign_item_to_subsidy_scheme`.`subsidy_scheme_id`
`assign_item_to_subsidy_scheme`.`item_id`
`assign_item_to_subsidy_scheme`.`delete_status`
`assign_item_to_subsidy_scheme`.`created_at`
`assign_item_to_subsidy_scheme`.`created_by`
`assign_item_to_subsidy_scheme`.`modified_at`
`assign_item_to_subsidy_scheme`.`modified_by`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`entity_type`
`audit_logs`.`entity_id`
`audit_logs`.`version`
`audit_logs`.`event_type`
`audit_logs`.`reason`
`audit_logs`.`branch_id`
`audit_logs`.`finance_year_id`
`audit_logs`.`changed_by`
`audit_logs`.`changed_at`
`audit_logs`.`changed_ip`
`audit_logs`.`snapshot`
`audit_logs`.`diff`
`audit_logs`.`aux`
`audit_logs`.`hash`
`audit_logs`.`prev_hash`
`audit_logs`.`invoice_no`
`audit_logs`.`voucher_no`
`audit_logs`.`voucher_date`
`auth_group`.*
`auth_group`.`id`
`auth_group`.`name`
`auth_group_permissions`.*
`auth_group_permissions`.`id`
`auth_group_permissions`.`group_id`
`auth_group_permissions`.`permission_id`
`auth_permission`.*
`auth_permission`.`id`
`auth_permission`.`name`
`auth_permission`.`content_type_id`
`auth_permission`.`codename`
`auth_user`.*
`auth_user`.`id`
`auth_user`.`password`
`auth_user`.`last_login`
`auth_user`.`is_superuser`
`auth_user`.`username`
`auth_user`.`first_name`
`auth_user`.`last_name`
`auth_user`.`email`
`auth_user`.`is_staff`
`auth_user`.`is_active`
`auth_user`.`date_joined`
`auth_user_groups`.*
`auth_user_groups`.`id`
`auth_user_groups`.`user_id`
`auth_user_groups`.`group_id`
`auth_user_user_permissions`.*
`auth_user_user_permissions`.`id`
`auth_user_user_permissions`.`user_id`
`auth_user_user_permissions`.`permission_id`
`bank_master`.*
`bank_master`.`id`
`bank_master`.`bank_code`
`bank_master`.`bank_name`
`bank_master`.`short_name`
`bank_master`.`swift_code`
`bank_master`.`logo_url`
`bank_master`.`is_active`
`bank_master`.`created_at`
`bank_master`.`updated_at`
`call_followup_master`.*
`call_followup_master`.`id`
`call_followup_master`.`customer_id`
`call_followup_master`.`customer_name`
`call_followup_master`.`mobile_number`
`call_followup_master`.`call_type`
`call_followup_master`.`due_amount`
`call_followup_master`.`assigned_agent`
`call_followup_master`.`scheduled_date`
`call_followup_master`.`call_status`
`call_followup_master`.`remarks`
`call_followup_master`.`next_followup_date`
`call_followup_master`.`miss_count`
`call_followup_master`.`created_at`
`call_followup_master`.`updated_at`
`cnc_job_parts`.*
`cnc_job_parts`.`id`
`cnc_job_parts`.`job_id`
`cnc_job_parts`.`part_name`
`cnc_job_parts`.`qty`
`cnc_job_parts`.`operation_remark`
`cnc_job_parts`.`delete_status`
`cnc_job_parts`.`created_at`
`cnc_job_parts`.`updated_at`
`cnc_jobs`.*
`cnc_jobs`.`id`
`cnc_jobs`.`branch_id`
`cnc_jobs`.`job_date`
`cnc_jobs`.`shift`
`cnc_jobs`.`operator_code`
`cnc_jobs`.`operator_name`
`cnc_jobs`.`machine_name`
`cnc_jobs`.`job_no`
`cnc_jobs`.`notes`
`cnc_jobs`.`delete_status`
`cnc_jobs`.`created_by`
`cnc_jobs`.`created_at`
`cnc_jobs`.`updated_at`
`contra_vouchers`.*
`contra_vouchers`.`id`
`contra_vouchers`.`voucher_no`
`contra_vouchers`.`voucher_type_id`
`contra_vouchers`.`voucher_date`
`contra_vouchers`.`contra_type`
`contra_vouchers`.`from_account_id`
`contra_vouchers`.`to_account_id`
`contra_vouchers`.`instrument_type`
`contra_vouchers`.`bank_name`
`contra_vouchers`.`instrument_number`
`contra_vouchers`.`amount`
`contra_vouchers`.`narration`
`contra_vouchers`.`branch_id`
`contra_vouchers`.`finance_year_id`
`contra_vouchers`.`created_by`
`contra_vouchers`.`updated_by`
`contra_vouchers`.`delete_status`
`contra_vouchers`.`created_at`
`contra_vouchers`.`updated_at`
`coupon_limits`.*
`coupon_limits`.`coupon_code`
`coupon_limits`.`max_global_uses`
`coupon_limits`.`max_uses_per_customer`
`coupon_limits`.`is_scratch`
`coupon_limits`.`valid_from`
`coupon_limits`.`valid_to`
`coupon_redemptions`.*
`coupon_redemptions`.`id`
`coupon_redemptions`.`coupon_code`
`coupon_redemptions`.`customer_id`
`coupon_redemptions`.`rule_id`
`coupon_redemptions`.`order_ref`
`coupon_redemptions`.`qty`
`coupon_redemptions`.`amount`
`coupon_redemptions`.`branch_id`
`coupon_redemptions`.`redeemed_at`
`crm_brochure_queue`.*
`crm_brochure_queue`.`id`
`crm_brochure_queue`.`enquiry_id`
`crm_brochure_queue`.`medium`
`crm_brochure_queue`.`template_id`
`crm_brochure_queue`.`status`
`crm_brochure_queue`.`scheduled_at`
`crm_brochure_queue`.`sent_at`
`crm_brochure_queue`.`created_by`
`crm_brochure_queue`.`created_at`
`crm_brochure_queue`.`updated_at`
`crm_brochure_queue`.`delete_status`
`crm_enquiry_links`.*
`crm_enquiry_links`.`id`
`crm_enquiry_links`.`enquiry_id`
`crm_enquiry_links`.`link_type`
`crm_enquiry_links`.`target_id`
`crm_enquiry_links`.`created_by`
`crm_enquiry_links`.`created_at`
`crm_leads`.*
`crm_leads`.`id`
`crm_leads`.`lead_type`
`crm_leads`.`customer_company`
`crm_leads`.`contact_person`
`crm_leads`.`phone`
`crm_leads`.`whatsapp`
`crm_leads`.`address`
`crm_leads`.`city`
`crm_leads`.`pincode`
`crm_leads`.`source`
`crm_leads`.`stage`
`crm_leads`.`next_followup`
`crm_leads`.`customer_role`
`crm_leads`.`next_steps`
`crm_leads`.`description`
`crm_leads`.`next_action`
`crm_leads`.`routed_at`
`crm_leads`.`auto_routed`
`crm_leads`.`auto_route_json`
`crm_leads`.`auto_route_conf`
`crm_leads`.`handled_by`
`crm_leads`.`branch_id`
`crm_leads`.`status`
`crm_leads`.`created_by`
`crm_leads`.`created_at`
`crm_leads`.`updated_at`
`crm_leads`.`delete_status`
`crm_quotations`.*
`crm_quotations`.`id`
`crm_quotations`.`enquiry_id`
`crm_quotations`.`customer_company`
`crm_quotations`.`contact_phone`
`crm_quotations`.`city`
`crm_quotations`.`stage`
`crm_quotations`.`remarks`
`crm_quotations`.`created_by`
`crm_quotations`.`created_at`
`crm_quotations`.`updated_at`
`crm_quotations`.`delete_status`
`crm_service_details`.*
`crm_service_details`.`id`
`crm_service_details`.`lead_id`
`crm_service_details`.`service_type`
`crm_service_details`.`machine_model`
`crm_service_details`.`serial_no`
`crm_service_details`.`preferred_visit_date`
`crm_service_details`.`technician_id`
`crm_service_details`.`priority`
`crm_service_details`.`warranty`
`crm_service_details`.`notes`
`crm_service_details`.`created_at`
`crm_service_details`.`updated_at`
`crm_tasks`.*
`crm_tasks`.`id`
`crm_tasks`.`entity_type`
`crm_tasks`.`entity_id`
`crm_tasks`.`task_type`
`crm_tasks`.`title`
`crm_tasks`.`due_at`
`crm_tasks`.`assigned_to`
`crm_tasks`.`status`
`crm_tasks`.`notes`
`crm_tasks`.`branch_id`
`crm_tasks`.`created_by`
`crm_tasks`.`created_at`
`crm_tasks`.`updated_at`
`crm_tasks`.`delete_status`
`crm_visits`.*
`crm_visits`.`id`
`crm_visits`.`enquiry_id`
`crm_visits`.`scheduled_at`
`crm_visits`.`address`
`crm_visits`.`city`
`crm_visits`.`pincode`
`crm_visits`.`assigned_to`
`crm_visits`.`status`
`crm_visits`.`notes`
`crm_visits`.`created_by`
`crm_visits`.`created_at`
`crm_visits`.`updated_at`
`crm_visits`.`delete_status`
`customer_segment`.*
`customer_segment`.`id`
`customer_segment`.`title`
`customer_segment`.`description`
`customer_segment`.`active_status`
`customer_segment`.`branch_id`
`customer_segment`.`created_by`
`customer_segment`.`modified_by`
`customer_segment`.`created_at`
`customer_segment`.`updated_at`
`customer_segment`.`delete_status`
`daily_financial_summary`.*
`daily_financial_summary`.`summary_date`
`daily_financial_summary`.`branch_id`
`daily_financial_summary`.`total_sales`
`daily_financial_summary`.`total_purchases`
`daily_financial_summary`.`total_receipts`
`daily_financial_summary`.`total_payments`
`daily_ledger_balance`.*
`daily_ledger_balance`.`summary_date`
`daily_ledger_balance`.`ledger_id`
`daily_ledger_balance`.`branch_id`
`daily_ledger_balance`.`dr_amount`
`daily_ledger_balance`.`cr_amount`
`dashboard_monthly_summary`.*
`dashboard_monthly_summary`.`summary_year`
`dashboard_monthly_summary`.`summary_month`
`dashboard_monthly_summary`.`total_sales`
`dashboard_monthly_summary`.`total_purchases`
`dashboard_monthly_summary`.`total_sales_return`
`dashboard_monthly_summary`.`total_purchase_return`
`dashboard_monthly_summary`.`total_revenue`
`dashboard_monthly_summary`.`total_expenditure`
`dashboard_monthly_summary`.`total_profit`
`dashboard_monthly_summary`.`created_at`
`dashboard_summary_snapshot`.*
`dashboard_summary_snapshot`.`id`
`dashboard_summary_snapshot`.`total_sales`
`dashboard_summary_snapshot`.`total_purchases`
`dashboard_summary_snapshot`.`total_sales_return`
`dashboard_summary_snapshot`.`total_purchase_return`
`dashboard_summary_snapshot`.`total_revenue`
`dashboard_summary_snapshot`.`total_expenditure`
`dashboard_summary_snapshot`.`total_profit`
`dashboard_summary_snapshot`.`top_customer`
`dashboard_summary_snapshot`.`top_item`
`dashboard_summary_snapshot`.`total_customers`
`dashboard_summary_snapshot`.`total_suppliers`
`dashboard_summary_snapshot`.`total_visits`
`dashboard_summary_snapshot`.`total_leads`
`dashboard_summary_snapshot`.`total_employees`
`dashboard_summary_snapshot`.`summary_date`
`dashboard_summary_snapshot`.`last_updated`
`dashboard_yearly_summary`.*
`dashboard_yearly_summary`.`summary_year`
`dashboard_yearly_summary`.`total_sales`
`dashboard_yearly_summary`.`total_purchases`
`dashboard_yearly_summary`.`total_sales_return`
`dashboard_yearly_summary`.`total_purchase_return`
`dashboard_yearly_summary`.`total_revenue`
`dashboard_yearly_summary`.`total_expenditure`
`dashboard_yearly_summary`.`total_profit`
`dashboard_yearly_summary`.`created_at`
`date_range_filters`.*
`date_range_filters`.`id`
`date_range_filters`.`filter_name`
`date_range_filters`.`query_value`
`date_range_filters`.`is_active`
`discount_rule_targets`.*
`discount_rule_targets`.`target_id`
`discount_rule_targets`.`discount_rule_id`
`discount_rule_targets`.`target_type`
`discount_rule_targets`.`target_ref_id`
`discount_rule_targets`.`customer_segment_id`
`discount_rule_targets`.`discount_value`
`discount_rule_targets`.`operator_override`
`discount_rule_targets`.`min_qty_override`
`discount_rule_targets`.`min_amount_override`
`discount_rule_targets`.`combine_override`
`discount_rule_targets`.`priority_override`
`discount_rule_targets`.`branch_id`
`discount_rule_targets`.`delete_status`
`discount_rule_targets`.`created_at`
`discount_rule_targets`.`updated_at`
`dispatch_details`.*
`dispatch_details`.`id`
`dispatch_details`.`sales_entry_id`
`dispatch_details`.`voucher_type_id`
`dispatch_details`.`delivery_note_no`
`dispatch_details`.`dispatch_doc_no`
`dispatch_details`.`dispatch_date`
`dispatch_details`.`dispatched_through`
`dispatch_details`.`destination`
`dispatch_details`.`carrier_ledger_id`
`dispatch_details`.`bill_of_lading`
`dispatch_details`.`lr_rr_date`
`dispatch_details`.`motor_vehicle_no`
`dispatch_details`.`buyer_order_no`
`dispatch_details`.`buyer_date`
`dispatch_details`.`branch_id`
`dispatch_details`.`created_by`
`dispatch_details`.`created_at`
`dispatch_details`.`updated_at`
`dispatch_details`.`delete_status`
`django_admin_log`.*
`django_admin_log`.`id`
`django_admin_log`.`action_time`
`django_admin_log`.`object_id`
`django_admin_log`.`object_repr`
`django_admin_log`.`action_flag`
`django_admin_log`.`change_message`
`django_admin_log`.`content_type_id`
`django_admin_log`.`user_id`
`django_content_type`.*
`django_content_type`.`id`
`django_content_type`.`app_label`
`django_content_type`.`model`
`django_migrations`.*
`django_migrations`.`id`
`django_migrations`.`app`
`django_migrations`.`name`
`django_migrations`.`applied`
`django_session`.*
`django_session`.`session_key`
`django_session`.`session_data`
`django_session`.`expire_date`
`dynamic_sales_price_competitor_prices`.*
`dynamic_sales_price_competitor_prices`.`competitor_price_id`
`dynamic_sales_price_competitor_prices`.`item_id`
`dynamic_sales_price_competitor_prices`.`competitor_name`
`dynamic_sales_price_competitor_prices`.`price`
`dynamic_sales_price_competitor_prices`.`branch_id`
`dynamic_sales_price_competitor_prices`.`last_checked`
`dynamic_sales_price_competitor_prices`.`is_active`
`dynamic_sales_price_competitor_prices`.`delete_status`
`dynamic_sales_price_competitor_prices`.`created_by`
`dynamic_sales_price_competitor_prices`.`updated_by`
`dynamic_sales_price_competitor_prices`.`created_at`
`dynamic_sales_price_competitor_prices`.`updated_at`
`dynamic_sales_price_competitor_rules`.*
`dynamic_sales_price_competitor_rules`.`id`
`dynamic_sales_price_competitor_rules`.`item_id`
`dynamic_sales_price_competitor_rules`.`strategy`
`dynamic_sales_price_competitor_rules`.`undercut_value`
`dynamic_sales_price_competitor_rules`.`branch_id`
`dynamic_sales_price_competitor_rules`.`is_active`
`dynamic_sales_price_competitor_rules`.`delete_status`
`dynamic_sales_price_competitor_rules`.`created_by`
`dynamic_sales_price_competitor_rules`.`updated_by`
`dynamic_sales_price_competitor_rules`.`created_at`
`dynamic_sales_price_competitor_rules`.`updated_at`
`dynamic_sales_price_configs`.*
`dynamic_sales_price_configs`.`id`
`dynamic_sales_price_configs`.`branch_id`
`dynamic_sales_price_configs`.`item_id`
`dynamic_sales_price_configs`.`brand_id`
`dynamic_sales_price_configs`.`category_id`
`dynamic_sales_price_configs`.`pricing_strategy`
`dynamic_sales_price_configs`.`costing_method`
`dynamic_sales_price_configs`.`min_margin_percent`
`dynamic_sales_price_configs`.`allow_competitor_price`
`dynamic_sales_price_configs`.`competitor_alignment_mode`
`dynamic_sales_price_configs`.`competitor_floor_margin_pct`
`dynamic_sales_price_configs`.`stock_low_threshold`
`dynamic_sales_price_configs`.`stock_high_threshold`
`dynamic_sales_price_configs`.`stock_low_markup_pct`
`dynamic_sales_price_configs`.`stock_high_markdown_pct`
`dynamic_sales_price_configs`.`average_sales_lookback_days`
`dynamic_sales_price_configs`.`rounding_rule`
`dynamic_sales_price_configs`.`effective_from`
`dynamic_sales_price_configs`.`effective_to`
`dynamic_sales_price_configs`.`delete_status`
`dynamic_sales_price_configs`.`created_at`
`dynamic_sales_price_configs`.`updated_at`
`dynamic_sales_price_discounts`.*
`dynamic_sales_price_discounts`.`id`
`dynamic_sales_price_discounts`.`rule_name`
`dynamic_sales_price_discounts`.`rule_type`
`dynamic_sales_price_discounts`.`reference_id`
`dynamic_sales_price_discounts`.`discount_type`
`dynamic_sales_price_discounts`.`discount_value`
`dynamic_sales_price_discounts`.`valid_from`
`dynamic_sales_price_discounts`.`valid_to`
`dynamic_sales_price_discounts`.`branch_id`
`dynamic_sales_price_discounts`.`is_active`
`dynamic_sales_price_discounts`.`delete_status`
`dynamic_sales_price_discounts`.`created_by`
`dynamic_sales_price_discounts`.`updated_by`
`dynamic_sales_price_discounts`.`created_at`
`dynamic_sales_price_discounts`.`updated_at`
`dynamic_sales_price_margin_rules`.*
`dynamic_sales_price_margin_rules`.`id`
`dynamic_sales_price_margin_rules`.`rule_type`
`dynamic_sales_price_margin_rules`.`reference_id`
`dynamic_sales_price_margin_rules`.`margin_percent`
`dynamic_sales_price_margin_rules`.`branch_id`
`dynamic_sales_price_margin_rules`.`is_active`
`dynamic_sales_price_margin_rules`.`delete_status`
`dynamic_sales_price_margin_rules`.`created_by`
`dynamic_sales_price_margin_rules`.`updated_by`
`dynamic_sales_price_margin_rules`.`created_at`
`dynamic_sales_price_margin_rules`.`updated_at`
`email_smtp_settings`.*
`email_smtp_settings`.`id`
`email_smtp_settings`.`mail_driver`
`email_smtp_settings`.`mail_from_name`
`email_smtp_settings`.`mail_from_email`
`email_smtp_settings`.`enable_queue`
`email_smtp_settings`.`host`
`email_smtp_settings`.`port`
`email_smtp_settings`.`username`
`email_smtp_settings`.`password`
`email_smtp_settings`.`encryption`
`email_smtp_settings`.`is_active`
`email_smtp_settings`.`created_at`
`email_smtp_settings`.`updated_at`
`employees`.*
`employees`.`id`
`employees`.`employee_code`
`employees`.`full_name`
`employees`.`designation`
`employees`.`email`
`employees`.`mobile_number`
`employees`.`date_of_joining`
`employees`.`branch_id`
`employees`.`user_role_id`
`employees`.`is_sales_person`
`employees`.`reporting_manager_id`
`employees`.`login_user_id`
`employees`.`address`
`employees`.`city`
`employees`.`state_id`
`employees`.`country_id`
`employees`.`pincode`
`employees`.`is_active`
`employees`.`delete_status`
`employees`.`created_at`
`employees`.`updated_at`
`exchange_items`.*
`exchange_items`.`id`
`exchange_items`.`item_name`
`exchange_items`.`item_code`
`exchange_items`.`item_description`
`exchange_items`.`mrp`
`exchange_items`.`gst_percent`
`exchange_items`.`exchange_value`
`exchange_items`.`branch_id`
`exchange_items`.`delete_status`
`exchange_items`.`created_at`
`exchange_items`.`updated_at`
`expense_voucher`.*
`expense_voucher`.`id`
`expense_voucher`.`voucher_type_id`
`expense_voucher`.`voucher_no`
`expense_voucher`.`voucher_date`
`expense_voucher`.`ledger_id`
`expense_voucher`.`ledger_account_id`
`expense_voucher`.`expense_head`
`expense_voucher`.`gst_aplicability`
`expense_voucher`.`ref_bill_no`
`expense_voucher`.`instrument_type`
`expense_voucher`.`instrument_number`
`expense_voucher`.`amount`
`expense_voucher`.`branch_id`
`expense_voucher`.`user_id`
`expense_voucher`.`narration`
`expense_voucher`.`delete_status`
`expense_voucher`.`created_at`
`expense_voucher`.`updated_at`
`expense_voucher`.`payment_date`
`expense_voucher`.`created_by`
`expense_voucher`.`modified_by`
`expense_voucher`.`finance_year_id`
`expense_voucher`.`bank_name`
`expense_voucher`.`reference_id`
`expense_voucher_allocations`.*
`expense_voucher_allocations`.`id`
`expense_voucher_allocations`.`expense_id`
`expense_voucher_allocations`.`invoice_id`
`expense_voucher_allocations`.`allocated_amount`
`expense_voucher_allocations`.`remarks`
`expense_voucher_allocations`.`delete_status`
`expense_voucher_allocations`.`created_at`
`expense_voucher_allocations`.`updated_at`
`final_ledger_balance`.*
`final_ledger_balance`.`ledger_id`
`final_ledger_balance`.`branch_id`
`final_ledger_balance`.`finance_year_id`
`final_ledger_balance`.`opening_balance`
`final_ledger_balance`.`transaction_dr`
`final_ledger_balance`.`transaction_cr`
`final_ledger_balance`.`closing_balance`
`financial_years`.*
`financial_years`.`id`
`financial_years`.`branch_id`
`financial_years`.`year`
`financial_years`.`fiscal_year`
`financial_years`.`start_date`
`financial_years`.`end_date`
`financial_years`.`delete_status`
`financial_years`.`created_at`
`financial_years`.`updated_at`
`gst_registration_types`.*
`gst_registration_types`.`id`
`gst_registration_types`.`type_name`
`gst_registration_types`.`description`
`gst_registration_types`.`is_default`
`gst_registration_types`.`is_active`
`gst_registration_types`.`delete_status`
`gst_registration_types`.`created_at`
`gst_registration_types`.`updated_at`
`invoice_outstanding`.*
`invoice_outstanding`.`id`
`invoice_outstanding`.`voucher_type_id`
`invoice_outstanding`.`voucher_id`
`invoice_outstanding`.`voucher_number`
`invoice_outstanding`.`ledger_id`
`invoice_outstanding`.`invoice_date`
`invoice_outstanding`.`dr_amount`
`invoice_outstanding`.`cr_amount`
`invoice_outstanding`.`branch_id`
`invoice_outstanding`.`finance_year_id`
`invoice_outstanding`.`narration`
`invoice_outstanding`.`created_at`
`invoice_outstanding`.`updated_at`
`invoice_outstanding`.`delete_status`
`invoice_outstanding`.`due_date`
`item_effective_pricing`.*
`item_effective_pricing`.`branch_id`
`item_effective_pricing`.`item_id`
`item_effective_pricing`.`price_basis`
`item_effective_pricing`.`base_price`
`item_effective_pricing`.`unit_price`
`item_effective_pricing`.`applied_rules_json`
`item_effective_pricing`.`rules_hash`
`item_effective_pricing`.`valid_from`
`item_effective_pricing`.`valid_to`
`item_effective_pricing`.`updated_at`
`item_transactions`.*
`item_transactions`.`id`
`item_transactions`.`item_id`
`item_transactions`.`branch_id`
`item_transactions`.`finance_year_id`
`item_transactions`.`godown_id`
`item_transactions`.`voucher_type_id`
`item_transactions`.`in_out_type`
`item_transactions`.`quantity`
`item_transactions`.`rate`
`item_transactions`.`transaction_value`
`item_transactions`.`transaction_date`
`item_transactions`.`voucher_id`
`item_transactions`.`voucher_type`
`item_transactions`.`reference_table`
`item_transactions`.`reference_id`
`item_transactions`.`narration`
`item_transactions`.`created_at`
`item_transactions`.`delete_status`
`items`.*
`items`.`id`
`items`.`item_name`
`items`.`item_code`
`items`.`packing`
`items`.`hsn_sac_id`
`items`.`item_cat_id`
`items`.`godown_id`
`items`.`uom_id`
`items`.`brand_id`
`items`.`company_id`
`items`.`price`
`items`.`mrp`
`items`.`cost`
`items`.`purchase_price`
`items`.`sale_price`
`items`.`tax_rate`
`items`.`stock_quantity`
`items`.`max_qty`
`items`.`min_qty`
`items`.`reorder_days`
`items`.`low_stock_alert`
`items`.`branch_id`
`items`.`delete_status`
`items`.`created_at`
`items`.`updated_at`
`items`.`valuation_method`
`items`.`item_type`
`items`.`item_name_key`
`items`.`name_norm`
`items`.`aliases_norm`
`items_brands`.*
`items_brands`.`id`
`items_brands`.`brand_name`
`items_brands`.`description`
`items_brands`.`branch_id`
`items_brands`.`is_active`
`items_brands`.`delete_status`
`items_brands`.`created_at`
`items_brands`.`updated_at`
`items_category`.*
`items_category`.`id`
`items_category`.`category_name`
`items_category`.`is_active`
`items_category`.`description`
`items_category`.`branch_id`
`items_category`.`delete_status`
`items_category`.`created_at`
`items_category`.`updated_at`
`items_category_discounts_map`.*
`items_category_discounts_map`.`id`
`items_category_discounts_map`.`item_cat_id`
`items_category_discounts_map`.`discount_source`
`items_category_discounts_map`.`source_id`
`items_category_discounts_map`.`discount_type`
`items_category_discounts_map`.`discount_value`
`items_category_discounts_map`.`is_active`
`items_category_discounts_map`.`branch_id`
`items_category_discounts_map`.`created_at`
`items_category_discounts_map`.`updated_at`
`items_company`.*
`items_company`.`id`
`items_company`.`company_name`
`items_company`.`description`
`items_company`.`branch_id`
`items_company`.`is_active`
`items_company`.`delete_status`
`items_company`.`created_at`
`items_company`.`updated_at`
`items_delivery_sources`.*
`items_delivery_sources`.`id`
`items_delivery_sources`.`code`
`items_delivery_sources`.`title`
`items_delivery_sources`.`description`
`items_delivery_sources`.`active_status`
`items_delivery_sources`.`created_at`
`items_delivery_sources`.`updated_at`
`items_discount_categories`.*
`items_discount_categories`.`id`
`items_discount_categories`.`category_name`
`items_discount_categories`.`description`
`items_discount_categories`.`discount_type_id`
`items_discount_categories`.`discount_type`
`items_discount_categories`.`is_default`
`items_discount_categories`.`delete_status`
`items_discount_categories`.`created_at`
`items_discount_categories`.`updated_at`
`items_discount_types`.*
`items_discount_types`.`id`
`items_discount_types`.`discount_type_name`
`items_discount_types`.`description`
`items_discount_types`.`is_active`
`items_discount_types`.`delete_status`
`items_discount_types`.`created_at`
`items_discount_types`.`updated_at`
`items_godowns`.*
`items_godowns`.`id`
`items_godowns`.`godown_name`
`items_godowns`.`code`
`items_godowns`.`description`
`items_godowns`.`branch_id`
`items_godowns`.`address`
`items_godowns`.`city`
`items_godowns`.`pincode`
`items_godowns`.`state_id`
`items_godowns`.`country_id`
`items_godowns`.`contact_number`
`items_godowns`.`email`
`items_godowns`.`incharge_name`
`items_godowns`.`is_primary`
`items_godowns`.`active_status`
`items_godowns`.`delete_status`
`items_godowns`.`created_at`
`items_godowns`.`updated_at`
`items_hsn_sac`.*
`items_hsn_sac`.`id`
`items_hsn_sac`.`hsn_sac_code`
`items_hsn_sac`.`effective_date`
`items_hsn_sac`.`active_status`
`items_hsn_sac`.`gst`
`items_hsn_sac`.`cgst`
`items_hsn_sac`.`sgst`
`items_hsn_sac`.`igst`
`items_hsn_sac`.`cess`
`items_hsn_sac`.`branch_id`
`items_hsn_sac`.`is_delete`
`items_hsn_sac`.`created_at`
`items_hsn_sac`.`updated_at`
`items_opening_stock`.*
`items_opening_stock`.`id`
`items_opening_stock`.`item_id`
`items_opening_stock`.`branch_id`
`items_opening_stock`.`finance_year_id`
`items_opening_stock`.`opening_qty`
`items_opening_stock`.`opening_rate`
`items_opening_stock`.`opening_value`
`items_opening_stock`.`created_at`
`items_opening_stock`.`updated_at`
`items_scheme_discounts`.*
`items_scheme_discounts`.`id`
`items_scheme_discounts`.`scheme_name`
`items_scheme_discounts`.`discount_type_id`
`items_scheme_discounts`.`discount_type`
`items_scheme_discounts`.`applicable_districts`
`items_scheme_discounts`.`effective_from`
`items_scheme_discounts`.`effective_to`
`items_scheme_discounts`.`poster_image`
`items_scheme_discounts`.`branch_id`
`items_scheme_discounts`.`is_active`
`items_scheme_discounts`.`delete_status`
`items_scheme_discounts`.`created_at`
`items_scheme_discounts`.`updated_at`
`items_stock_ledger`.*
`items_stock_ledger`.`id`
`items_stock_ledger`.`item_id`
`items_stock_ledger`.`branch_id`
`items_stock_ledger`.`trans_type`
`items_stock_ledger`.`trans_ref_id`
`items_stock_ledger`.`trans_date`
`items_stock_ledger`.`qty_in`
`items_stock_ledger`.`qty_out`
`items_stock_ledger`.`balance_qty`
`items_stock_ledger`.`narration`
`items_stock_ledger`.`created_at`
`items_stock_summary`.*
`items_stock_summary`.`id`
`items_stock_summary`.`item_id`
`items_stock_summary`.`branch_id`
`items_stock_summary`.`opening_qty`
`items_stock_summary`.`inward_qty`
`items_stock_summary`.`outward_qty`
`items_stock_summary`.`closing_qty`
`items_stock_summary`.`last_updated`
`items_tax_hsn_sac`.*
`items_tax_hsn_sac`.`id`
`items_tax_hsn_sac`.`hsn_sac_code`
`items_tax_hsn_sac`.`tax_percentage`
`items_tax_hsn_sac`.`cgst`
`items_tax_hsn_sac`.`sgst`
`items_tax_hsn_sac`.`igst`
`items_tax_hsn_sac`.`cess`
`items_tax_hsn_sac`.`tax_type`
`items_tax_hsn_sac`.`tax_group_name`
`items_tax_hsn_sac`.`effective_date`
`items_tax_hsn_sac`.`active_status`
`items_tax_hsn_sac`.`branch_id`
`items_tax_hsn_sac`.`company_id`
`items_tax_hsn_sac`.`state_id`
`items_tax_hsn_sac`.`country_id`
`items_tax_hsn_sac`.`is_delete`
`items_tax_hsn_sac`.`created_at`
`items_tax_hsn_sac`.`updated_at`
`items_uom`.*
`items_uom`.`id`
`items_uom`.`uom_name`
`items_uom`.`uom_code`
`items_uom`.`description`
`items_uom`.`branch_id`
`items_uom`.`created_at`
`items_uom`.`updated_at`
`items_uom`.`delete_status`
`journal_voucher_lines`.*
`journal_voucher_lines`.`id`
`journal_voucher_lines`.`journal_voucher_id`
`journal_voucher_lines`.`ledger_id`
`journal_voucher_lines`.`dr_amount`
`journal_voucher_lines`.`cr_amount`
`journal_voucher_lines`.`delete_status`
`journal_voucher_lines`.`created_at`
`journal_voucher_lines`.`updated_at`
`journal_vouchers`.*
`journal_vouchers`.`id`
`journal_vouchers`.`voucher_number`
`journal_vouchers`.`voucher_type_id`
`journal_vouchers`.`voucher_date`
`journal_vouchers`.`journal_date`
`journal_vouchers`.`branch_id`
`journal_vouchers`.`finance_year_id`
`journal_vouchers`.`narration`
`journal_vouchers`.`posting_status`
`journal_vouchers`.`delete_status`
`journal_vouchers`.`created_by`
`journal_vouchers`.`updated_by`
`journal_vouchers`.`created_at`
`journal_vouchers`.`updated_at`
`ledger_bank_accounts`.*
`ledger_bank_accounts`.`id`
`ledger_bank_accounts`.`ledger_id`
`ledger_bank_accounts`.`branch_id`
`ledger_bank_accounts`.`account_name`
`ledger_bank_accounts`.`account_no`
`ledger_bank_accounts`.`ifsc_code`
`ledger_bank_accounts`.`bank_name`
`ledger_bank_accounts`.`branch_name`
`ledger_bank_accounts`.`account_type`
`ledger_bank_accounts`.`upi_id`
`ledger_bank_accounts`.`swift_code`
`ledger_bank_accounts`.`micr_code`
`ledger_bank_accounts`.`bank_details_applies_to`
`ledger_bank_accounts`.`is_primary`
`ledger_bank_accounts`.`opening_balance`
`ledger_bank_accounts`.`balance_type`
`ledger_bank_accounts`.`notes`
`ledger_bank_accounts`.`active_status`
`ledger_bank_accounts`.`delete_status`
`ledger_bank_accounts`.`created_at`
`ledger_bank_accounts`.`updated_at`
`ledger_contact_details`.*
`ledger_contact_details`.`id`
`ledger_contact_details`.`ledger_id`
`ledger_contact_details`.`contact_person_name`
`ledger_contact_details`.`contact_person_last_name`
`ledger_contact_details`.`designation`
`ledger_contact_details`.`contact_number`
`ledger_contact_details`.`whatsapp_number`
`ledger_contact_details`.`email_address`
`ledger_contact_details`.`is_primary`
`ledger_contact_details`.`created_at`
`ledger_contact_details`.`updated_at`
`ledger_details`.*
`ledger_details`.`id`
`ledger_details`.`ledger_name`
`ledger_details`.`trade_name`
`ledger_details`.`contact_person_name`
`ledger_details`.`mail_to`
`ledger_details`.`address`
`ledger_details`.`city`
`ledger_details`.`pincode`
`ledger_details`.`state_id`
`ledger_details`.`state_code`
`ledger_details`.`country_id`
`ledger_details`.`gst_verified`
`ledger_details`.`gst_registration_types_id`
`ledger_details`.`gst_number`
`ledger_details`.`pan_number`
`ledger_details`.`company_contact_number`
`ledger_details`.`whatsapp_number`
`ledger_details`.`mobile`
`ledger_details`.`email_id`
`ledger_details`.`website`
`ledger_details`.`tags`
`ledger_details`.`party_cat_id`
`ledger_details`.`parent_group_id`
`ledger_details`.`account_group_id`
`ledger_details`.`led_group_id`
`ledger_details`.`credit_days`
`ledger_details`.`credit_amount`
`ledger_details`.`credit_limit`
`ledger_details`.`auto_block_on_overdue`
`ledger_details`.`delivery_source`
`ledger_details`.`delivery_source_id`
`ledger_details`.`branch_id`
`ledger_details`.`delete_status`
`ledger_details`.`module`
`ledger_details`.`ledger_key_id`
`ledger_details`.`voucher_type_id`
`ledger_details`.`tds_section_code`
`ledger_details`.`ledger_type`
`ledger_details`.`charge_kind`
`ledger_details`.`system_ledger_applies_to`
`ledger_details`.`is_carrier_agent`
`ledger_details`.`is_default_carrier_agent`
`ledger_details`.`opening_balance`
`ledger_details`.`opening_balance_type`
`ledger_details`.`created_at`
`ledger_details`.`updated_at`
`ledger_entries_cash`.*
`ledger_entries_cash`.`id`
`ledger_entries_cash`.`ledger_name`
`ledger_entries_cash`.`trade_name`
`ledger_entries_cash`.`led_type_id`
`ledger_entries_cash`.`voucher_type_id`
`ledger_entries_cash`.`sales_entry_id`
`ledger_entries_cash`.`address`
`ledger_entries_cash`.`city`
`ledger_entries_cash`.`pincode`
`ledger_entries_cash`.`state_id`
`ledger_entries_cash`.`country_id`
`ledger_entries_cash`.`gst_registration_types_id`
`ledger_entries_cash`.`gst_number`
`ledger_entries_cash`.`pan_number`
`ledger_entries_cash`.`company_contact_number`
`ledger_entries_cash`.`whatsapp_number`
`ledger_entries_cash`.`email_id`
`ledger_entries_cash`.`delivery_source`
`ledger_entries_cash`.`branch_id`
`ledger_entries_cash`.`delete_status`
`ledger_entries_cash`.`created_at`
`ledger_entries_cash`.`updated_at`
`ledger_groups`.*
`ledger_groups`.`id`
`ledger_groups`.`title`
`ledger_groups`.`parent_group_id`
`ledger_groups`.`is_primary`
`ledger_groups`.`is_secondary`
`ledger_groups`.`sub_group`
`ledger_groups`.`delete_status`
`ledger_groups`.`main_group`
`ledger_groups`.`parent_group_title`
`ledger_groups`.`description`
`ledger_groups`.`active_status`
`ledger_groups`.`created_at`
`ledger_groups`.`updated_at`
`ledger_keys`.*
`ledger_keys`.`id`
`ledger_keys`.`ledger_key`
`ledger_keys`.`header_field`
`ledger_keys`.`description`
`ledger_keys`.`section_code`
`ledger_keys`.`ledger_type`
`ledger_keys`.`editable`
`ledger_keys`.`apply_on`
`ledger_keys`.`module`
`ledger_keys`.`account_category`
`ledger_keys`.`account_group`
`ledger_keys`.`default_ledger`
`ledger_keys`.`is_active`
`ledger_keys`.`created_at`
`ledger_keys`.`created_by`
`ledger_keys`.`updated_at`
`ledger_keys`.`updated_by`
`ledger_keys`.`external_ref_code`
`ledger_opening_balances`.*
`ledger_opening_balances`.`id`
`ledger_opening_balances`.`ledger_id`
`ledger_opening_balances`.`finance_year_id`
`ledger_opening_balances`.`financial_year`
`ledger_opening_balances`.`opening_debit`
`ledger_opening_balances`.`opening_credit`
`ledger_opening_balances`.`credit_period`
`ledger_opening_balances`.`branch_id`
`ledger_opening_balances`.`created_at`
`ledger_opening_balances`.`updated_at`
`ledger_opening_balances`.`delete_status`
`ledger_postings`.*
`ledger_postings`.`id`
`ledger_postings`.`posting_date`
`ledger_postings`.`txn_date`
`ledger_postings`.`voucher_id`
`ledger_postings`.`voucher_no`
`ledger_postings`.`voucher_type_id`
`ledger_postings`.`voucher_date`
`ledger_postings`.`ledger_id`
`ledger_postings`.`group_id`
`ledger_postings`.`parent_group_id`
`ledger_postings`.`entry_side`
`ledger_postings`.`dr_amount`
`ledger_postings`.`cr_amount`
`ledger_postings`.`branch_id`
`ledger_postings`.`finance_year_id`
`ledger_postings`.`user_id`
`ledger_postings`.`narration`
`ledger_postings`.`sort_order`
`ledger_postings`.`is_main_row`
`ledger_postings`.`cash_or_bank`
`ledger_postings`.`by_or_to`
`ledger_postings`.`other_details`
`ledger_postings`.`correspondent_ledger_id`
`ledger_postings`.`created_at`
`ledger_postings`.`updated_at`
`ledger_postings`.`delete_status`
`ledger_postings`.`deleted_by`
`ledger_postings`.`deleted_at`
`ledger_postings_audit`.*
`ledger_postings_audit`.`id`
`ledger_postings_audit`.`posting_date`
`ledger_postings_audit`.`voucher_id`
`ledger_postings_audit`.`line_no`
`ledger_postings_audit`.`voucher_no`
`ledger_postings_audit`.`voucher_type_id`
`ledger_postings_audit`.`voucher_date`
`ledger_postings_audit`.`ledger_id`
`ledger_postings_audit`.`ledger_group_id`
`ledger_postings_audit`.`amount_signed`
`ledger_postings_audit`.`currency_code`
`ledger_postings_audit`.`fx_rate`
`ledger_postings_audit`.`amount_base`
`ledger_postings_audit`.`branch_id`
`ledger_postings_audit`.`finance_year_id`
`ledger_postings_audit`.`user_id`
`ledger_postings_audit`.`narration`
`ledger_postings_audit`.`correspondent_ledger_id`
`ledger_postings_audit`.`corr_ledger_group_id`
`ledger_postings_audit`.`instrument_no`
`ledger_postings_audit`.`instrument_date`
`ledger_postings_audit`.`recon_status`
`ledger_postings_audit`.`recon_date`
`ledger_postings_audit`.`cost_center_id`
`ledger_postings_audit`.`project_id`
`ledger_postings_audit`.`source_module`
`ledger_postings_audit`.`source_id`
`ledger_postings_audit`.`tds_deduction_id`
`ledger_postings_audit`.`created_at`
`ledger_postings_audit`.`updated_at`
`ledger_postings_audit`.`delete_status`
`ledger_postings_audit`.`deleted_by`
`ledger_postings_audit`.`deleted_at`
`ledger_shipping_details`.*
`ledger_shipping_details`.`id`
`ledger_shipping_details`.`ledger_id`
`ledger_shipping_details`.`ledger_cash_id`
`ledger_shipping_details`.`parent_led_id`
`ledger_shipping_details`.`voucher_type_id`
`ledger_shipping_details`.`is_primary`
`ledger_shipping_details`.`ship_to`
`ledger_shipping_details`.`mailing_name`
`ledger_shipping_details`.`shipping_address`
`ledger_shipping_details`.`shipping_contact`
`ledger_shipping_details`.`shipping_city`
`ledger_shipping_details`.`shipping_state_id`
`ledger_shipping_details`.`shipping_country_id`
`ledger_shipping_details`.`shipping_pincode`
`ledger_shipping_details`.`shipping_gstin`
`ledger_shipping_details`.`place_of_supply`
`ledger_shipping_details`.`delivery_source`
`ledger_shipping_details`.`godown_id`
`ledger_shipping_details`.`plant_id`
`ledger_shipping_details`.`branch_id`
`ledger_shipping_details`.`created_at`
`ledger_shipping_details`.`updated_at`
`ledger_transactions`.*
`ledger_transactions`.`id`
`ledger_transactions`.`ref_table`
`ledger_transactions`.`ref_id`
`ledger_transactions`.`voucher_type_id`
`ledger_transactions`.`voucher_type`
`ledger_transactions`.`voucher_id`
`ledger_transactions`.`voucher_number`
`ledger_transactions`.`voucher_date`
`ledger_transactions`.`ledger_id`
`ledger_transactions`.`ledger_name`
`ledger_transactions`.`parent_group_id`
`ledger_transactions`.`parent_group_title`
`ledger_transactions`.`ledger_group_id`
`ledger_transactions`.`ledger_group_title`
`ledger_transactions`.`dr_amount`
`ledger_transactions`.`cr_amount`
`ledger_transactions`.`narration`
`ledger_transactions`.`delete_status`
`ledger_transactions`.`correspondent_ledger`
`ledger_transactions`.`correspondent_ledger_id`
`ledger_transactions`.`branch_id`
`ledger_transactions`.`created_at`
`ledger_transactions`.`updated_at`
`ledger_transactions`.`by`
`ledger_transactions`.`to`
`ledger_transactions`.`is_other_details`
`ledger_transactions`.`is_cash_bank_detailsreport`
`ledger_transactions`.`correspondent_date`
`ledger_transactions`.`alias_ledger_id`
`ledger_types_deleted`.*
`ledger_types_deleted`.`id`
`ledger_types_deleted`.`title`
`ledger_types_deleted`.`group_type`
`ledger_types_deleted`.`is_default`
`ledger_types_deleted`.`description`
`ledger_types_deleted`.`active_status`
`ledger_types_deleted`.`created_at`
`ledger_types_deleted`.`updated_at`
`mastergst_tokens`.*
`mastergst_tokens`.`id`
`mastergst_tokens`.`gstin`
`mastergst_tokens`.`access_token`
`mastergst_tokens`.`token_expiry`
`mastergst_tokens`.`created_at`
`message_queue`.*
`message_queue`.`id`
`message_queue`.`phone_number`
`message_queue`.`message_text`
`message_queue`.`status`
`message_queue`.`created_at`
`monthly_financial_summary`.*
`monthly_financial_summary`.`summary_month`
`monthly_financial_summary`.`branch_id`
`monthly_financial_summary`.`total_sales`
`monthly_financial_summary`.`total_purchases`
`monthly_financial_summary`.`total_receipts`
`monthly_financial_summary`.`total_payments`
`monthly_financial_summary`.`credit_note`
`monthly_financial_summary`.`debit_note`
`monthly_financial_summary`.`finance_year_id`
`parts`.*
`parts`.`id`
`parts`.`part_id`
`parts`.`part_title`
`parts`.`part_cost`
`parts`.`image_path`
`parts`.`image_url`
`parts`.`is_active`
`parts`.`delete_status`
`parts`.`created_at`
`parts`.`updated_at`
`party_comments`.*
`party_comments`.`id`
`party_comments`.`party_id`
`party_comments`.`comment_type`
`party_comments`.`comment_text`
`party_comments`.`commenter`
`party_comments`.`comment_date`
`party_comments`.`branch_id`
`party_comments`.`delete_status`
`party_comments`.`created_at`
`party_comments`.`updated_at`
`payment_details_draft`.*
`payment_details_draft`.`id`
`payment_details_draft`.`transaction_id`
`payment_details_draft`.`voucher_type_id`
`payment_details_draft`.`voucher_date`
`payment_details_draft`.`ledger_id`
`payment_details_draft`.`ledger_account_id`
`payment_details_draft`.`ledger_account_name`
`payment_details_draft`.`instrument_type`
`payment_details_draft`.`instrument_number`
`payment_details_draft`.`amount`
`payment_details_draft`.`branch_id`
`payment_details_draft`.`narration`
`payment_details_draft`.`received_status`
`payment_details_draft`.`move_to_receipt`
`payment_details_draft`.`delete_status`
`payment_details_draft`.`created_at`
`payment_details_draft`.`updated_at`
`payment_purchase_mapping`.*
`payment_purchase_mapping`.`id`
`payment_purchase_mapping`.`payment_transaction_id`
`payment_purchase_mapping`.`purchase_entry_id`
`payment_purchase_mapping`.`allocated_amount`
`payment_purchase_mapping`.`branch_id`
`payment_purchase_mapping`.`delete_status`
`payment_purchase_mapping`.`created_at`
`payment_purchase_mapping`.`updated_at`
`payment_voucher_allocations`.*
`payment_voucher_allocations`.`id`
`payment_voucher_allocations`.`payment_voucher_id`
`payment_voucher_allocations`.`voucher_type_id`
`payment_voucher_allocations`.`invoice_id`
`payment_voucher_allocations`.`allocated_amount`
`payment_voucher_allocations`.`remarks`
`payment_voucher_allocations`.`delete_status`
`payment_voucher_allocations`.`created_at`
`payment_voucher_allocations`.`updated_at`
`payment_vouchers`.*
`payment_vouchers`.`id`
`payment_vouchers`.`entry_type`
`payment_vouchers`.`voucher_type_id`
`payment_vouchers`.`cash_or_bank`
`payment_vouchers`.`voucher_no`
`payment_vouchers`.`voucher_date`
`payment_vouchers`.`ledger_id`
`payment_vouchers`.`ledger_account_id`
`payment_vouchers`.`expense_head`
`payment_vouchers`.`gst_aplicability`
`payment_vouchers`.`ref_bill_no`
`payment_vouchers`.`instrument_type`
`payment_vouchers`.`instrument_number`
`payment_vouchers`.`amount`
`payment_vouchers`.`branch_id`
`payment_vouchers`.`user_id`
`payment_vouchers`.`narration`
`payment_vouchers`.`delete_status`
`payment_vouchers`.`created_at`
`payment_vouchers`.`updated_at`
`payment_vouchers`.`created_by`
`payment_vouchers`.`modified_by`
`payment_vouchers`.`finance_year_id`
`payment_vouchers`.`bank_name`
`payment_vouchers`.`account_no`
`payment_vouchers`.`ifsc_code`
`payment_vouchers`.`reference_id`
`plant_details`.*
`plant_details`.`id`
`plant_details`.`plant_name`
`plant_details`.`plant_code`
`plant_details`.`address`
`plant_details`.`city`
`plant_details`.`pincode`
`plant_details`.`state_id`
`plant_details`.`country_id`
`plant_details`.`contact_number`
`plant_details`.`email`
`plant_details`.`is_active`
`plant_details`.`branch_id`
`plant_details`.`delete_status`
`plant_details`.`created_at`
`plant_details`.`updated_at`
`posting_audit_log`.*
`posting_audit_log`.`id`
`posting_audit_log`.`voucher_type_id`
`posting_audit_log`.`ref_id`
`posting_audit_log`.`ref_table`
`posting_audit_log`.`posting_action`
`posting_audit_log`.`message`
`posting_audit_log`.`posting_time`
`posting_audit_log`.`posted_by`
`posting_control`.*
`posting_control`.`id`
`posting_control`.`voucher_type_id`
`posting_control`.`voucher_id`
`posting_control`.`posting_status`
`posting_control`.`posted_by`
`posting_control`.`posting_at`
`posting_period_control`.*
`posting_period_control`.`period_start`
`posting_period_control`.`period_end`
`posting_period_control`.`is_locked`
`posting_period_control`.`locked_by`
`posting_period_control`.`locked_at`
`postings_audit_log`.*
`postings_audit_log`.`id`
`postings_audit_log`.`voucher_id`
`postings_audit_log`.`voucher_type`
`postings_audit_log`.`table_name`
`postings_audit_log`.`row_data`
`postings_audit_log`.`deleted_by`
`postings_audit_log`.`deleted_at`
`postings_audit_log`.`recovered`
`pricing_recompute_queue`.*
`pricing_recompute_queue`.`id`
`pricing_recompute_queue`.`branch_id`
`pricing_recompute_queue`.`item_id`
`pricing_recompute_queue`.`reason`
`pricing_recompute_queue`.`created_at`
`purchase_entries`.*
`purchase_entries`.`id`
`purchase_entries`.`purchase_invoice_no`
`purchase_entries`.`purchase_invoice_date`
`purchase_entries`.`voucher_number`
`purchase_entries`.`voucher_type_id`
`purchase_entries`.`entry_mode`
`purchase_entries`.`grn_ref_id`
`purchase_entries`.`grn_status`
`purchase_entries`.`sales_channel`
`purchase_entries`.`sales_person_id`
`purchase_entries`.`source_quotation_id`
`purchase_entries`.`voucher_date`
`purchase_entries`.`voucher_time`
`purchase_entries`.`due_date`
`purchase_entries`.`ledger_id`
`purchase_entries`.`party_cat_id`
`purchase_entries`.`invoice_amount`
`purchase_entries`.`price`
`purchase_entries`.`pri_discount`
`purchase_entries`.`proportionate_discount`
`purchase_entries`.`total_discount`
`purchase_entries`.`discount_coupon_code`
`purchase_entries`.`applied_discount_category`
`purchase_entries`.`applied_discount_category_id`
`purchase_entries`.`taxable_amount`
`purchase_entries`.`item_tax_amout`
`purchase_entries`.`add_charges_fixed_tax_amount`
`purchase_entries`.`add_charges_proportionate_tax_amount`
`purchase_entries`.`total_tax_amount`
`purchase_entries`.`tds_amount`
`purchase_entries`.`freight_charges`
`purchase_entries`.`add_charges`
`purchase_entries`.`sgst_amount`
`purchase_entries`.`cgst_amount`
`purchase_entries`.`igst_amount`
`purchase_entries`.`cess_amount`
`purchase_entries`.`payment_status`
`purchase_entries`.`narration`
`purchase_entries`.`additional_discount_remarks`
`purchase_entries`.`discount_details`
`purchase_entries`.`receiver_name`
`purchase_entries`.`receiver_contact_number`
`purchase_entries`.`branch_id`
`purchase_entries`.`user_id`
`purchase_entries`.`finance_year_id`
`purchase_entries`.`delete_status`
`purchase_entries`.`created_at`
`purchase_entries`.`updated_at`
`purchase_entries`.`round_off`
`purchase_entries`.`total_amount`
`purchase_entries`.`irn`
`purchase_entries`.`ack_no`
`purchase_entries`.`ack_date`
`purchase_entries`.`qr_code`
`purchase_entries`.`einvoice_status`
`purchase_entries`.`einvoice_error`
`purchase_entries`.`ewaybill_no`
`purchase_entries`.`ewaybill_date`
`purchase_entries`.`ewaybill_status`
`purchase_entries`.`ewaybill_error`
`purchase_entries`.`posting_status`
`purchase_entries_old`.*
`purchase_entries_old`.`id`
`purchase_entries_old`.`voucher_number`
`purchase_entries_old`.`voucher_type`
`purchase_entries_old`.`voucher_date`
`purchase_entries_old`.`due_date`
`purchase_entries_old`.`ledger_id`
`purchase_entries_old`.`voucher_type_id`
`purchase_entries_old`.`finance_year_id`
`purchase_entries_old`.`invoice_no`
`purchase_entries_old`.`invoice_date`
`purchase_entries_old`.`price`
`purchase_entries_old`.`total_discount`
`purchase_entries_old`.`applied_discount_category_id`
`purchase_entries_old`.`taxable_amount`
`purchase_entries_old`.`total_amount`
`purchase_entries_old`.`tax_amount`
`purchase_entries_old`.`freight_charges`
`purchase_entries_old`.`add_charges`
`purchase_entries_old`.`sgst_amount`
`purchase_entries_old`.`cgst_amount`
`purchase_entries_old`.`igst_amount`
`purchase_entries_old`.`cess_amount`
`purchase_entries_old`.`payment_status`
`purchase_entries_old`.`narration`
`purchase_entries_old`.`branch_id`
`purchase_entries_old`.`delete_status`
`purchase_entries_old`.`created_at`
`purchase_entries_old`.`updated_at`
`purchase_entry_items`.*
`purchase_entry_items`.`id`
`purchase_entry_items`.`purchase_entry_id`
`purchase_entry_items`.`godown_id`
`purchase_entry_items`.`item_id`
`purchase_entry_items`.`hsn_sac_id`
`purchase_entry_items`.`uom_id`
`purchase_entry_items`.`quantity`
`purchase_entry_items`.`rate`
`purchase_entry_items`.`price`
`purchase_entry_items`.`discount_type`
`purchase_entry_items`.`discount_source_id`
`purchase_entry_items`.`discount_value`
`purchase_entry_items`.`discount_amount`
`purchase_entry_items`.`proportionate_discount`
`purchase_entry_items`.`taxable_amount`
`purchase_entry_items`.`proportionate_add_charges_amount`
`purchase_entry_items`.`tax_percentage`
`purchase_entry_items`.`cgst_percentage`
`purchase_entry_items`.`sgst_percentage`
`purchase_entry_items`.`igst_percentage`
`purchase_entry_items`.`cess_percentage`
`purchase_entry_items`.`tax_amount`
`purchase_entry_items`.`cgst_amount`
`purchase_entry_items`.`sgst_amount`
`purchase_entry_items`.`igst_amount`
`purchase_entry_items`.`cess_amount`
`purchase_entry_items`.`branch_id`
`purchase_entry_items`.`delete_status`
`purchase_entry_items`.`created_at`
`purchase_entry_items`.`updated_at`
`purchase_entry_items_old`.*
`purchase_entry_items_old`.`id`
`purchase_entry_items_old`.`purchase_entry_id`
`purchase_entry_items_old`.`item_id`
`purchase_entry_items_old`.`godown_id`
`purchase_entry_items_old`.`voucher_type_id`
`purchase_entry_items_old`.`hsn_sac_id`
`purchase_entry_items_old`.`uom_id`
`purchase_entry_items_old`.`quantity`
`purchase_entry_items_old`.`rate`
`purchase_entry_items_old`.`price`
`purchase_entry_items_old`.`discount_type_id`
`purchase_entry_items_old`.`discount_value`
`purchase_entry_items_old`.`discount_amount`
`purchase_entry_items_old`.`taxable_amount`
`purchase_entry_items_old`.`gst_percentage`
`purchase_entry_items_old`.`cgst_percentage`
`purchase_entry_items_old`.`sgst_percentage`
`purchase_entry_items_old`.`igst_percentage`
`purchase_entry_items_old`.`cess_percentage`
`purchase_entry_items_old`.`gst_amount`
`purchase_entry_items_old`.`cgst_amount`
`purchase_entry_items_old`.`sgst_amount`
`purchase_entry_items_old`.`igst_amount`
`purchase_entry_items_old`.`cess_amount`
`purchase_entry_items_old`.`branch_id`
`purchase_entry_items_old`.`delete_status`
`purchase_entry_items_old`.`created_at`
`purchase_entry_items_old`.`updated_at`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`purchase_order_id`
`purchase_order_items`.`item_id`
`purchase_order_items`.`quantity`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`total_price`
`purchase_order_items`.`delete_status`
`purchase_order_items`.`modified_by`
`purchase_order_items`.`created_at`
`purchase_order_items`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`order_date`
`purchase_orders`.`status`
`purchase_orders`.`total_amount`
`purchase_orders`.`branch_id`
`purchase_orders`.`delete_status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_return_items`.*
`purchase_return_items`.`id`
`purchase_return_items`.`purchase_return_id`
`purchase_return_items`.`purchase_entry_id`
`purchase_return_items`.`purchase_return_reason_id`
`purchase_return_items`.`item_id`
`purchase_return_items`.`godown_id`
`purchase_return_items`.`hsn_sac_id`
`purchase_return_items`.`uom_id`
`purchase_return_items`.`quantity`
`purchase_return_items`.`discounted_rate`
`purchase_return_items`.`deduction_type`
`purchase_return_items`.`deduction_value`
`purchase_return_items`.`deduction_amount`
`purchase_return_items`.`discounted_price`
`purchase_return_items`.`proportionate_discount`
`purchase_return_items`.`taxable_amount`
`purchase_return_items`.`proportionate_add_charges_amount`
`purchase_return_items`.`gst_percentage`
`purchase_return_items`.`cgst_percentage`
`purchase_return_items`.`sgst_percentage`
`purchase_return_items`.`igst_percentage`
`purchase_return_items`.`cess_percentage`
`purchase_return_items`.`gst_amount`
`purchase_return_items`.`cgst_amount`
`purchase_return_items`.`sgst_amount`
`purchase_return_items`.`igst_amount`
`purchase_return_items`.`cess_amount`
`purchase_return_items`.`deduction_reason`
`purchase_return_items`.`branch_id`
`purchase_return_items`.`delete_status`
`purchase_return_items`.`created_at`
`purchase_return_items`.`updated_at`
`purchase_return_items_old`.*
`purchase_return_items_old`.`id`
`purchase_return_items_old`.`purchase_return_id`
`purchase_return_items_old`.`purchase_entry_id`
`purchase_return_items_old`.`purchase_entry_item_id`
`purchase_return_items_old`.`item_id`
`purchase_return_items_old`.`branch_id`
`purchase_return_items_old`.`return_quantity`
`purchase_return_items_old`.`unit_price_discounted`
`purchase_return_items_old`.`return_amount`
`purchase_return_items_old`.`return_reason_id`
`purchase_return_items_old`.`remarks`
`purchase_return_items_old`.`delete_status`
`purchase_return_items_old`.`created_at`
`purchase_return_items_old`.`updated_at`
`purchase_return_old`.*
`purchase_return_old`.`id`
`purchase_return_old`.`voucher_number`
`purchase_return_old`.`voucher_date`
`purchase_return_old`.`ledger_id`
`purchase_return_old`.`total_return_qty`
`purchase_return_old`.`total_return_amount`
`purchase_return_old`.`branch_id`
`purchase_return_old`.`return_status`
`purchase_return_old`.`approved_by`
`purchase_return_old`.`created_by`
`purchase_return_old`.`delete_status`
`purchase_return_old`.`created_at`
`purchase_return_old`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`voucher_number`
`purchase_returns`.`voucher_type_id`
`purchase_returns`.`voucher_date`
`purchase_returns`.`ledger_id`
`purchase_returns`.`discounted_rate`
`purchase_returns`.`pri_discount`
`purchase_returns`.`proportionate_discount`
`purchase_returns`.`total_discount`
`purchase_returns`.`total_deduction_amount`
`purchase_returns`.`taxable_amount`
`purchase_returns`.`item_tax_amout`
`purchase_returns`.`add_charges_fixed_tax_amount`
`purchase_returns`.`add_charges_proportionate_tax_amount`
`purchase_returns`.`total_tax_amount`
`purchase_returns`.`tds_amount`
`purchase_returns`.`freight_charges`
`purchase_returns`.`add_charges`
`purchase_returns`.`sgst_amount`
`purchase_returns`.`cgst_amount`
`purchase_returns`.`igst_amount`
`purchase_returns`.`cess_amount`
`purchase_returns`.`payment_status`
`purchase_returns`.`posting_status`
`purchase_returns`.`narration`
`purchase_returns`.`receiver_name`
`purchase_returns`.`receiver_contact_number`
`purchase_returns`.`branch_id`
`purchase_returns`.`finance_year_id`
`purchase_returns`.`delete_status`
`purchase_returns`.`created_at`
`purchase_returns`.`user_id`
`purchase_returns`.`updated_at`
`purchase_returns`.`total_amount`
`purchase_returns`.`round_off`
`quotation_entries`.*
`quotation_entries`.`id`
`quotation_entries`.`voucher_number`
`quotation_entries`.`voucher_type_id`
`quotation_entries`.`sales_channel`
`quotation_entries`.`sales_person_id`
`quotation_entries`.`source_quotation_id`
`quotation_entries`.`voucher_date`
`quotation_entries`.`voucher_time`
`quotation_entries`.`due_date`
`quotation_entries`.`ledger_id`
`quotation_entries`.`party_cat_id`
`quotation_entries`.`invoice_amount`
`quotation_entries`.`price`
`quotation_entries`.`pri_discount`
`quotation_entries`.`proportionate_discount`
`quotation_entries`.`total_discount`
`quotation_entries`.`discount_coupon_code`
`quotation_entries`.`applied_discount_category`
`quotation_entries`.`applied_discount_category_id`
`quotation_entries`.`taxable_amount`
`quotation_entries`.`item_tax_amout`
`quotation_entries`.`add_charges_fixed_tax_amount`
`quotation_entries`.`add_charges_proportionate_tax_amount`
`quotation_entries`.`total_tax_amount`
`quotation_entries`.`tds_amount`
`quotation_entries`.`freight_charges`
`quotation_entries`.`add_charges`
`quotation_entries`.`sgst_amount`
`quotation_entries`.`cgst_amount`
`quotation_entries`.`igst_amount`
`quotation_entries`.`cess_amount`
`quotation_entries`.`payment_status`
`quotation_entries`.`narration`
`quotation_entries`.`additional_discount_remarks`
`quotation_entries`.`discount_details`
`quotation_entries`.`receiver_name`
`quotation_entries`.`receiver_contact_number`
`quotation_entries`.`branch_id`
`quotation_entries`.`user_id`
`quotation_entries`.`finance_year_id`
`quotation_entries`.`delete_status`
`quotation_entries`.`created_at`
`quotation_entries`.`updated_at`
`quotation_entries`.`round_off`
`quotation_entries`.`total_amount`
`quotation_entries`.`irn`
`quotation_entries`.`ack_no`
`quotation_entries`.`ack_date`
`quotation_entries`.`qr_code`
`quotation_entries`.`einvoice_status`
`quotation_entries`.`einvoice_error`
`quotation_entries`.`ewaybill_no`
`quotation_entries`.`ewaybill_date`
`quotation_entries`.`ewaybill_status`
`quotation_entries`.`ewaybill_error`
`quotation_entries`.`posting_status`
`quotation_entry_items`.*
`quotation_entry_items`.`id`
`quotation_entry_items`.`sales_entry_id`
`quotation_entry_items`.`godown_id`
`quotation_entry_items`.`item_id`
`quotation_entry_items`.`hsn_sac_id`
`quotation_entry_items`.`uom_id`
`quotation_entry_items`.`quantity`
`quotation_entry_items`.`rate`
`quotation_entry_items`.`price`
`quotation_entry_items`.`discount_type`
`quotation_entry_items`.`discount_source_id`
`quotation_entry_items`.`discount_value`
`quotation_entry_items`.`discount_amount`
`quotation_entry_items`.`proportionate_discount`
`quotation_entry_items`.`taxable_amount`
`quotation_entry_items`.`proportionate_add_charges_amount`
`quotation_entry_items`.`tax_percentage`
`quotation_entry_items`.`cgst_percentage`
`quotation_entry_items`.`sgst_percentage`
`quotation_entry_items`.`igst_percentage`
`quotation_entry_items`.`cess_percentage`
`quotation_entry_items`.`tax_amount`
`quotation_entry_items`.`cgst_amount`
`quotation_entry_items`.`sgst_amount`
`quotation_entry_items`.`igst_amount`
`quotation_entry_items`.`cess_amount`
`quotation_entry_items`.`branch_id`
`quotation_entry_items`.`delete_status`
`quotation_entry_items`.`created_at`
`quotation_entry_items`.`updated_at`
`receipt_sales_mapping`.*
`receipt_sales_mapping`.`id`
`receipt_sales_mapping`.`receipt_transaction_id`
`receipt_sales_mapping`.`sales_entry_id`
`receipt_sales_mapping`.`allocated_amount`
`receipt_sales_mapping`.`created_at`
`receipt_sales_mapping`.`updated_at`
`receipt_voucher_allocations`.*
`receipt_voucher_allocations`.`id`
`receipt_voucher_allocations`.`receipt_voucher_id`
`receipt_voucher_allocations`.`voucher_type_id`
`receipt_voucher_allocations`.`invoice_id`
`receipt_voucher_allocations`.`allocated_amount`
`receipt_voucher_allocations`.`remarks`
`receipt_voucher_allocations`.`delete_status`
`receipt_voucher_allocations`.`created_at`
`receipt_voucher_allocations`.`updated_at`
`receipt_vouchers`.*
`receipt_vouchers`.`id`
`receipt_vouchers`.`voucher_type_id`
`receipt_vouchers`.`cash_or_bank`
`receipt_vouchers`.`voucher_no`
`receipt_vouchers`.`voucher_date`
`receipt_vouchers`.`ledger_id`
`receipt_vouchers`.`ledger_account_id`
`receipt_vouchers`.`instrument_type`
`receipt_vouchers`.`instrument_number`
`receipt_vouchers`.`bank_name`
`receipt_vouchers`.`amount`
`receipt_vouchers`.`tds_amount`
`receipt_vouchers`.`branch_id`
`receipt_vouchers`.`user_id`
`receipt_vouchers`.`finance_year_id`
`receipt_vouchers`.`reference_id`
`receipt_vouchers`.`narration`
`receipt_vouchers`.`delete_status`
`receipt_vouchers`.`created_by`
`receipt_vouchers`.`modified_by`
`receipt_vouchers`.`created_at`
`receipt_vouchers`.`updated_at`
`report_data_entries`.*
`report_data_entries`.`id`
`report_data_entries`.`entry_type`
`report_data_entries`.`entry_id`
`report_data_entries`.`ledger_id`
`report_data_entries`.`transaction_date`
`report_data_entries`.`voucher_number`
`report_data_entries`.`narration`
`report_data_entries`.`debit_amount`
`report_data_entries`.`credit_amount`
`report_data_entries`.`branch_id`
`report_data_entries`.`item_id`
`report_data_entries`.`hsn_code`
`report_data_entries`.`gst_percentage`
`report_data_entries`.`stock_qty`
`report_data_entries`.`stock_value`
`report_data_entries`.`created_at`
`report_data_entries`.`updated_at`
`sales_entries`.*
`sales_entries`.`id`
`sales_entries`.`voucher_number`
`sales_entries`.`voucher_type_id`
`sales_entries`.`entry_mode`
`sales_entries`.`proforma_ref_id`
`sales_entries`.`proforma_status`
`sales_entries`.`sales_channel`
`sales_entries`.`sales_person_id`
`sales_entries`.`source_quotation_id`
`sales_entries`.`source_sales_id`
`sales_entries`.`quotation_moved_status`
`sales_entries`.`voucher_date`
`sales_entries`.`voucher_time`
`sales_entries`.`due_date`
`sales_entries`.`ledger_id`
`sales_entries`.`party_cat_id`
`sales_entries`.`invoice_amount`
`sales_entries`.`price`
`sales_entries`.`subsidy_scheme_id`
`sales_entries`.`pri_discount`
`sales_entries`.`proportionate_discount`
`sales_entries`.`total_discount`
`sales_entries`.`discount_coupon_code`
`sales_entries`.`applied_discount_category`
`sales_entries`.`applied_discount_category_id`
`sales_entries`.`taxable_amount`
`sales_entries`.`item_tax_amout`
`sales_entries`.`add_charges_fixed_tax_amount`
`sales_entries`.`add_charges_proportionate_tax_amount`
`sales_entries`.`total_tax_amount`
`sales_entries`.`tds_amount`
`sales_entries`.`freight_charges`
`sales_entries`.`add_charges`
`sales_entries`.`sgst_amount`
`sales_entries`.`cgst_amount`
`sales_entries`.`igst_amount`
`sales_entries`.`cess_amount`
`sales_entries`.`payment_status`
`sales_entries`.`narration`
`sales_entries`.`additional_discount_remarks`
`sales_entries`.`discount_details`
`sales_entries`.`receiver_name`
`sales_entries`.`receiver_contact_number`
`sales_entries`.`branch_id`
`sales_entries`.`user_id`
`sales_entries`.`finance_year_id`
`sales_entries`.`delete_status`
`sales_entries`.`created_at`
`sales_entries`.`updated_at`
`sales_entries`.`round_off`
`sales_entries`.`total_amount`
`sales_entries`.`irn`
`sales_entries`.`ack_no`
`sales_entries`.`ack_date`
`sales_entries`.`qr_code`
`sales_entries`.`einvoice_status`
`sales_entries`.`einvoice_error`
`sales_entries`.`ewaybill_no`
`sales_entries`.`ewaybill_date`
`sales_entries`.`ewaybill_status`
`sales_entries`.`ewaybill_error`
`sales_entries`.`posting_status`
`sales_entry_items`.*
`sales_entry_items`.`id`
`sales_entry_items`.`sales_entry_id`
`sales_entry_items`.`godown_id`
`sales_entry_items`.`subsidy_scheme_id`
`sales_entry_items`.`subsidy_billed`
`sales_entry_items`.`other_discount_applicable`
`sales_entry_items`.`item_id`
`sales_entry_items`.`hsn_sac_id`
`sales_entry_items`.`uom_id`
`sales_entry_items`.`quantity`
`sales_entry_items`.`rate`
`sales_entry_items`.`price`
`sales_entry_items`.`discount_type`
`sales_entry_items`.`discount_source_id`
`sales_entry_items`.`discount_value`
`sales_entry_items`.`discount_amount`
`sales_entry_items`.`proportionate_discount`
`sales_entry_items`.`taxable_amount`
`sales_entry_items`.`proportionate_add_charges_amount`
`sales_entry_items`.`tax_percentage`
`sales_entry_items`.`cgst_percentage`
`sales_entry_items`.`sgst_percentage`
`sales_entry_items`.`igst_percentage`
`sales_entry_items`.`cess_percentage`
`sales_entry_items`.`tax_amount`
`sales_entry_items`.`cgst_amount`
`sales_entry_items`.`sgst_amount`
`sales_entry_items`.`igst_amount`
`sales_entry_items`.`cess_amount`
`sales_entry_items`.`branch_id`
`sales_entry_items`.`delete_status`
`sales_entry_items`.`created_at`
`sales_entry_items`.`updated_at`
`sales_invoice_discounts`.*
`sales_invoice_discounts`.`id`
`sales_invoice_discounts`.`invoice_id`
`sales_invoice_discounts`.`branch_id`
`sales_invoice_discounts`.`exchange_id`
`sales_invoice_discounts`.`subsidy_id`
`sales_invoice_discounts`.`discount_coupon_code`
`sales_invoice_discounts`.`other_discount_amount`
`sales_invoice_discounts`.`total_discount`
`sales_invoice_discounts`.`remarks`
`sales_invoice_discounts`.`selected_other_discount_items`
`sales_invoice_discounts`.`selected_subsidy_items`
`sales_invoice_discounts`.`delete_status`
`sales_invoice_discounts`.`created_at`
`sales_invoice_discounts`.`updated_at`
`sales_invoice_exchange`.*
`sales_invoice_exchange`.`id`
`sales_invoice_exchange`.`discount_id`
`sales_invoice_exchange`.`old_item_id`
`sales_invoice_exchange`.`machine_name`
`sales_invoice_exchange`.`list_price`
`sales_invoice_exchange`.`exchange_value`
`sales_invoice_exchange`.`remarks`
`sales_invoice_other_discounts`.*
`sales_invoice_other_discounts`.`id`
`sales_invoice_other_discounts`.`discount_id`
`sales_invoice_other_discounts`.`discount_type`
`sales_invoice_other_discounts`.`amount`
`sales_invoice_other_discounts`.`reason`
`sales_invoice_subsidy`.*
`sales_invoice_subsidy`.`id`
`sales_invoice_subsidy`.`invoice_id`
`sales_invoice_subsidy`.`scheme_id`
`sales_invoice_subsidy`.`scheme_document_id`
`sales_invoice_subsidy`.`document_name`
`sales_invoice_subsidy`.`document_verified`
`sales_invoice_subsidy`.`remarks`
`sales_invoice_subsidy`.`branch_id`
`sales_invoice_subsidy`.`created_by`
`sales_invoice_subsidy`.`modified_by`
`sales_invoice_subsidy`.`created_at`
`sales_invoice_subsidy`.`updated_at`
`sales_return_items`.*
`sales_return_items`.`id`
`sales_return_items`.`sales_return_id`
`sales_return_items`.`sales_entry_id`
`sales_return_items`.`sales_return_reason_id`
`sales_return_items`.`item_id`
`sales_return_items`.`godown_id`
`sales_return_items`.`hsn_sac_id`
`sales_return_items`.`uom_id`
`sales_return_items`.`quantity`
`sales_return_items`.`discounted_rate`
`sales_return_items`.`deduction_type`
`sales_return_items`.`deduction_value`
`sales_return_items`.`deduction_amount`
`sales_return_items`.`discounted_price`
`sales_return_items`.`proportionate_discount`
`sales_return_items`.`taxable_amount`
`sales_return_items`.`proportionate_add_charges_amount`
`sales_return_items`.`gst_percentage`
`sales_return_items`.`cgst_percentage`
`sales_return_items`.`sgst_percentage`
`sales_return_items`.`igst_percentage`
`sales_return_items`.`cess_percentage`
`sales_return_items`.`gst_amount`
`sales_return_items`.`cgst_amount`
`sales_return_items`.`sgst_amount`
`sales_return_items`.`igst_amount`
`sales_return_items`.`cess_amount`
`sales_return_items`.`deduction_reason`
`sales_return_items`.`branch_id`
`sales_return_items`.`delete_status`
`sales_return_items`.`created_at`
`sales_return_items`.`updated_at`
`sales_return_reasons`.*
`sales_return_reasons`.`id`
`sales_return_reasons`.`reason_title`
`sales_return_reasons`.`description`
`sales_return_reasons`.`is_active`
`sales_return_reasons`.`created_at`
`sales_return_reasons`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`voucher_number`
`sales_returns`.`voucher_type_id`
`sales_returns`.`voucher_date`
`sales_returns`.`ledger_id`
`sales_returns`.`discounted_rate`
`sales_returns`.`pri_discount`
`sales_returns`.`proportionate_discount`
`sales_returns`.`total_discount`
`sales_returns`.`total_deduction_amount`
`sales_returns`.`taxable_amount`
`sales_returns`.`item_tax_amout`
`sales_returns`.`add_charges_fixed_tax_amount`
`sales_returns`.`add_charges_proportionate_tax_amount`
`sales_returns`.`total_tax_amount`
`sales_returns`.`tds_amount`
`sales_returns`.`freight_charges`
`sales_returns`.`add_charges`
`sales_returns`.`sgst_amount`
`sales_returns`.`cgst_amount`
`sales_returns`.`igst_amount`
`sales_returns`.`cess_amount`
`sales_returns`.`payment_status`
`sales_returns`.`return_status`
`sales_returns`.`narration`
`sales_returns`.`receiver_name`
`sales_returns`.`receiver_contact_number`
`sales_returns`.`branch_id`
`sales_returns`.`finance_year_id`
`sales_returns`.`delete_status`
`sales_returns`.`created_at`
`sales_returns`.`user_id`
`sales_returns`.`updated_at`
`sales_returns`.`round_off`
`sales_returns`.`total_amount`
`sales_returns`.`posting_status`
`sales_settings`.*
`sales_settings`.`id`
`sales_settings`.`branch_id`
`sales_settings`.`price_base`
`sales_settings`.`discount_base`
`sales_settings`.`additional_discount_enabled`
`sales_settings`.`enable_scheme_discount`
`sales_settings`.`allow_negative_stock`
`sales_settings`.`default_payment_mode`
`sales_settings`.`default_terms_days`
`sales_settings`.`round_off_method`
`sales_settings`.`invoice_prefix`
`sales_settings`.`invoice_start_number`
`sales_settings`.`delete_status`
`sales_settings`.`created_at`
`sales_settings`.`updated_at`
`sales_targets`.*
`sales_targets`.`id`
`sales_targets`.`finance_year_id`
`sales_targets`.`branch_id`
`sales_targets`.`target_amount`
`sample_table`.*
`sample_table`.`id`
`sample_table`.`delete_status`
`sample_table`.`created_at`
`sample_table`.`updated_at`
`setting_allowed_ips`.*
`setting_allowed_ips`.`id`
`setting_allowed_ips`.`ip_address`
`setting_allowed_ips`.`description`
`setting_allowed_ips`.`is_active`
`setting_allowed_ips`.`created_at`
`setting_branch_details`.*
`setting_branch_details`.`id`
`setting_branch_details`.`branch_name`
`setting_branch_details`.`branch_code`
`setting_branch_details`.`address`
`setting_branch_details`.`city`
`setting_branch_details`.`pincode`
`setting_branch_details`.`state_id`
`setting_branch_details`.`country_id`
`setting_branch_details`.`contact_number`
`setting_branch_details`.`email`
`setting_branch_details`.`gstin`
`setting_branch_details`.`website`
`setting_branch_details`.`logo`
`setting_branch_details`.`dark_logo`
`setting_branch_details`.`light_logo`
`setting_branch_details`.`is_main_branch`
`setting_branch_details`.`delete_status`
`setting_branch_details`.`created_at`
`setting_branch_details`.`updated_at`
`setting_countries`.*
`setting_countries`.`id`
`setting_countries`.`country_name`
`setting_countries`.`short_name`
`setting_countries`.`is_default`
`setting_countries`.`delete_status`
`setting_countries`.`created_at`
`setting_countries`.`updated_at`
`setting_main_menu`.*
`setting_main_menu`.`id`
`setting_main_menu`.`main_menu`
`setting_main_menu`.`display_name`
`setting_main_menu`.`url`
`setting_main_menu`.`icon`
`setting_main_menu`.`sequence`
`setting_main_menu`.`is_voucher_entry`
`setting_main_menu`.`is_report`
`setting_main_menu`.`delete_status`
`setting_main_menu`.`created_at`
`setting_main_menu`.`updated_at`
`setting_states`.*
`setting_states`.`id`
`setting_states`.`state_name`
`setting_states`.`short_name`
`setting_states`.`delete_status`
`setting_states`.`is_default`
`setting_states`.`created_at`
`setting_states`.`updated_at`
`setting_sub_menu`.*
`setting_sub_menu`.`id`
`setting_sub_menu`.`sub_menu`
`setting_sub_menu`.`display_name`
`setting_sub_menu`.`mmenu_id`
`setting_sub_menu`.`is_master`
`setting_sub_menu`.`is_list`
`setting_sub_menu`.`is_voucher_entry`
`setting_sub_menu`.`is_report`
`setting_sub_menu`.`url`
`setting_sub_menu`.`sequence`
`setting_sub_menu`.`search_sequence`
`setting_sub_menu`.`delete_status`
`setting_sub_menu`.`created_at`
`setting_sub_menu`.`updated_at`
`subsidy_scheme_documents`.*
`subsidy_scheme_documents`.`id`
`subsidy_scheme_documents`.`scheme_id`
`subsidy_scheme_documents`.`doc_code`
`subsidy_scheme_documents`.`doc_name`
`subsidy_scheme_documents`.`is_mandatory`
`subsidy_scheme_documents`.`sequence_no`
`subsidy_scheme_documents`.`notes`
`subsidy_scheme_documents`.`branch_id`
`subsidy_scheme_documents`.`delete_status`
`subsidy_scheme_documents`.`created_at`
`subsidy_scheme_documents`.`updated_at`
`subsidy_schemes`.*
`subsidy_schemes`.`id`
`subsidy_schemes`.`scheme_name`
`subsidy_schemes`.`scheme_code`
`subsidy_schemes`.`description`
`subsidy_schemes`.`subsidy_type`
`subsidy_schemes`.`subsidy_rate`
`subsidy_schemes`.`subsidy_flat_amount`
`subsidy_schemes`.`cap_amount`
`subsidy_schemes`.`active_status`
`tally_posted_rows`.*
`tally_posted_rows`.`raw_row_id`
`tally_posted_rows`.`import_batch_id`
`tally_posted_rows`.`voucher_table`
`tally_posted_rows`.`voucher_id`
`tally_posted_rows`.`voucher_no`
`tally_posted_rows`.`created_at`
`tally_posting_issues`.*
`tally_posting_issues`.`id`
`tally_posting_issues`.`import_batch_id`
`tally_posting_issues`.`raw_row_id`
`tally_posting_issues`.`issue_code`
`tally_posting_issues`.`details`
`tally_posting_issues`.`created_at`
`tally_source_batches`.*
`tally_source_batches`.`import_batch_id`
`tally_source_batches`.`sheet_name`
`tally_source_batches`.`header_row_no`
`tally_source_batches`.`h1`
`tally_source_batches`.`h2`
`tally_source_batches`.`h3`
`tally_source_batches`.`h4`
`tally_source_batches`.`h5`
`tally_source_batches`.`h6`
`tally_source_batches`.`h7`
`tally_source_batches`.`h8`
`tally_source_batches`.`h9`
`tally_source_batches`.`h10`
`tally_source_batches`.`created_at`
`tally_source_raw10`.*
`tally_source_raw10`.`id`
`tally_source_raw10`.`import_batch_id`
`tally_source_raw10`.`sheet_name`
`tally_source_raw10`.`row_in_sheet`
`tally_source_raw10`.`c1`
`tally_source_raw10`.`c2`
`tally_source_raw10`.`c3`
`tally_source_raw10`.`c4`
`tally_source_raw10`.`c5`
`tally_source_raw10`.`c6`
`tally_source_raw10`.`c7`
`tally_source_raw10`.`c8`
`tally_source_raw10`.`c9`
`tally_source_raw10`.`c10`
`tally_source_raw10`.`created_at`
`tally_source_typed`.*
`tally_source_typed`.`id`
`tally_source_typed`.`import_batch_id`
`tally_source_typed`.`raw_row_id`
`tally_source_typed`.`txn_date`
`tally_source_typed`.`particulars`
`tally_source_typed`.`instrument_text`
`tally_source_typed`.`vch_type`
`tally_source_typed`.`voucher_type_id`
`tally_source_typed`.`vch_no`
`tally_source_typed`.`debit_amount`
`tally_source_typed`.`credit_amount`
`tally_source_typed`.`ledger_id`
`tally_source_typed`.`correspondent_ledger_id`
`tally_source_typed`.`is_ledger`
`tally_source_typed`.`is_main_ledger`
`tally_source_typed`.`is_main`
`tally_source_typed`.`is_correspondent`
`tally_source_typed`.`is_others`
`tally_source_typed`.`txn_date_forwardfill`
`tally_source_typed`.`vch_type_forwardfill`
`tally_source_typed`.`vch_no_forwardfill`
`tally_source_typed`.`main_ledger_name_ff`
`tally_source_typed`.`main_ledger_id_ff`
`tally_source_typed`.`is_pair_head`
`tally_source_typed`.`is_item`
`tally_source_typed`.`item_id`
`tally_source_typed`.`item_qty`
`tally_source_typed`.`rate_per_item`
`tally_source_typed`.`item_uom`
`tally_source_typed`.`item_name_key`
`tally_source_typed`.`ledger_type`
`tally_source_typed`.`created_at`
`tally_transactions`.*
`tally_transactions`.`id`
`tally_transactions`.`ledger_id`
`tally_transactions`.`voucher_type`
`tally_transactions`.`voucher_number`
`tally_transactions`.`voucher_date`
`tally_transactions`.`delete_status`
`tally_transactions`.`type`
`tally_transactions`.`amount`
`tally_transactions`.`narration`
`tally_transactions`.`branch_id`
`tally_transactions`.`created_at`
`tally_transactions`.`updated_at`
`tds_cumulative`.*
`tds_cumulative`.`id`
`tds_cumulative`.`vendor_id`
`tds_cumulative`.`ledger_id`
`tds_cumulative`.`section_code`
`tds_cumulative`.`finance_year_id`
`tds_cumulative`.`cumulative_amount`
`tds_cumulative`.`created_at`
`tds_cumulative`.`updated_at`
`tds_deductions`.*
`tds_deductions`.`id`
`tds_deductions`.`voucher_id`
`tds_deductions`.`voucher_type`
`tds_deductions`.`ledger_id`
`tds_deductions`.`vendor_id`
`tds_deductions`.`section_code`
`tds_deductions`.`amount`
`tds_deductions`.`narration`
`tds_deductions`.`finance_year_id`
`tds_deductions`.`branch_id`
`tds_deductions`.`voucher_date`
`tds_deductions`.`created_at`
`tds_deductions`.`delete_status`
`tds_deductions`.`deleted_by`
`tds_deductions`.`deleted_at`
`tds_master`.*
`tds_master`.`id`
`tds_master`.`section_code`
`tds_master`.`description`
`tds_master`.`applicable_on`
`tds_master`.`rate_percent`
`tds_master`.`threshold_per_txn`
`tds_master`.`threshold_annual`
`tds_master`.`resident_only`
`tds_master`.`is_active`
`tds_master`.`created_at`
`tds_master`.`updated_at`
`transaction_additional_charges`.*
`transaction_additional_charges`.`id`
`transaction_additional_charges`.`voucher_type_id`
`transaction_additional_charges`.`transaction_id`
`transaction_additional_charges`.`ledger_id`
`transaction_additional_charges`.`amount`
`transaction_additional_charges`.`tax_percentage`
`transaction_additional_charges`.`is_proportionate`
`transaction_additional_charges`.`branch_id`
`transaction_additional_charges`.`delete_status`
`transaction_additional_charges`.`created_at`
`transaction_additional_charges`.`updated_at`
`transaction_expenditure_categories`.*
`transaction_expenditure_categories`.`id`
`transaction_expenditure_categories`.`title`
`transaction_expenditure_categories`.`description`
`transaction_expenditure_categories`.`account_group_id`
`transaction_expenditure_categories`.`active_status`
`transaction_expenditure_categories`.`delete_status`
`transaction_expenditure_categories`.`created_at`
`transaction_expenditure_categories`.`updated_at`
`transaction_expenditure_vouchers`.*
`transaction_expenditure_vouchers`.`id`
`transaction_expenditure_vouchers`.`voucher_no`
`transaction_expenditure_vouchers`.`voucher_date`
`transaction_expenditure_vouchers`.`ledger_id`
`transaction_expenditure_vouchers`.`ledger_account_id`
`transaction_expenditure_vouchers`.`amount`
`transaction_expenditure_vouchers`.`gst_amount`
`transaction_expenditure_vouchers`.`is_gst_applicable`
`transaction_expenditure_vouchers`.`expenditure_category_id`
`transaction_expenditure_vouchers`.`branch_id`
`transaction_expenditure_vouchers`.`instrument_type`
`transaction_expenditure_vouchers`.`instrument_number`
`transaction_expenditure_vouchers`.`narration`
`transaction_expenditure_vouchers`.`delete_status`
`transaction_expenditure_vouchers`.`created_at`
`transaction_expenditure_vouchers`.`updated_at`
`transaction_expenditure_vouchers`.`expense_date`
`transaction_expenditure_vouchers`.`expense_type`
`transaction_payment_vouchers_expense`.*
`transaction_payment_vouchers_expense`.`id`
`transaction_payment_vouchers_expense`.`voucher_type_id`
`transaction_payment_vouchers_expense`.`voucher_no`
`transaction_payment_vouchers_expense`.`voucher_date`
`transaction_payment_vouchers_expense`.`ledger_id`
`transaction_payment_vouchers_expense`.`ledger_account_id`
`transaction_payment_vouchers_expense`.`instrument_type`
`transaction_payment_vouchers_expense`.`instrument_number`
`transaction_payment_vouchers_expense`.`amount`
`transaction_payment_vouchers_expense`.`expense_head`
`transaction_payment_vouchers_expense`.`gst`
`transaction_payment_vouchers_expense`.`branch_id`
`transaction_payment_vouchers_expense`.`user_id`
`transaction_payment_vouchers_expense`.`narration`
`transaction_payment_vouchers_expense`.`delete_status`
`transaction_payment_vouchers_expense`.`created_at`
`transaction_payment_vouchers_expense`.`updated_at`
`transaction_payment_vouchers_expense`.`payment_date`
`transaction_payment_vouchers_expense`.`created_by`
`transaction_payment_vouchers_expense`.`modified_by`
`transaction_payment_vouchers_expense`.`finance_year_id`
`transaction_payment_vouchers_expense`.`bank_name`
`transaction_payment_vouchers_expense`.`reference_id`
`transaction_payment_vouchers_expense`.`reference`
`transaction_receipt_vouchers_old`.*
`transaction_receipt_vouchers_old`.`id`
`transaction_receipt_vouchers_old`.`voucher_no`
`transaction_receipt_vouchers_old`.`voucher_date`
`transaction_receipt_vouchers_old`.`ledger_id`
`transaction_receipt_vouchers_old`.`ledger_account_id`
`transaction_receipt_vouchers_old`.`instrument_type`
`transaction_receipt_vouchers_old`.`instrument_number`
`transaction_receipt_vouchers_old`.`amount`
`transaction_receipt_vouchers_old`.`tds_amount`
`transaction_receipt_vouchers_old`.`branch_id`
`transaction_receipt_vouchers_old`.`narration`
`transaction_receipt_vouchers_old`.`delete_status`
`transaction_receipt_vouchers_old`.`created_at`
`transaction_receipt_vouchers_old`.`updated_at`
`transaction_receipt_vouchers_old`.`received_date`
`transaction_receipt_vouchers_old`.`user_id`
`transaction_receipt_vouchers_old`.`finance_year_id`
`transaction_receipt_vouchers_old`.`bank_name`
`transaction_receipt_vouchers_old`.`reference_id`
`universal_discount_rules`.*
`universal_discount_rules`.`id`
`universal_discount_rules`.`rule_name`
`universal_discount_rules`.`rule_scope`
`universal_discount_rules`.`operator`
`universal_discount_rules`.`value`
`universal_discount_rules`.`target_id`
`universal_discount_rules`.`customer_segment_id`
`universal_discount_rules`.`coupon_code`
`universal_discount_rules`.`min_qty`
`universal_discount_rules`.`min_amount`
`universal_discount_rules`.`valid_from`
`universal_discount_rules`.`valid_to`
`universal_discount_rules`.`priority`
`universal_discount_rules`.`combine_method`
`universal_discount_rules`.`is_active`
`universal_discount_rules`.`branch_id`
`universal_discount_rules`.`delete_status`
`universal_discount_rules`.`created_at`
`universal_discount_rules`.`updated_at`
`user_branches`.*
`user_branches`.`id`
`user_branches`.`user_id`
`user_branches`.`branch_id`
`user_branches`.`is_active`
`user_branches`.`is_default`
`user_branches`.`delete_status`
`user_branches`.`created_at`
`user_branches`.`updated_at`
`user_details`.*
`user_details`.`id`
`user_details`.`user_email`
`user_details`.`username`
`user_details`.`password_hash`
`user_details`.`role_id`
`user_details`.`emp_id`
`user_details`.`default_branch_id`
`user_details`.`financial_year_id`
`user_details`.`delete_status`
`user_details`.`created_at`
`user_details`.`updated_at`
`user_favorites`.*
`user_favorites`.`id`
`user_favorites`.`user_id`
`user_favorites`.`submenu_id`
`user_favorites`.`is_voucher_entry`
`user_favorites`.`sort_order`
`user_favorites`.`created_at`
`user_favorites`.`updated_at`
`user_financial_years`.*
`user_financial_years`.`id`
`user_financial_years`.`user_id`
`user_financial_years`.`financial_year_id`
`user_financial_years`.`is_active`
`user_financial_years`.`delete_status`
`user_financial_years`.`created_at`
`user_financial_years`.`updated_at`
`user_permissions`.*
`user_permissions`.`id`
`user_permissions`.`role_id`
`user_permissions`.`menu_id`
`user_permissions`.`submenu_id`
`user_permissions`.`can_add`
`user_permissions`.`can_edit`
`user_permissions`.`can_delete`
`user_permissions`.`can_view`
`user_permissions`.`branch_id`
`user_permissions`.`delete_status`
`user_permissions`.`created_at`
`user_permissions`.`updated_at`
`user_roles`.*
`user_roles`.`id`
`user_roles`.`role_name`
`user_roles`.`dashboard_link`
`user_roles`.`dashboard_link_lock_screen`
`user_roles`.`is_super_admin`
`user_roles`.`branch_id`
`user_roles`.`delete_status`
`user_roles`.`created_at`
`user_roles`.`updated_at`
`users`.*
`users`.`id`
`users`.`user_code`
`users`.`name`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`mobile`
`users`.`role_id`
`users`.`branch_id`
`users`.`status`
`users`.`last_login`
`users`.`created_by`
`users`.`created_at`
`users`.`updated_at`
`users`.`delete_status`
`voucher_additional_charges`.*
`voucher_additional_charges`.`id`
`voucher_additional_charges`.`voucher_type_id`
`voucher_additional_charges`.`ledger_id`
`voucher_additional_charges`.`tax_proportionate_flag`
`voucher_additional_charges`.`tax_percentage_override`
`voucher_additional_charges`.`hsn_sac_code`
`voucher_additional_charges`.`remarks`
`voucher_additional_charges`.`branch_id`
`voucher_additional_charges`.`created_at`
`voucher_additional_charges`.`updated_at`
`voucher_numbering_config`.*
`voucher_numbering_config`.`id`
`voucher_numbering_config`.`voucher_type_id`
`voucher_numbering_config`.`financial_year_id`
`voucher_numbering_config`.`branch_id`
`voucher_numbering_config`.`starting_number`
`voucher_numbering_config`.`number_width`
`voucher_numbering_config`.`prefix_zero`
`voucher_numbering_config`.`restart_periodicity`
`voucher_numbering_config`.`restart_applicable_from`
`voucher_numbering_config`.`restart_number`
`voucher_numbering_config`.`prefix_applicable_from`
`voucher_numbering_config`.`prefix_text`
`voucher_numbering_config`.`suffix_applicable_from`
`voucher_numbering_config`.`suffix_text`
`voucher_numbering_config`.`created_at`
`voucher_numbering_config`.`updated_at`
`voucher_series_master`.*
`voucher_series_master`.`id`
`voucher_series_master`.`voucher_code`
`voucher_series_master`.`branch_id`
`voucher_series_master`.`financial_year_id`
`voucher_series_master`.`prefix`
`voucher_series_master`.`suffix`
`voucher_series_master`.`current_number`
`voucher_series_master_old`.*
`voucher_series_master_old`.`id`
`voucher_series_master_old`.`voucher_type`
`voucher_series_master_old`.`branch_id`
`voucher_series_master_old`.`financial_year_id`
`voucher_series_master_old`.`prefix`
`voucher_series_master_old`.`suffix`
`voucher_series_master_old`.`current_number`
`voucher_taxes`.*
`voucher_taxes`.`id`
`voucher_taxes`.`voucher_type`
`voucher_taxes`.`voucher_id`
`voucher_taxes`.`tax_code`
`voucher_taxes`.`tax_name`
`voucher_taxes`.`tax_rate`
`voucher_taxes`.`tax_amount`
`voucher_taxes`.`ledger_id`
`voucher_taxes`.`branch_id`
`voucher_taxes`.`created_at`
`voucher_taxes`.`updated_at`
`voucher_taxes`.`taxable_value`
`voucher_taxes`.`charge_type`
`voucher_taxes`.`additional_charge_id`
`voucher_type_ledger_mappings`.*
`voucher_type_ledger_mappings`.`id`
`voucher_type_ledger_mappings`.`voucher_type_id`
`voucher_type_ledger_mappings`.`voucher_type`
`voucher_type_ledger_mappings`.`ledger_id`
`voucher_type_ledger_mappings`.`ledger_key_id`
`voucher_type_ledger_mappings`.`is_tds_applicable`
`voucher_type_ledger_mappings`.`narration_template`
`voucher_type_ledger_mappings`.`remarks`
`voucher_type_ledger_mappings`.`voucher_flow_type`
`voucher_type_ledger_mappings`.`sort_order`
`voucher_type_ledger_mappings`.`entry_side`
`voucher_type_ledger_mappings`.`is_default`
`voucher_type_ledger_mappings`.`delete_status`
`voucher_type_ledger_mappings`.`created_at`
`voucher_type_ledger_mappings`.`updated_at`
`voucher_types`.*
`voucher_types`.`id`
`voucher_types`.`voucher_code`
`voucher_types`.`title`
`voucher_types`.`abbreviation`
`voucher_types`.`primary_voucher`
`voucher_types`.`numbering_method`
`voucher_types`.`retain_original_number`
`voucher_types`.`is_optional`
`voucher_types`.`is_primary_voucher`
`voucher_types`.`is_posting`
`voucher_types`.`is_default`
`voucher_types`.`update_item_transaction`
`voucher_types`.`allow_narration`
`voucher_types`.`track_additional_costs`
`voucher_types`.`auto_print_on_save`
`voucher_types`.`auto_whatsapp_on_save`
`voucher_types`.`entry_side`
`voucher_types`.`is_active`
`voucher_types`.`sort_order`
`voucher_types`.`primary_voucher_type_id`
`voucher_types`.`created_at`
`voucher_types`.`updated_at`
`voucher_types_old`.*
`voucher_types_old`.`id`
`voucher_types_old`.`code`
`voucher_types_old`.`title`
`voucher_types_old`.`abbreviation`
`voucher_types_old`.`voucher_mode`
`voucher_types_old`.`numbering_method`
`voucher_types_old`.`retain_original_number`
`voucher_types_old`.`is_optional`
`voucher_types_old`.`allow_narration`
`voucher_types_old`.`track_additional_costs`
`voucher_types_old`.`auto_print_on_save`
`voucher_types_old`.`auto_whatsapp_on_save`
`voucher_types_old`.`nature`
`voucher_types_old`.`is_custom`
`voucher_types_old`.`is_active`
`voucher_types_old`.`sort_order`
`voucher_types_old`.`primary_voucher_type_id`
`voucher_types_old`.`created_at`
`voucher_types_old`.`updated_at`
`whatsapp_settings`.*
`whatsapp_settings`.`id`
`whatsapp_settings`.`provider`
`whatsapp_settings`.`api_url`
`whatsapp_settings`.`api_key`
`whatsapp_settings`.`auth_token`
`whatsapp_settings`.`sender_number`
`whatsapp_settings`.`is_active`
`whatsapp_settings`.`branch_id`
`whatsapp_settings`.`created_at`
`whatsapp_settings`.`updated_at`
`yearly_financial_summary`.*
`yearly_financial_summary`.`summary_year`
`yearly_financial_summary`.`branch_id`
`yearly_financial_summary`.`total_sales`
`yearly_financial_summary`.`total_purchases`
`yearly_financial_summary`.`total_receipts`
`yearly_financial_summary`.`total_payments`
`yearly_financial_summary`.`credit_note`
`yearly_financial_summary`.`debit_note`
`yearly_financial_summary`.`finance_year_id`
`alert_logs`.*
`alert_logs`.`id`
`alert_logs`.`alert_type`
`alert_logs`.`alert_message`
`alert_logs`.`triggered_on`
`alert_logs`.`item_id`
`alert_logs`.`ledger_id`
`alert_logs`.`invoice_id`
`alert_logs`.`lead_id`
`alert_logs`.`branch_id`
`alert_logs`.`user_id`
`alert_logs`.`alert_level`
`alert_logs`.`is_read`
`alert_logs`.`resolved`
`alert_logs`.`created_at`
`alert_logs`.`updated_at`
`api_student`.*
`api_student`.`id`
`api_student`.`name`
`api_student`.`age`
`api_student`.`grade`
`assign_item_to_subsidy_scheme`.*
`assign_item_to_subsidy_scheme`.`id`
`assign_item_to_subsidy_scheme`.`subsidy_scheme_id`
`assign_item_to_subsidy_scheme`.`item_id`
`assign_item_to_subsidy_scheme`.`delete_status`
`assign_item_to_subsidy_scheme`.`created_at`
`assign_item_to_subsidy_scheme`.`created_by`
`assign_item_to_subsidy_scheme`.`modified_at`
`assign_item_to_subsidy_scheme`.`modified_by`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`entity_type`
`audit_logs`.`entity_id`
`audit_logs`.`version`
`audit_logs`.`event_type`
`audit_logs`.`reason`
`audit_logs`.`branch_id`
`audit_logs`.`finance_year_id`
`audit_logs`.`changed_by`
`audit_logs`.`changed_at`
`audit_logs`.`changed_ip`
`audit_logs`.`snapshot`
`audit_logs`.`diff`
`audit_logs`.`aux`
`audit_logs`.`hash`
`audit_logs`.`prev_hash`
`audit_logs`.`invoice_no`
`audit_logs`.`voucher_no`
`audit_logs`.`voucher_date`
`auth_group`.*
`auth_group`.`id`
`auth_group`.`name`
`auth_group_permissions`.*
`auth_group_permissions`.`id`
`auth_group_permissions`.`group_id`
`auth_group_permissions`.`permission_id`
`auth_permission`.*
`auth_permission`.`id`
`auth_permission`.`name`
`auth_permission`.`content_type_id`
`auth_permission`.`codename`
`auth_user`.*
`auth_user`.`id`
`auth_user`.`password`
`auth_user`.`last_login`
`auth_user`.`is_superuser`
`auth_user`.`username`
`auth_user`.`first_name`
`auth_user`.`last_name`
`auth_user`.`email`
`auth_user`.`is_staff`
`auth_user`.`is_active`
`auth_user`.`date_joined`
`auth_user_groups`.*
`auth_user_groups`.`id`
`auth_user_groups`.`user_id`
`auth_user_groups`.`group_id`
`auth_user_user_permissions`.*
`auth_user_user_permissions`.`id`
`auth_user_user_permissions`.`user_id`
`auth_user_user_permissions`.`permission_id`
`bank_master`.*
`bank_master`.`id`
`bank_master`.`bank_code`
`bank_master`.`bank_name`
`bank_master`.`short_name`
`bank_master`.`swift_code`
`bank_master`.`logo_url`
`bank_master`.`is_active`
`bank_master`.`created_at`
`bank_master`.`updated_at`
`call_followup_master`.*
`call_followup_master`.`id`
`call_followup_master`.`customer_id`
`call_followup_master`.`customer_name`
`call_followup_master`.`mobile_number`
`call_followup_master`.`call_type`
`call_followup_master`.`due_amount`
`call_followup_master`.`assigned_agent`
`call_followup_master`.`scheduled_date`
`call_followup_master`.`call_status`
`call_followup_master`.`remarks`
`call_followup_master`.`next_followup_date`
`call_followup_master`.`miss_count`
`call_followup_master`.`created_at`
`call_followup_master`.`updated_at`
`cnc_job_parts`.*
`cnc_job_parts`.`id`
`cnc_job_parts`.`job_id`
`cnc_job_parts`.`part_name`
`cnc_job_parts`.`qty`
`cnc_job_parts`.`operation_remark`
`cnc_job_parts`.`delete_status`
`cnc_job_parts`.`created_at`
`cnc_job_parts`.`updated_at`
`cnc_jobs`.*
`cnc_jobs`.`id`
`cnc_jobs`.`branch_id`
`cnc_jobs`.`job_date`
`cnc_jobs`.`shift`
`cnc_jobs`.`operator_code`
`cnc_jobs`.`operator_name`
`cnc_jobs`.`machine_name`
`cnc_jobs`.`job_no`
`cnc_jobs`.`notes`
`cnc_jobs`.`delete_status`
`cnc_jobs`.`created_by`
`cnc_jobs`.`created_at`
`cnc_jobs`.`updated_at`
`contra_vouchers`.*
`contra_vouchers`.`id`
`contra_vouchers`.`voucher_no`
`contra_vouchers`.`voucher_type_id`
`contra_vouchers`.`voucher_date`
`contra_vouchers`.`contra_type`
`contra_vouchers`.`from_account_id`
`contra_vouchers`.`to_account_id`
`contra_vouchers`.`instrument_type`
`contra_vouchers`.`bank_name`
`contra_vouchers`.`instrument_number`
`contra_vouchers`.`amount`
`contra_vouchers`.`narration`
`contra_vouchers`.`branch_id`
`contra_vouchers`.`finance_year_id`
`contra_vouchers`.`created_by`
`contra_vouchers`.`updated_by`
`contra_vouchers`.`delete_status`
`contra_vouchers`.`created_at`
`contra_vouchers`.`updated_at`
`coupon_limits`.*
`coupon_limits`.`coupon_code`
`coupon_limits`.`max_global_uses`
`coupon_limits`.`max_uses_per_customer`
`coupon_limits`.`is_scratch`
`coupon_limits`.`valid_from`
`coupon_limits`.`valid_to`
`coupon_redemptions`.*
`coupon_redemptions`.`id`
`coupon_redemptions`.`coupon_code`
`coupon_redemptions`.`customer_id`
`coupon_redemptions`.`rule_id`
`coupon_redemptions`.`order_ref`
`coupon_redemptions`.`qty`
`coupon_redemptions`.`amount`
`coupon_redemptions`.`branch_id`
`coupon_redemptions`.`redeemed_at`
`crm_brochure_queue`.*
`crm_brochure_queue`.`id`
`crm_brochure_queue`.`enquiry_id`
`crm_brochure_queue`.`medium`
`crm_brochure_queue`.`template_id`
`crm_brochure_queue`.`status`
`crm_brochure_queue`.`scheduled_at`
`crm_brochure_queue`.`sent_at`
`crm_brochure_queue`.`created_by`
`crm_brochure_queue`.`created_at`
`crm_brochure_queue`.`updated_at`
`crm_brochure_queue`.`delete_status`
`crm_enquiry_links`.*
`crm_enquiry_links`.`id`
`crm_enquiry_links`.`enquiry_id`
`crm_enquiry_links`.`link_type`
`crm_enquiry_links`.`target_id`
`crm_enquiry_links`.`created_by`
`crm_enquiry_links`.`created_at`
`crm_leads`.*
`crm_leads`.`id`
`crm_leads`.`lead_type`
`crm_leads`.`customer_company`
`crm_leads`.`contact_person`
`crm_leads`.`phone`
`crm_leads`.`whatsapp`
`crm_leads`.`address`
`crm_leads`.`city`
`crm_leads`.`pincode`
`crm_leads`.`source`
`crm_leads`.`stage`
`crm_leads`.`next_followup`
`crm_leads`.`customer_role`
`crm_leads`.`next_steps`
`crm_leads`.`description`
`crm_leads`.`next_action`
`crm_leads`.`routed_at`
`crm_leads`.`auto_routed`
`crm_leads`.`auto_route_json`
`crm_leads`.`auto_route_conf`
`crm_leads`.`handled_by`
`crm_leads`.`branch_id`
`crm_leads`.`status`
`crm_leads`.`created_by`
`crm_leads`.`created_at`
`crm_leads`.`updated_at`
`crm_leads`.`delete_status`
`crm_quotations`.*
`crm_quotations`.`id`
`crm_quotations`.`enquiry_id`
`crm_quotations`.`customer_company`
`crm_quotations`.`contact_phone`
`crm_quotations`.`city`
`crm_quotations`.`stage`
`crm_quotations`.`remarks`
`crm_quotations`.`created_by`
`crm_quotations`.`created_at`
`crm_quotations`.`updated_at`
`crm_quotations`.`delete_status`
`crm_service_details`.*
`crm_service_details`.`id`
`crm_service_details`.`lead_id`
`crm_service_details`.`service_type`
`crm_service_details`.`machine_model`
`crm_service_details`.`serial_no`
`crm_service_details`.`preferred_visit_date`
`crm_service_details`.`technician_id`
`crm_service_details`.`priority`
`crm_service_details`.`warranty`
`crm_service_details`.`notes`
`crm_service_details`.`created_at`
`crm_service_details`.`updated_at`
`crm_tasks`.*
`crm_tasks`.`id`
`crm_tasks`.`entity_type`
`crm_tasks`.`entity_id`
`crm_tasks`.`task_type`
`crm_tasks`.`title`
`crm_tasks`.`due_at`
`crm_tasks`.`assigned_to`
`crm_tasks`.`status`
`crm_tasks`.`notes`
`crm_tasks`.`branch_id`
`crm_tasks`.`created_by`
`crm_tasks`.`created_at`
`crm_tasks`.`updated_at`
`crm_tasks`.`delete_status`
`crm_visits`.*
`crm_visits`.`id`
`crm_visits`.`enquiry_id`
`crm_visits`.`scheduled_at`
`crm_visits`.`address`
`crm_visits`.`city`
`crm_visits`.`pincode`
`crm_visits`.`assigned_to`
`crm_visits`.`status`
`crm_visits`.`notes`
`crm_visits`.`created_by`
`crm_visits`.`created_at`
`crm_visits`.`updated_at`
`crm_visits`.`delete_status`
`customer_segment`.*
`customer_segment`.`id`
`customer_segment`.`title`
`customer_segment`.`description`
`customer_segment`.`active_status`
`customer_segment`.`branch_id`
`customer_segment`.`created_by`
`customer_segment`.`modified_by`
`customer_segment`.`created_at`
`customer_segment`.`updated_at`
`customer_segment`.`delete_status`
`daily_financial_summary`.*
`daily_financial_summary`.`summary_date`
`daily_financial_summary`.`branch_id`
`daily_financial_summary`.`total_sales`
`daily_financial_summary`.`total_purchases`
`daily_financial_summary`.`total_receipts`
`daily_financial_summary`.`total_payments`
`daily_ledger_balance`.*
`daily_ledger_balance`.`summary_date`
`daily_ledger_balance`.`ledger_id`
`daily_ledger_balance`.`branch_id`
`daily_ledger_balance`.`dr_amount`
`daily_ledger_balance`.`cr_amount`
`dashboard_monthly_summary`.*
`dashboard_monthly_summary`.`summary_year`
`dashboard_monthly_summary`.`summary_month`
`dashboard_monthly_summary`.`total_sales`
`dashboard_monthly_summary`.`total_purchases`
`dashboard_monthly_summary`.`total_sales_return`
`dashboard_monthly_summary`.`total_purchase_return`
`dashboard_monthly_summary`.`total_revenue`
`dashboard_monthly_summary`.`total_expenditure`
`dashboard_monthly_summary`.`total_profit`
`dashboard_monthly_summary`.`created_at`
`dashboard_summary_snapshot`.*
`dashboard_summary_snapshot`.`id`
`dashboard_summary_snapshot`.`total_sales`
`dashboard_summary_snapshot`.`total_purchases`
`dashboard_summary_snapshot`.`total_sales_return`
`dashboard_summary_snapshot`.`total_purchase_return`
`dashboard_summary_snapshot`.`total_revenue`
`dashboard_summary_snapshot`.`total_expenditure`
`dashboard_summary_snapshot`.`total_profit`
`dashboard_summary_snapshot`.`top_customer`
`dashboard_summary_snapshot`.`top_item`
`dashboard_summary_snapshot`.`total_customers`
`dashboard_summary_snapshot`.`total_suppliers`
`dashboard_summary_snapshot`.`total_visits`
`dashboard_summary_snapshot`.`total_leads`
`dashboard_summary_snapshot`.`total_employees`
`dashboard_summary_snapshot`.`summary_date`
`dashboard_summary_snapshot`.`last_updated`
`dashboard_yearly_summary`.*
`dashboard_yearly_summary`.`summary_year`
`dashboard_yearly_summary`.`total_sales`
`dashboard_yearly_summary`.`total_purchases`
`dashboard_yearly_summary`.`total_sales_return`
`dashboard_yearly_summary`.`total_purchase_return`
`dashboard_yearly_summary`.`total_revenue`
`dashboard_yearly_summary`.`total_expenditure`
`dashboard_yearly_summary`.`total_profit`
`dashboard_yearly_summary`.`created_at`
`date_range_filters`.*
`date_range_filters`.`id`
`date_range_filters`.`filter_name`
`date_range_filters`.`query_value`
`date_range_filters`.`is_active`
`discount_rule_targets`.*
`discount_rule_targets`.`target_id`
`discount_rule_targets`.`discount_rule_id`
`discount_rule_targets`.`target_type`
`discount_rule_targets`.`target_ref_id`
`discount_rule_targets`.`customer_segment_id`
`discount_rule_targets`.`discount_value`
`discount_rule_targets`.`operator_override`
`discount_rule_targets`.`min_qty_override`
`discount_rule_targets`.`min_amount_override`
`discount_rule_targets`.`combine_override`
`discount_rule_targets`.`priority_override`
`discount_rule_targets`.`branch_id`
`discount_rule_targets`.`delete_status`
`discount_rule_targets`.`created_at`
`discount_rule_targets`.`updated_at`
`dispatch_details`.*
`dispatch_details`.`id`
`dispatch_details`.`sales_entry_id`
`dispatch_details`.`voucher_type_id`
`dispatch_details`.`delivery_note_no`
`dispatch_details`.`dispatch_doc_no`
`dispatch_details`.`dispatch_date`
`dispatch_details`.`dispatched_through`
`dispatch_details`.`destination`
`dispatch_details`.`carrier_ledger_id`
`dispatch_details`.`bill_of_lading`
`dispatch_details`.`lr_rr_date`
`dispatch_details`.`motor_vehicle_no`
`dispatch_details`.`buyer_order_no`
`dispatch_details`.`buyer_date`
`dispatch_details`.`branch_id`
`dispatch_details`.`created_by`
`dispatch_details`.`created_at`
`dispatch_details`.`updated_at`
`dispatch_details`.`delete_status`
`django_admin_log`.*
`django_admin_log`.`id`
`django_admin_log`.`action_time`
`django_admin_log`.`object_id`
`django_admin_log`.`object_repr`
`django_admin_log`.`action_flag`
`django_admin_log`.`change_message`
`django_admin_log`.`content_type_id`
`django_admin_log`.`user_id`
`django_content_type`.*
`django_content_type`.`id`
`django_content_type`.`app_label`
`django_content_type`.`model`
`django_migrations`.*
`django_migrations`.`id`
`django_migrations`.`app`
`django_migrations`.`name`
`django_migrations`.`applied`
`django_session`.*
`django_session`.`session_key`
`django_session`.`session_data`
`django_session`.`expire_date`
`dynamic_sales_price_competitor_prices`.*
`dynamic_sales_price_competitor_prices`.`competitor_price_id`
`dynamic_sales_price_competitor_prices`.`item_id`
`dynamic_sales_price_competitor_prices`.`competitor_name`
`dynamic_sales_price_competitor_prices`.`price`
`dynamic_sales_price_competitor_prices`.`branch_id`
`dynamic_sales_price_competitor_prices`.`last_checked`
`dynamic_sales_price_competitor_prices`.`is_active`
`dynamic_sales_price_competitor_prices`.`delete_status`
`dynamic_sales_price_competitor_prices`.`created_by`
`dynamic_sales_price_competitor_prices`.`updated_by`
`dynamic_sales_price_competitor_prices`.`created_at`
`dynamic_sales_price_competitor_prices`.`updated_at`
`dynamic_sales_price_competitor_rules`.*
`dynamic_sales_price_competitor_rules`.`id`
`dynamic_sales_price_competitor_rules`.`item_id`
`dynamic_sales_price_competitor_rules`.`strategy`
`dynamic_sales_price_competitor_rules`.`undercut_value`
`dynamic_sales_price_competitor_rules`.`branch_id`
`dynamic_sales_price_competitor_rules`.`is_active`
`dynamic_sales_price_competitor_rules`.`delete_status`
`dynamic_sales_price_competitor_rules`.`created_by`
`dynamic_sales_price_competitor_rules`.`updated_by`
`dynamic_sales_price_competitor_rules`.`created_at`
`dynamic_sales_price_competitor_rules`.`updated_at`
`dynamic_sales_price_configs`.*
`dynamic_sales_price_configs`.`id`
`dynamic_sales_price_configs`.`branch_id`
`dynamic_sales_price_configs`.`item_id`
`dynamic_sales_price_configs`.`brand_id`
`dynamic_sales_price_configs`.`category_id`
`dynamic_sales_price_configs`.`pricing_strategy`
`dynamic_sales_price_configs`.`costing_method`
`dynamic_sales_price_configs`.`min_margin_percent`
`dynamic_sales_price_configs`.`allow_competitor_price`
`dynamic_sales_price_configs`.`competitor_alignment_mode`
`dynamic_sales_price_configs`.`competitor_floor_margin_pct`
`dynamic_sales_price_configs`.`stock_low_threshold`
`dynamic_sales_price_configs`.`stock_high_threshold`
`dynamic_sales_price_configs`.`stock_low_markup_pct`
`dynamic_sales_price_configs`.`stock_high_markdown_pct`
`dynamic_sales_price_configs`.`average_sales_lookback_days`
`dynamic_sales_price_configs`.`rounding_rule`
`dynamic_sales_price_configs`.`effective_from`
`dynamic_sales_price_configs`.`effective_to`
`dynamic_sales_price_configs`.`delete_status`
`dynamic_sales_price_configs`.`created_at`
`dynamic_sales_price_configs`.`updated_at`
`dynamic_sales_price_discounts`.*
`dynamic_sales_price_discounts`.`id`
`dynamic_sales_price_discounts`.`rule_name`
`dynamic_sales_price_discounts`.`rule_type`
`dynamic_sales_price_discounts`.`reference_id`
`dynamic_sales_price_discounts`.`discount_type`
`dynamic_sales_price_discounts`.`discount_value`
`dynamic_sales_price_discounts`.`valid_from`
`dynamic_sales_price_discounts`.`valid_to`
`dynamic_sales_price_discounts`.`branch_id`
`dynamic_sales_price_discounts`.`is_active`
`dynamic_sales_price_discounts`.`delete_status`
`dynamic_sales_price_discounts`.`created_by`
`dynamic_sales_price_discounts`.`updated_by`
`dynamic_sales_price_discounts`.`created_at`
`dynamic_sales_price_discounts`.`updated_at`
`dynamic_sales_price_margin_rules`.*
`dynamic_sales_price_margin_rules`.`id`
`dynamic_sales_price_margin_rules`.`rule_type`
`dynamic_sales_price_margin_rules`.`reference_id`
`dynamic_sales_price_margin_rules`.`margin_percent`
`dynamic_sales_price_margin_rules`.`branch_id`
`dynamic_sales_price_margin_rules`.`is_active`
`dynamic_sales_price_margin_rules`.`delete_status`
`dynamic_sales_price_margin_rules`.`created_by`
`dynamic_sales_price_margin_rules`.`updated_by`
`dynamic_sales_price_margin_rules`.`created_at`
`dynamic_sales_price_margin_rules`.`updated_at`
`email_smtp_settings`.*
`email_smtp_settings`.`id`
`email_smtp_settings`.`mail_driver`
`email_smtp_settings`.`mail_from_name`
`email_smtp_settings`.`mail_from_email`
`email_smtp_settings`.`enable_queue`
`email_smtp_settings`.`host`
`email_smtp_settings`.`port`
`email_smtp_settings`.`username`
`email_smtp_settings`.`password`
`email_smtp_settings`.`encryption`
`email_smtp_settings`.`is_active`
`email_smtp_settings`.`created_at`
`email_smtp_settings`.`updated_at`
`employees`.*
`employees`.`id`
`employees`.`employee_code`
`employees`.`full_name`
`employees`.`designation`
`employees`.`email`
`employees`.`mobile_number`
`employees`.`date_of_joining`
`employees`.`branch_id`
`employees`.`user_role_id`
`employees`.`is_sales_person`
`employees`.`reporting_manager_id`
`employees`.`login_user_id`
`employees`.`address`
`employees`.`city`
`employees`.`state_id`
`employees`.`country_id`
`employees`.`pincode`
`employees`.`is_active`
`employees`.`delete_status`
`employees`.`created_at`
`employees`.`updated_at`
`exchange_items`.*
`exchange_items`.`id`
`exchange_items`.`item_name`
`exchange_items`.`item_code`
`exchange_items`.`item_description`
`exchange_items`.`mrp`
`exchange_items`.`gst_percent`
`exchange_items`.`exchange_value`
`exchange_items`.`branch_id`
`exchange_items`.`delete_status`
`exchange_items`.`created_at`
`exchange_items`.`updated_at`
`expense_voucher`.*
`expense_voucher`.`id`
`expense_voucher`.`voucher_type_id`
`expense_voucher`.`voucher_no`
`expense_voucher`.`voucher_date`
`expense_voucher`.`ledger_id`
`expense_voucher`.`ledger_account_id`
`expense_voucher`.`expense_head`
`expense_voucher`.`gst_aplicability`
`expense_voucher`.`ref_bill_no`
`expense_voucher`.`instrument_type`
`expense_voucher`.`instrument_number`
`expense_voucher`.`amount`
`expense_voucher`.`branch_id`
`expense_voucher`.`user_id`
`expense_voucher`.`narration`
`expense_voucher`.`delete_status`
`expense_voucher`.`created_at`
`expense_voucher`.`updated_at`
`expense_voucher`.`payment_date`
`expense_voucher`.`created_by`
`expense_voucher`.`modified_by`
`expense_voucher`.`finance_year_id`
`expense_voucher`.`bank_name`
`expense_voucher`.`reference_id`
`expense_voucher_allocations`.*
`expense_voucher_allocations`.`id`
`expense_voucher_allocations`.`expense_id`
`expense_voucher_allocations`.`invoice_id`
`expense_voucher_allocations`.`allocated_amount`
`expense_voucher_allocations`.`remarks`
`expense_voucher_allocations`.`delete_status`
`expense_voucher_allocations`.`created_at`
`expense_voucher_allocations`.`updated_at`
`final_ledger_balance`.*
`final_ledger_balance`.`ledger_id`
`final_ledger_balance`.`branch_id`
`final_ledger_balance`.`finance_year_id`
`final_ledger_balance`.`opening_balance`
`final_ledger_balance`.`transaction_dr`
`final_ledger_balance`.`transaction_cr`
`final_ledger_balance`.`closing_balance`
`financial_years`.*
`financial_years`.`id`
`financial_years`.`branch_id`
`financial_years`.`year`
`financial_years`.`fiscal_year`
`financial_years`.`start_date`
`financial_years`.`end_date`
`financial_years`.`delete_status`
`financial_years`.`created_at`
`financial_years`.`updated_at`
`gst_registration_types`.*
`gst_registration_types`.`id`
`gst_registration_types`.`type_name`
`gst_registration_types`.`description`
`gst_registration_types`.`is_default`
`gst_registration_types`.`is_active`
`gst_registration_types`.`delete_status`
`gst_registration_types`.`created_at`
`gst_registration_types`.`updated_at`
`invoice_outstanding`.*
`invoice_outstanding`.`id`
`invoice_outstanding`.`voucher_type_id`
`invoice_outstanding`.`voucher_id`
`invoice_outstanding`.`voucher_number`
`invoice_outstanding`.`ledger_id`
`invoice_outstanding`.`invoice_date`
`invoice_outstanding`.`dr_amount`
`invoice_outstanding`.`cr_amount`
`invoice_outstanding`.`branch_id`
`invoice_outstanding`.`finance_year_id`
`invoice_outstanding`.`narration`
`invoice_outstanding`.`created_at`
`invoice_outstanding`.`updated_at`
`invoice_outstanding`.`delete_status`
`invoice_outstanding`.`due_date`
`item_effective_pricing`.*
`item_effective_pricing`.`branch_id`
`item_effective_pricing`.`item_id`
`item_effective_pricing`.`price_basis`
`item_effective_pricing`.`base_price`
`item_effective_pricing`.`unit_price`
`item_effective_pricing`.`applied_rules_json`
`item_effective_pricing`.`rules_hash`
`item_effective_pricing`.`valid_from`
`item_effective_pricing`.`valid_to`
`item_effective_pricing`.`updated_at`
`item_transactions`.*
`item_transactions`.`id`
`item_transactions`.`item_id`
`item_transactions`.`branch_id`
`item_transactions`.`finance_year_id`
`item_transactions`.`godown_id`
`item_transactions`.`voucher_type_id`
`item_transactions`.`in_out_type`
`item_transactions`.`quantity`
`item_transactions`.`rate`
`item_transactions`.`transaction_value`
`item_transactions`.`transaction_date`
`item_transactions`.`voucher_id`
`item_transactions`.`voucher_type`
`item_transactions`.`reference_table`
`item_transactions`.`reference_id`
`item_transactions`.`narration`
`item_transactions`.`created_at`
`item_transactions`.`delete_status`
`items`.*
`items`.`id`
`items`.`item_name`
`items`.`item_code`
`items`.`packing`
`items`.`hsn_sac_id`
`items`.`item_cat_id`
`items`.`godown_id`
`items`.`uom_id`
`items`.`brand_id`
`items`.`company_id`
`items`.`price`
`items`.`mrp`
`items`.`cost`
`items`.`purchase_price`
`items`.`sale_price`
`items`.`tax_rate`
`items`.`stock_quantity`
`items`.`max_qty`
`items`.`min_qty`
`items`.`reorder_days`
`items`.`low_stock_alert`
`items`.`branch_id`
`items`.`delete_status`
`items`.`created_at`
`items`.`updated_at`
`items`.`valuation_method`
`items`.`item_type`
`items`.`item_name_key`
`items`.`name_norm`
`items`.`aliases_norm`
`items_brands`.*
`items_brands`.`id`
`items_brands`.`brand_name`
`items_brands`.`description`
`items_brands`.`branch_id`
`items_brands`.`is_active`
`items_brands`.`delete_status`
`items_brands`.`created_at`
`items_brands`.`updated_at`
`items_category`.*
`items_category`.`id`
`items_category`.`category_name`
`items_category`.`is_active`
`items_category`.`description`
`items_category`.`branch_id`
`items_category`.`delete_status`
`items_category`.`created_at`
`items_category`.`updated_at`
`items_category_discounts_map`.*
`items_category_discounts_map`.`id`
`items_category_discounts_map`.`item_cat_id`
`items_category_discounts_map`.`discount_source`
`items_category_discounts_map`.`source_id`
`items_category_discounts_map`.`discount_type`
`items_category_discounts_map`.`discount_value`
`items_category_discounts_map`.`is_active`
`items_category_discounts_map`.`branch_id`
`items_category_discounts_map`.`created_at`
`items_category_discounts_map`.`updated_at`
`items_company`.*
`items_company`.`id`
`items_company`.`company_name`
`items_company`.`description`
`items_company`.`branch_id`
`items_company`.`is_active`
`items_company`.`delete_status`
`items_company`.`created_at`
`items_company`.`updated_at`
`items_delivery_sources`.*
`items_delivery_sources`.`id`
`items_delivery_sources`.`code`
`items_delivery_sources`.`title`
`items_delivery_sources`.`description`
`items_delivery_sources`.`active_status`
`items_delivery_sources`.`created_at`
`items_delivery_sources`.`updated_at`
`items_discount_categories`.*
`items_discount_categories`.`id`
`items_discount_categories`.`category_name`
`items_discount_categories`.`description`
`items_discount_categories`.`discount_type_id`
`items_discount_categories`.`discount_type`
`items_discount_categories`.`is_default`
`items_discount_categories`.`delete_status`
`items_discount_categories`.`created_at`
`items_discount_categories`.`updated_at`
`items_discount_types`.*
`items_discount_types`.`id`
`items_discount_types`.`discount_type_name`
`items_discount_types`.`description`
`items_discount_types`.`is_active`
`items_discount_types`.`delete_status`
`items_discount_types`.`created_at`
`items_discount_types`.`updated_at`
`items_godowns`.*
`items_godowns`.`id`
`items_godowns`.`godown_name`
`items_godowns`.`code`
`items_godowns`.`description`
`items_godowns`.`branch_id`
`items_godowns`.`address`
`items_godowns`.`city`
`items_godowns`.`pincode`
`items_godowns`.`state_id`
`items_godowns`.`country_id`
`items_godowns`.`contact_number`
`items_godowns`.`email`
`items_godowns`.`incharge_name`
`items_godowns`.`is_primary`
`items_godowns`.`active_status`
`items_godowns`.`delete_status`
`items_godowns`.`created_at`
`items_godowns`.`updated_at`
`items_hsn_sac`.*
`items_hsn_sac`.`id`
`items_hsn_sac`.`hsn_sac_code`
`items_hsn_sac`.`effective_date`
`items_hsn_sac`.`active_status`
`items_hsn_sac`.`gst`
`items_hsn_sac`.`cgst`
`items_hsn_sac`.`sgst`
`items_hsn_sac`.`igst`
`items_hsn_sac`.`cess`
`items_hsn_sac`.`branch_id`
`items_hsn_sac`.`is_delete`
`items_hsn_sac`.`created_at`
`items_hsn_sac`.`updated_at`
`items_opening_stock`.*
`items_opening_stock`.`id`
`items_opening_stock`.`item_id`
`items_opening_stock`.`branch_id`
`items_opening_stock`.`finance_year_id`
`items_opening_stock`.`opening_qty`
`items_opening_stock`.`opening_rate`
`items_opening_stock`.`opening_value`
`items_opening_stock`.`created_at`
`items_opening_stock`.`updated_at`
`items_scheme_discounts`.*
`items_scheme_discounts`.`id`
`items_scheme_discounts`.`scheme_name`
`items_scheme_discounts`.`discount_type_id`
`items_scheme_discounts`.`discount_type`
`items_scheme_discounts`.`applicable_districts`
`items_scheme_discounts`.`effective_from`
`items_scheme_discounts`.`effective_to`
`items_scheme_discounts`.`poster_image`
`items_scheme_discounts`.`branch_id`
`items_scheme_discounts`.`is_active`
`items_scheme_discounts`.`delete_status`
`items_scheme_discounts`.`created_at`
`items_scheme_discounts`.`updated_at`
`items_stock_ledger`.*
`items_stock_ledger`.`id`
`items_stock_ledger`.`item_id`
`items_stock_ledger`.`branch_id`
`items_stock_ledger`.`trans_type`
`items_stock_ledger`.`trans_ref_id`
`items_stock_ledger`.`trans_date`
`items_stock_ledger`.`qty_in`
`items_stock_ledger`.`qty_out`
`items_stock_ledger`.`balance_qty`
`items_stock_ledger`.`narration`
`items_stock_ledger`.`created_at`
`items_stock_summary`.*
`items_stock_summary`.`id`
`items_stock_summary`.`item_id`
`items_stock_summary`.`branch_id`
`items_stock_summary`.`opening_qty`
`items_stock_summary`.`inward_qty`
`items_stock_summary`.`outward_qty`
`items_stock_summary`.`closing_qty`
`items_stock_summary`.`last_updated`
`items_tax_hsn_sac`.*
`items_tax_hsn_sac`.`id`
`items_tax_hsn_sac`.`hsn_sac_code`
`items_tax_hsn_sac`.`tax_percentage`
`items_tax_hsn_sac`.`cgst`
`items_tax_hsn_sac`.`sgst`
`items_tax_hsn_sac`.`igst`
`items_tax_hsn_sac`.`cess`
`items_tax_hsn_sac`.`tax_type`
`items_tax_hsn_sac`.`tax_group_name`
`items_tax_hsn_sac`.`effective_date`
`items_tax_hsn_sac`.`active_status`
`items_tax_hsn_sac`.`branch_id`
`items_tax_hsn_sac`.`company_id`
`items_tax_hsn_sac`.`state_id`
`items_tax_hsn_sac`.`country_id`
`items_tax_hsn_sac`.`is_delete`
`items_tax_hsn_sac`.`created_at`
`items_tax_hsn_sac`.`updated_at`
`items_uom`.*
`items_uom`.`id`
`items_uom`.`uom_name`
`items_uom`.`uom_code`
`items_uom`.`description`
`items_uom`.`branch_id`
`items_uom`.`created_at`
`items_uom`.`updated_at`
`items_uom`.`delete_status`
`journal_voucher_lines`.*
`journal_voucher_lines`.`id`
`journal_voucher_lines`.`journal_voucher_id`
`journal_voucher_lines`.`ledger_id`
`journal_voucher_lines`.`dr_amount`
`journal_voucher_lines`.`cr_amount`
`journal_voucher_lines`.`delete_status`
`journal_voucher_lines`.`created_at`
`journal_voucher_lines`.`updated_at`
`journal_vouchers`.*
`journal_vouchers`.`id`
`journal_vouchers`.`voucher_number`
`journal_vouchers`.`voucher_type_id`
`journal_vouchers`.`voucher_date`
`journal_vouchers`.`journal_date`
`journal_vouchers`.`branch_id`
`journal_vouchers`.`finance_year_id`
`journal_vouchers`.`narration`
`journal_vouchers`.`posting_status`
`journal_vouchers`.`delete_status`
`journal_vouchers`.`created_by`
`journal_vouchers`.`updated_by`
`journal_vouchers`.`created_at`
`journal_vouchers`.`updated_at`
`ledger_bank_accounts`.*
`ledger_bank_accounts`.`id`
`ledger_bank_accounts`.`ledger_id`
`ledger_bank_accounts`.`branch_id`
`ledger_bank_accounts`.`account_name`
`ledger_bank_accounts`.`account_no`
`ledger_bank_accounts`.`ifsc_code`
`ledger_bank_accounts`.`bank_name`
`ledger_bank_accounts`.`branch_name`
`ledger_bank_accounts`.`account_type`
`ledger_bank_accounts`.`upi_id`
`ledger_bank_accounts`.`swift_code`
`ledger_bank_accounts`.`micr_code`
`ledger_bank_accounts`.`bank_details_applies_to`
`ledger_bank_accounts`.`is_primary`
`ledger_bank_accounts`.`opening_balance`
`ledger_bank_accounts`.`balance_type`
`ledger_bank_accounts`.`notes`
`ledger_bank_accounts`.`active_status`
`ledger_bank_accounts`.`delete_status`
`ledger_bank_accounts`.`created_at`
`ledger_bank_accounts`.`updated_at`
`ledger_contact_details`.*
`ledger_contact_details`.`id`
`ledger_contact_details`.`ledger_id`
`ledger_contact_details`.`contact_person_name`
`ledger_contact_details`.`contact_person_last_name`
`ledger_contact_details`.`designation`
`ledger_contact_details`.`contact_number`
`ledger_contact_details`.`whatsapp_number`
`ledger_contact_details`.`email_address`
`ledger_contact_details`.`is_primary`
`ledger_contact_details`.`created_at`
`ledger_contact_details`.`updated_at`
`ledger_details`.*
`ledger_details`.`id`
`ledger_details`.`ledger_name`
`ledger_details`.`trade_name`
`ledger_details`.`contact_person_name`
`ledger_details`.`mail_to`
`ledger_details`.`address`
`ledger_details`.`city`
`ledger_details`.`pincode`
`ledger_details`.`state_id`
`ledger_details`.`state_code`
`ledger_details`.`country_id`
`ledger_details`.`gst_verified`
`ledger_details`.`gst_registration_types_id`
`ledger_details`.`gst_number`
`ledger_details`.`pan_number`
`ledger_details`.`company_contact_number`
`ledger_details`.`whatsapp_number`
`ledger_details`.`mobile`
`ledger_details`.`email_id`
`ledger_details`.`website`
`ledger_details`.`tags`
`ledger_details`.`party_cat_id`
`ledger_details`.`parent_group_id`
`ledger_details`.`account_group_id`
`ledger_details`.`led_group_id`
`ledger_details`.`credit_days`
`ledger_details`.`credit_amount`
`ledger_details`.`credit_limit`
`ledger_details`.`auto_block_on_overdue`
`ledger_details`.`delivery_source`
`ledger_details`.`delivery_source_id`
`ledger_details`.`branch_id`
`ledger_details`.`delete_status`
`ledger_details`.`module`
`ledger_details`.`ledger_key_id`
`ledger_details`.`voucher_type_id`
`ledger_details`.`tds_section_code`
`ledger_details`.`ledger_type`
`ledger_details`.`charge_kind`
`ledger_details`.`system_ledger_applies_to`
`ledger_details`.`is_carrier_agent`
`ledger_details`.`is_default_carrier_agent`
`ledger_details`.`opening_balance`
`ledger_details`.`opening_balance_type`
`ledger_details`.`created_at`
`ledger_details`.`updated_at`
`ledger_entries_cash`.*
`ledger_entries_cash`.`id`
`ledger_entries_cash`.`ledger_name`
`ledger_entries_cash`.`trade_name`
`ledger_entries_cash`.`led_type_id`
`ledger_entries_cash`.`voucher_type_id`
`ledger_entries_cash`.`sales_entry_id`
`ledger_entries_cash`.`address`
`ledger_entries_cash`.`city`
`ledger_entries_cash`.`pincode`
`ledger_entries_cash`.`state_id`
`ledger_entries_cash`.`country_id`
`ledger_entries_cash`.`gst_registration_types_id`
`ledger_entries_cash`.`gst_number`
`ledger_entries_cash`.`pan_number`
`ledger_entries_cash`.`company_contact_number`
`ledger_entries_cash`.`whatsapp_number`
`ledger_entries_cash`.`email_id`
`ledger_entries_cash`.`delivery_source`
`ledger_entries_cash`.`branch_id`
`ledger_entries_cash`.`delete_status`
`ledger_entries_cash`.`created_at`
`ledger_entries_cash`.`updated_at`
`ledger_groups`.*
`ledger_groups`.`id`
`ledger_groups`.`title`
`ledger_groups`.`parent_group_id`
`ledger_groups`.`is_primary`
`ledger_groups`.`is_secondary`
`ledger_groups`.`sub_group`
`ledger_groups`.`delete_status`
`ledger_groups`.`main_group`
`ledger_groups`.`parent_group_title`
`ledger_groups`.`description`
`ledger_groups`.`active_status`
`ledger_groups`.`created_at`
`ledger_groups`.`updated_at`
`ledger_keys`.*
`ledger_keys`.`id`
`ledger_keys`.`ledger_key`
`ledger_keys`.`header_field`
`ledger_keys`.`description`
`ledger_keys`.`section_code`
`ledger_keys`.`ledger_type`
`ledger_keys`.`editable`
`ledger_keys`.`apply_on`
`ledger_keys`.`module`
`ledger_keys`.`account_category`
`ledger_keys`.`account_group`
`ledger_keys`.`default_ledger`
`ledger_keys`.`is_active`
`ledger_keys`.`created_at`
`ledger_keys`.`created_by`
`ledger_keys`.`updated_at`
`ledger_keys`.`updated_by`
`ledger_keys`.`external_ref_code`
`ledger_opening_balances`.*
`ledger_opening_balances`.`id`
`ledger_opening_balances`.`ledger_id`
`ledger_opening_balances`.`finance_year_id`
`ledger_opening_balances`.`financial_year`
`ledger_opening_balances`.`opening_debit`
`ledger_opening_balances`.`opening_credit`
`ledger_opening_balances`.`credit_period`
`ledger_opening_balances`.`branch_id`
`ledger_opening_balances`.`created_at`
`ledger_opening_balances`.`updated_at`
`ledger_opening_balances`.`delete_status`
`ledger_postings`.*
`ledger_postings`.`id`
`ledger_postings`.`posting_date`
`ledger_postings`.`txn_date`
`ledger_postings`.`voucher_id`
`ledger_postings`.`voucher_no`
`ledger_postings`.`voucher_type_id`
`ledger_postings`.`voucher_date`
`ledger_postings`.`ledger_id`
`ledger_postings`.`group_id`
`ledger_postings`.`parent_group_id`
`ledger_postings`.`entry_side`
`ledger_postings`.`dr_amount`
`ledger_postings`.`cr_amount`
`ledger_postings`.`branch_id`
`ledger_postings`.`finance_year_id`
`ledger_postings`.`user_id`
`ledger_postings`.`narration`
`ledger_postings`.`sort_order`
`ledger_postings`.`is_main_row`
`ledger_postings`.`cash_or_bank`
`ledger_postings`.`by_or_to`
`ledger_postings`.`other_details`
`ledger_postings`.`correspondent_ledger_id`
`ledger_postings`.`created_at`
`ledger_postings`.`updated_at`
`ledger_postings`.`delete_status`
`ledger_postings`.`deleted_by`
`ledger_postings`.`deleted_at`
`ledger_postings_audit`.*
`ledger_postings_audit`.`id`
`ledger_postings_audit`.`posting_date`
`ledger_postings_audit`.`voucher_id`
`ledger_postings_audit`.`line_no`
`ledger_postings_audit`.`voucher_no`
`ledger_postings_audit`.`voucher_type_id`
`ledger_postings_audit`.`voucher_date`
`ledger_postings_audit`.`ledger_id`
`ledger_postings_audit`.`ledger_group_id`
`ledger_postings_audit`.`amount_signed`
`ledger_postings_audit`.`currency_code`
`ledger_postings_audit`.`fx_rate`
`ledger_postings_audit`.`amount_base`
`ledger_postings_audit`.`branch_id`
`ledger_postings_audit`.`finance_year_id`
`ledger_postings_audit`.`user_id`
`ledger_postings_audit`.`narration`
`ledger_postings_audit`.`correspondent_ledger_id`
`ledger_postings_audit`.`corr_ledger_group_id`
`ledger_postings_audit`.`instrument_no`
`ledger_postings_audit`.`instrument_date`
`ledger_postings_audit`.`recon_status`
`ledger_postings_audit`.`recon_date`
`ledger_postings_audit`.`cost_center_id`
`ledger_postings_audit`.`project_id`
`ledger_postings_audit`.`source_module`
`ledger_postings_audit`.`source_id`
`ledger_postings_audit`.`tds_deduction_id`
`ledger_postings_audit`.`created_at`
`ledger_postings_audit`.`updated_at`
`ledger_postings_audit`.`delete_status`
`ledger_postings_audit`.`deleted_by`
`ledger_postings_audit`.`deleted_at`
`ledger_shipping_details`.*
`ledger_shipping_details`.`id`
`ledger_shipping_details`.`ledger_id`
`ledger_shipping_details`.`ledger_cash_id`
`ledger_shipping_details`.`parent_led_id`
`ledger_shipping_details`.`voucher_type_id`
`ledger_shipping_details`.`is_primary`
`ledger_shipping_details`.`ship_to`
`ledger_shipping_details`.`mailing_name`
`ledger_shipping_details`.`shipping_address`
`ledger_shipping_details`.`shipping_contact`
`ledger_shipping_details`.`shipping_city`
`ledger_shipping_details`.`shipping_state_id`
`ledger_shipping_details`.`shipping_country_id`
`ledger_shipping_details`.`shipping_pincode`
`ledger_shipping_details`.`shipping_gstin`
`ledger_shipping_details`.`place_of_supply`
`ledger_shipping_details`.`delivery_source`
`ledger_shipping_details`.`godown_id`
`ledger_shipping_details`.`plant_id`
`ledger_shipping_details`.`branch_id`
`ledger_shipping_details`.`created_at`
`ledger_shipping_details`.`updated_at`
`ledger_transactions`.*
`ledger_transactions`.`id`
`ledger_transactions`.`ref_table`
`ledger_transactions`.`ref_id`
`ledger_transactions`.`voucher_type_id`
`ledger_transactions`.`voucher_type`
`ledger_transactions`.`voucher_id`
`ledger_transactions`.`voucher_number`
`ledger_transactions`.`voucher_date`
`ledger_transactions`.`ledger_id`
`ledger_transactions`.`ledger_name`
`ledger_transactions`.`parent_group_id`
`ledger_transactions`.`parent_group_title`
`ledger_transactions`.`ledger_group_id`
`ledger_transactions`.`ledger_group_title`
`ledger_transactions`.`dr_amount`
`ledger_transactions`.`cr_amount`
`ledger_transactions`.`narration`
`ledger_transactions`.`delete_status`
`ledger_transactions`.`correspondent_ledger`
`ledger_transactions`.`correspondent_ledger_id`
`ledger_transactions`.`branch_id`
`ledger_transactions`.`created_at`
`ledger_transactions`.`updated_at`
`ledger_transactions`.`by`
`ledger_transactions`.`to`
`ledger_transactions`.`is_other_details`
`ledger_transactions`.`is_cash_bank_detailsreport`
`ledger_transactions`.`correspondent_date`
`ledger_transactions`.`alias_ledger_id`
`ledger_types_deleted`.*
`ledger_types_deleted`.`id`
`ledger_types_deleted`.`title`
`ledger_types_deleted`.`group_type`
`ledger_types_deleted`.`is_default`
`ledger_types_deleted`.`description`
`ledger_types_deleted`.`active_status`
`ledger_types_deleted`.`created_at`
`ledger_types_deleted`.`updated_at`
`mastergst_tokens`.*
`mastergst_tokens`.`id`
`mastergst_tokens`.`gstin`
`mastergst_tokens`.`access_token`
`mastergst_tokens`.`token_expiry`
`mastergst_tokens`.`created_at`
`message_queue`.*
`message_queue`.`id`
`message_queue`.`phone_number`
`message_queue`.`message_text`
`message_queue`.`status`
`message_queue`.`created_at`
`monthly_financial_summary`.*
`monthly_financial_summary`.`summary_month`
`monthly_financial_summary`.`branch_id`
`monthly_financial_summary`.`total_sales`
`monthly_financial_summary`.`total_purchases`
`monthly_financial_summary`.`total_receipts`
`monthly_financial_summary`.`total_payments`
`monthly_financial_summary`.`credit_note`
`monthly_financial_summary`.`debit_note`
`monthly_financial_summary`.`finance_year_id`
`parts`.*
`parts`.`id`
`parts`.`part_id`
`parts`.`part_title`
`parts`.`part_cost`
`parts`.`image_path`
`parts`.`image_url`
`parts`.`is_active`
`parts`.`delete_status`
`parts`.`created_at`
`parts`.`updated_at`
`party_comments`.*
`party_comments`.`id`
`party_comments`.`party_id`
`party_comments`.`comment_type`
`party_comments`.`comment_text`
`party_comments`.`commenter`
`party_comments`.`comment_date`
`party_comments`.`branch_id`
`party_comments`.`delete_status`
`party_comments`.`created_at`
`party_comments`.`updated_at`
`payment_details_draft`.*
`payment_details_draft`.`id`
`payment_details_draft`.`transaction_id`
`payment_details_draft`.`voucher_type_id`
`payment_details_draft`.`voucher_date`
`payment_details_draft`.`ledger_id`
`payment_details_draft`.`ledger_account_id`
`payment_details_draft`.`ledger_account_name`
`payment_details_draft`.`instrument_type`
`payment_details_draft`.`instrument_number`
`payment_details_draft`.`amount`
`payment_details_draft`.`branch_id`
`payment_details_draft`.`narration`
`payment_details_draft`.`received_status`
`payment_details_draft`.`move_to_receipt`
`payment_details_draft`.`delete_status`
`payment_details_draft`.`created_at`
`payment_details_draft`.`updated_at`
`payment_purchase_mapping`.*
`payment_purchase_mapping`.`id`
`payment_purchase_mapping`.`payment_transaction_id`
`payment_purchase_mapping`.`purchase_entry_id`
`payment_purchase_mapping`.`allocated_amount`
`payment_purchase_mapping`.`branch_id`
`payment_purchase_mapping`.`delete_status`
`payment_purchase_mapping`.`created_at`
`payment_purchase_mapping`.`updated_at`
`payment_voucher_allocations`.*
`payment_voucher_allocations`.`id`
`payment_voucher_allocations`.`payment_voucher_id`
`payment_voucher_allocations`.`voucher_type_id`
`payment_voucher_allocations`.`invoice_id`
`payment_voucher_allocations`.`allocated_amount`
`payment_voucher_allocations`.`remarks`
`payment_voucher_allocations`.`delete_status`
`payment_voucher_allocations`.`created_at`
`payment_voucher_allocations`.`updated_at`
`payment_vouchers`.*
`payment_vouchers`.`id`
`payment_vouchers`.`entry_type`
`payment_vouchers`.`voucher_type_id`
`payment_vouchers`.`cash_or_bank`
`payment_vouchers`.`voucher_no`
`payment_vouchers`.`voucher_date`
`payment_vouchers`.`ledger_id`
`payment_vouchers`.`ledger_account_id`
`payment_vouchers`.`expense_head`
`payment_vouchers`.`gst_aplicability`
`payment_vouchers`.`ref_bill_no`
`payment_vouchers`.`instrument_type`
`payment_vouchers`.`instrument_number`
`payment_vouchers`.`amount`
`payment_vouchers`.`branch_id`
`payment_vouchers`.`user_id`
`payment_vouchers`.`narration`
`payment_vouchers`.`delete_status`
`payment_vouchers`.`created_at`
`payment_vouchers`.`updated_at`
`payment_vouchers`.`created_by`
`payment_vouchers`.`modified_by`
`payment_vouchers`.`finance_year_id`
`payment_vouchers`.`bank_name`
`payment_vouchers`.`account_no`
`payment_vouchers`.`ifsc_code`
`payment_vouchers`.`reference_id`
`plant_details`.*
`plant_details`.`id`
`plant_details`.`plant_name`
`plant_details`.`plant_code`
`plant_details`.`address`
`plant_details`.`city`
`plant_details`.`pincode`
`plant_details`.`state_id`
`plant_details`.`country_id`
`plant_details`.`contact_number`
`plant_details`.`email`
`plant_details`.`is_active`
`plant_details`.`branch_id`
`plant_details`.`delete_status`
`plant_details`.`created_at`
`plant_details`.`updated_at`
`posting_audit_log`.*
`posting_audit_log`.`id`
`posting_audit_log`.`voucher_type_id`
`posting_audit_log`.`ref_id`
`posting_audit_log`.`ref_table`
`posting_audit_log`.`posting_action`
`posting_audit_log`.`message`
`posting_audit_log`.`posting_time`
`posting_audit_log`.`posted_by`
`posting_control`.*
`posting_control`.`id`
`posting_control`.`voucher_type_id`
`posting_control`.`voucher_id`
`posting_control`.`posting_status`
`posting_control`.`posted_by`
`posting_control`.`posting_at`
`posting_period_control`.*
`posting_period_control`.`period_start`
`posting_period_control`.`period_end`
`posting_period_control`.`is_locked`
`posting_period_control`.`locked_by`
`posting_period_control`.`locked_at`
`postings_audit_log`.*
`postings_audit_log`.`id`
`postings_audit_log`.`voucher_id`
`postings_audit_log`.`voucher_type`
`postings_audit_log`.`table_name`
`postings_audit_log`.`row_data`
`postings_audit_log`.`deleted_by`
`postings_audit_log`.`deleted_at`
`postings_audit_log`.`recovered`
`pricing_recompute_queue`.*
`pricing_recompute_queue`.`id`
`pricing_recompute_queue`.`branch_id`
`pricing_recompute_queue`.`item_id`
`pricing_recompute_queue`.`reason`
`pricing_recompute_queue`.`created_at`
`purchase_entries`.*
`purchase_entries`.`id`
`purchase_entries`.`purchase_invoice_no`
`purchase_entries`.`purchase_invoice_date`
`purchase_entries`.`voucher_number`
`purchase_entries`.`voucher_type_id`
`purchase_entries`.`entry_mode`
`purchase_entries`.`grn_ref_id`
`purchase_entries`.`grn_status`
`purchase_entries`.`sales_channel`
`purchase_entries`.`sales_person_id`
`purchase_entries`.`source_quotation_id`
`purchase_entries`.`voucher_date`
`purchase_entries`.`voucher_time`
`purchase_entries`.`due_date`
`purchase_entries`.`ledger_id`
`purchase_entries`.`party_cat_id`
`purchase_entries`.`invoice_amount`
`purchase_entries`.`price`
`purchase_entries`.`pri_discount`
`purchase_entries`.`proportionate_discount`
`purchase_entries`.`total_discount`
`purchase_entries`.`discount_coupon_code`
`purchase_entries`.`applied_discount_category`
`purchase_entries`.`applied_discount_category_id`
`purchase_entries`.`taxable_amount`
`purchase_entries`.`item_tax_amout`
`purchase_entries`.`add_charges_fixed_tax_amount`
`purchase_entries`.`add_charges_proportionate_tax_amount`
`purchase_entries`.`total_tax_amount`
`purchase_entries`.`tds_amount`
`purchase_entries`.`freight_charges`
`purchase_entries`.`add_charges`
`purchase_entries`.`sgst_amount`
`purchase_entries`.`cgst_amount`
`purchase_entries`.`igst_amount`
`purchase_entries`.`cess_amount`
`purchase_entries`.`payment_status`
`purchase_entries`.`narration`
`purchase_entries`.`additional_discount_remarks`
`purchase_entries`.`discount_details`
`purchase_entries`.`receiver_name`
`purchase_entries`.`receiver_contact_number`
`purchase_entries`.`branch_id`
`purchase_entries`.`user_id`
`purchase_entries`.`finance_year_id`
`purchase_entries`.`delete_status`
`purchase_entries`.`created_at`
`purchase_entries`.`updated_at`
`purchase_entries`.`round_off`
`purchase_entries`.`total_amount`
`purchase_entries`.`irn`
`purchase_entries`.`ack_no`
`purchase_entries`.`ack_date`
`purchase_entries`.`qr_code`
`purchase_entries`.`einvoice_status`
`purchase_entries`.`einvoice_error`
`purchase_entries`.`ewaybill_no`
`purchase_entries`.`ewaybill_date`
`purchase_entries`.`ewaybill_status`
`purchase_entries`.`ewaybill_error`
`purchase_entries`.`posting_status`
`purchase_entries_old`.*
`purchase_entries_old`.`id`
`purchase_entries_old`.`voucher_number`
`purchase_entries_old`.`voucher_type`
`purchase_entries_old`.`voucher_date`
`purchase_entries_old`.`due_date`
`purchase_entries_old`.`ledger_id`
`purchase_entries_old`.`voucher_type_id`
`purchase_entries_old`.`finance_year_id`
`purchase_entries_old`.`invoice_no`
`purchase_entries_old`.`invoice_date`
`purchase_entries_old`.`price`
`purchase_entries_old`.`total_discount`
`purchase_entries_old`.`applied_discount_category_id`
`purchase_entries_old`.`taxable_amount`
`purchase_entries_old`.`total_amount`
`purchase_entries_old`.`tax_amount`
`purchase_entries_old`.`freight_charges`
`purchase_entries_old`.`add_charges`
`purchase_entries_old`.`sgst_amount`
`purchase_entries_old`.`cgst_amount`
`purchase_entries_old`.`igst_amount`
`purchase_entries_old`.`cess_amount`
`purchase_entries_old`.`payment_status`
`purchase_entries_old`.`narration`
`purchase_entries_old`.`branch_id`
`purchase_entries_old`.`delete_status`
`purchase_entries_old`.`created_at`
`purchase_entries_old`.`updated_at`
`purchase_entry_items`.*
`purchase_entry_items`.`id`
`purchase_entry_items`.`purchase_entry_id`
`purchase_entry_items`.`godown_id`
`purchase_entry_items`.`item_id`
`purchase_entry_items`.`hsn_sac_id`
`purchase_entry_items`.`uom_id`
`purchase_entry_items`.`quantity`
`purchase_entry_items`.`rate`
`purchase_entry_items`.`price`
`purchase_entry_items`.`discount_type`
`purchase_entry_items`.`discount_source_id`
`purchase_entry_items`.`discount_value`
`purchase_entry_items`.`discount_amount`
`purchase_entry_items`.`proportionate_discount`
`purchase_entry_items`.`taxable_amount`
`purchase_entry_items`.`proportionate_add_charges_amount`
`purchase_entry_items`.`tax_percentage`
`purchase_entry_items`.`cgst_percentage`
`purchase_entry_items`.`sgst_percentage`
`purchase_entry_items`.`igst_percentage`
`purchase_entry_items`.`cess_percentage`
`purchase_entry_items`.`tax_amount`
`purchase_entry_items`.`cgst_amount`
`purchase_entry_items`.`sgst_amount`
`purchase_entry_items`.`igst_amount`
`purchase_entry_items`.`cess_amount`
`purchase_entry_items`.`branch_id`
`purchase_entry_items`.`delete_status`
`purchase_entry_items`.`created_at`
`purchase_entry_items`.`updated_at`
`purchase_entry_items_old`.*
`purchase_entry_items_old`.`id`
`purchase_entry_items_old`.`purchase_entry_id`
`purchase_entry_items_old`.`item_id`
`purchase_entry_items_old`.`godown_id`
`purchase_entry_items_old`.`voucher_type_id`
`purchase_entry_items_old`.`hsn_sac_id`
`purchase_entry_items_old`.`uom_id`
`purchase_entry_items_old`.`quantity`
`purchase_entry_items_old`.`rate`
`purchase_entry_items_old`.`price`
`purchase_entry_items_old`.`discount_type_id`
`purchase_entry_items_old`.`discount_value`
`purchase_entry_items_old`.`discount_amount`
`purchase_entry_items_old`.`taxable_amount`
`purchase_entry_items_old`.`gst_percentage`
`purchase_entry_items_old`.`cgst_percentage`
`purchase_entry_items_old`.`sgst_percentage`
`purchase_entry_items_old`.`igst_percentage`
`purchase_entry_items_old`.`cess_percentage`
`purchase_entry_items_old`.`gst_amount`
`purchase_entry_items_old`.`cgst_amount`
`purchase_entry_items_old`.`sgst_amount`
`purchase_entry_items_old`.`igst_amount`
`purchase_entry_items_old`.`cess_amount`
`purchase_entry_items_old`.`branch_id`
`purchase_entry_items_old`.`delete_status`
`purchase_entry_items_old`.`created_at`
`purchase_entry_items_old`.`updated_at`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`purchase_order_id`
`purchase_order_items`.`item_id`
`purchase_order_items`.`quantity`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`total_price`
`purchase_order_items`.`delete_status`
`purchase_order_items`.`modified_by`
`purchase_order_items`.`created_at`
`purchase_order_items`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`order_date`
`purchase_orders`.`status`
`purchase_orders`.`total_amount`
`purchase_orders`.`branch_id`
`purchase_orders`.`delete_status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_return_items`.*
`purchase_return_items`.`id`
`purchase_return_items`.`purchase_return_id`
`purchase_return_items`.`purchase_entry_id`
`purchase_return_items`.`purchase_return_reason_id`
`purchase_return_items`.`item_id`
`purchase_return_items`.`godown_id`
`purchase_return_items`.`hsn_sac_id`
`purchase_return_items`.`uom_id`
`purchase_return_items`.`quantity`
`purchase_return_items`.`discounted_rate`
`purchase_return_items`.`deduction_type`
`purchase_return_items`.`deduction_value`
`purchase_return_items`.`deduction_amount`
`purchase_return_items`.`discounted_price`
`purchase_return_items`.`proportionate_discount`
`purchase_return_items`.`taxable_amount`
`purchase_return_items`.`proportionate_add_charges_amount`
`purchase_return_items`.`gst_percentage`
`purchase_return_items`.`cgst_percentage`
`purchase_return_items`.`sgst_percentage`
`purchase_return_items`.`igst_percentage`
`purchase_return_items`.`cess_percentage`
`purchase_return_items`.`gst_amount`
`purchase_return_items`.`cgst_amount`
`purchase_return_items`.`sgst_amount`
`purchase_return_items`.`igst_amount`
`purchase_return_items`.`cess_amount`
`purchase_return_items`.`deduction_reason`
`purchase_return_items`.`branch_id`
`purchase_return_items`.`delete_status`
`purchase_return_items`.`created_at`
`purchase_return_items`.`updated_at`
`purchase_return_items_old`.*
`purchase_return_items_old`.`id`
`purchase_return_items_old`.`purchase_return_id`
`purchase_return_items_old`.`purchase_entry_id`
`purchase_return_items_old`.`purchase_entry_item_id`
`purchase_return_items_old`.`item_id`
`purchase_return_items_old`.`branch_id`
`purchase_return_items_old`.`return_quantity`
`purchase_return_items_old`.`unit_price_discounted`
`purchase_return_items_old`.`return_amount`
`purchase_return_items_old`.`return_reason_id`
`purchase_return_items_old`.`remarks`
`purchase_return_items_old`.`delete_status`
`purchase_return_items_old`.`created_at`
`purchase_return_items_old`.`updated_at`
`purchase_return_old`.*
`purchase_return_old`.`id`
`purchase_return_old`.`voucher_number`
`purchase_return_old`.`voucher_date`
`purchase_return_old`.`ledger_id`
`purchase_return_old`.`total_return_qty`
`purchase_return_old`.`total_return_amount`
`purchase_return_old`.`branch_id`
`purchase_return_old`.`return_status`
`purchase_return_old`.`approved_by`
`purchase_return_old`.`created_by`
`purchase_return_old`.`delete_status`
`purchase_return_old`.`created_at`
`purchase_return_old`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`voucher_number`
`purchase_returns`.`voucher_type_id`
`purchase_returns`.`voucher_date`
`purchase_returns`.`ledger_id`
`purchase_returns`.`discounted_rate`
`purchase_returns`.`pri_discount`
`purchase_returns`.`proportionate_discount`
`purchase_returns`.`total_discount`
`purchase_returns`.`total_deduction_amount`
`purchase_returns`.`taxable_amount`
`purchase_returns`.`item_tax_amout`
`purchase_returns`.`add_charges_fixed_tax_amount`
`purchase_returns`.`add_charges_proportionate_tax_amount`
`purchase_returns`.`total_tax_amount`
`purchase_returns`.`tds_amount`
`purchase_returns`.`freight_charges`
`purchase_returns`.`add_charges`
`purchase_returns`.`sgst_amount`
`purchase_returns`.`cgst_amount`
`purchase_returns`.`igst_amount`
`purchase_returns`.`cess_amount`
`purchase_returns`.`payment_status`
`purchase_returns`.`posting_status`
`purchase_returns`.`narration`
`purchase_returns`.`receiver_name`
`purchase_returns`.`receiver_contact_number`
`purchase_returns`.`branch_id`
`purchase_returns`.`finance_year_id`
`purchase_returns`.`delete_status`
`purchase_returns`.`created_at`
`purchase_returns`.`user_id`
`purchase_returns`.`updated_at`
`purchase_returns`.`total_amount`
`purchase_returns`.`round_off`
`quotation_entries`.*
`quotation_entries`.`id`
`quotation_entries`.`voucher_number`
`quotation_entries`.`voucher_type_id`
`quotation_entries`.`sales_channel`
`quotation_entries`.`sales_person_id`
`quotation_entries`.`source_quotation_id`
`quotation_entries`.`voucher_date`
`quotation_entries`.`voucher_time`
`quotation_entries`.`due_date`
`quotation_entries`.`ledger_id`
`quotation_entries`.`party_cat_id`
`quotation_entries`.`invoice_amount`
`quotation_entries`.`price`
`quotation_entries`.`pri_discount`
`quotation_entries`.`proportionate_discount`
`quotation_entries`.`total_discount`
`quotation_entries`.`discount_coupon_code`
`quotation_entries`.`applied_discount_category`
`quotation_entries`.`applied_discount_category_id`
`quotation_entries`.`taxable_amount`
`quotation_entries`.`item_tax_amout`
`quotation_entries`.`add_charges_fixed_tax_amount`
`quotation_entries`.`add_charges_proportionate_tax_amount`
`quotation_entries`.`total_tax_amount`
`quotation_entries`.`tds_amount`
`quotation_entries`.`freight_charges`
`quotation_entries`.`add_charges`
`quotation_entries`.`sgst_amount`
`quotation_entries`.`cgst_amount`
`quotation_entries`.`igst_amount`
`quotation_entries`.`cess_amount`
`quotation_entries`.`payment_status`
`quotation_entries`.`narration`
`quotation_entries`.`additional_discount_remarks`
`quotation_entries`.`discount_details`
`quotation_entries`.`receiver_name`
`quotation_entries`.`receiver_contact_number`
`quotation_entries`.`branch_id`
`quotation_entries`.`user_id`
`quotation_entries`.`finance_year_id`
`quotation_entries`.`delete_status`
`quotation_entries`.`created_at`
`quotation_entries`.`updated_at`
`quotation_entries`.`round_off`
`quotation_entries`.`total_amount`
`quotation_entries`.`irn`
`quotation_entries`.`ack_no`
`quotation_entries`.`ack_date`
`quotation_entries`.`qr_code`
`quotation_entries`.`einvoice_status`
`quotation_entries`.`einvoice_error`
`quotation_entries`.`ewaybill_no`
`quotation_entries`.`ewaybill_date`
`quotation_entries`.`ewaybill_status`
`quotation_entries`.`ewaybill_error`
`quotation_entries`.`posting_status`
`quotation_entry_items`.*
`quotation_entry_items`.`id`
`quotation_entry_items`.`sales_entry_id`
`quotation_entry_items`.`godown_id`
`quotation_entry_items`.`item_id`
`quotation_entry_items`.`hsn_sac_id`
`quotation_entry_items`.`uom_id`
`quotation_entry_items`.`quantity`
`quotation_entry_items`.`rate`
`quotation_entry_items`.`price`
`quotation_entry_items`.`discount_type`
`quotation_entry_items`.`discount_source_id`
`quotation_entry_items`.`discount_value`
`quotation_entry_items`.`discount_amount`
`quotation_entry_items`.`proportionate_discount`
`quotation_entry_items`.`taxable_amount`
`quotation_entry_items`.`proportionate_add_charges_amount`
`quotation_entry_items`.`tax_percentage`
`quotation_entry_items`.`cgst_percentage`
`quotation_entry_items`.`sgst_percentage`
`quotation_entry_items`.`igst_percentage`
`quotation_entry_items`.`cess_percentage`
`quotation_entry_items`.`tax_amount`
`quotation_entry_items`.`cgst_amount`
`quotation_entry_items`.`sgst_amount`
`quotation_entry_items`.`igst_amount`
`quotation_entry_items`.`cess_amount`
`quotation_entry_items`.`branch_id`
`quotation_entry_items`.`delete_status`
`quotation_entry_items`.`created_at`
`quotation_entry_items`.`updated_at`
`receipt_sales_mapping`.*
`receipt_sales_mapping`.`id`
`receipt_sales_mapping`.`receipt_transaction_id`
`receipt_sales_mapping`.`sales_entry_id`
`receipt_sales_mapping`.`allocated_amount`
`receipt_sales_mapping`.`created_at`
`receipt_sales_mapping`.`updated_at`
`receipt_voucher_allocations`.*
`receipt_voucher_allocations`.`id`
`receipt_voucher_allocations`.`receipt_voucher_id`
`receipt_voucher_allocations`.`voucher_type_id`
`receipt_voucher_allocations`.`invoice_id`
`receipt_voucher_allocations`.`allocated_amount`
`receipt_voucher_allocations`.`remarks`
`receipt_voucher_allocations`.`delete_status`
`receipt_voucher_allocations`.`created_at`
`receipt_voucher_allocations`.`updated_at`
`receipt_vouchers`.*
`receipt_vouchers`.`id`
`receipt_vouchers`.`voucher_type_id`
`receipt_vouchers`.`cash_or_bank`
`receipt_vouchers`.`voucher_no`
`receipt_vouchers`.`voucher_date`
`receipt_vouchers`.`ledger_id`
`receipt_vouchers`.`ledger_account_id`
`receipt_vouchers`.`instrument_type`
`receipt_vouchers`.`instrument_number`
`receipt_vouchers`.`bank_name`
`receipt_vouchers`.`amount`
`receipt_vouchers`.`tds_amount`
`receipt_vouchers`.`branch_id`
`receipt_vouchers`.`user_id`
`receipt_vouchers`.`finance_year_id`
`receipt_vouchers`.`reference_id`
`receipt_vouchers`.`narration`
`receipt_vouchers`.`delete_status`
`receipt_vouchers`.`created_by`
`receipt_vouchers`.`modified_by`
`receipt_vouchers`.`created_at`
`receipt_vouchers`.`updated_at`
`report_data_entries`.*
`report_data_entries`.`id`
`report_data_entries`.`entry_type`
`report_data_entries`.`entry_id`
`report_data_entries`.`ledger_id`
`report_data_entries`.`transaction_date`
`report_data_entries`.`voucher_number`
`report_data_entries`.`narration`
`report_data_entries`.`debit_amount`
`report_data_entries`.`credit_amount`
`report_data_entries`.`branch_id`
`report_data_entries`.`item_id`
`report_data_entries`.`hsn_code`
`report_data_entries`.`gst_percentage`
`report_data_entries`.`stock_qty`
`report_data_entries`.`stock_value`
`report_data_entries`.`created_at`
`report_data_entries`.`updated_at`
`sales_entries`.*
`sales_entries`.`id`
`sales_entries`.`voucher_number`
`sales_entries`.`voucher_type_id`
`sales_entries`.`entry_mode`
`sales_entries`.`proforma_ref_id`
`sales_entries`.`proforma_status`
`sales_entries`.`sales_channel`
`sales_entries`.`sales_person_id`
`sales_entries`.`source_quotation_id`
`sales_entries`.`source_sales_id`
`sales_entries`.`quotation_moved_status`
`sales_entries`.`voucher_date`
`sales_entries`.`voucher_time`
`sales_entries`.`due_date`
`sales_entries`.`ledger_id`
`sales_entries`.`party_cat_id`
`sales_entries`.`invoice_amount`
`sales_entries`.`price`
`sales_entries`.`subsidy_scheme_id`
`sales_entries`.`pri_discount`
`sales_entries`.`proportionate_discount`
`sales_entries`.`total_discount`
`sales_entries`.`discount_coupon_code`
`sales_entries`.`applied_discount_category`
`sales_entries`.`applied_discount_category_id`
`sales_entries`.`taxable_amount`
`sales_entries`.`item_tax_amout`
`sales_entries`.`add_charges_fixed_tax_amount`
`sales_entries`.`add_charges_proportionate_tax_amount`
`sales_entries`.`total_tax_amount`
`sales_entries`.`tds_amount`
`sales_entries`.`freight_charges`
`sales_entries`.`add_charges`
`sales_entries`.`sgst_amount`
`sales_entries`.`cgst_amount`
`sales_entries`.`igst_amount`
`sales_entries`.`cess_amount`
`sales_entries`.`payment_status`
`sales_entries`.`narration`
`sales_entries`.`additional_discount_remarks`
`sales_entries`.`discount_details`
`sales_entries`.`receiver_name`
`sales_entries`.`receiver_contact_number`
`sales_entries`.`branch_id`
`sales_entries`.`user_id`
`sales_entries`.`finance_year_id`
`sales_entries`.`delete_status`
`sales_entries`.`created_at`
`sales_entries`.`updated_at`
`sales_entries`.`round_off`
`sales_entries`.`total_amount`
`sales_entries`.`irn`
`sales_entries`.`ack_no`
`sales_entries`.`ack_date`
`sales_entries`.`qr_code`
`sales_entries`.`einvoice_status`
`sales_entries`.`einvoice_error`
`sales_entries`.`ewaybill_no`
`sales_entries`.`ewaybill_date`
`sales_entries`.`ewaybill_status`
`sales_entries`.`ewaybill_error`
`sales_entries`.`posting_status`
`sales_entry_items`.*
`sales_entry_items`.`id`
`sales_entry_items`.`sales_entry_id`
`sales_entry_items`.`godown_id`
`sales_entry_items`.`subsidy_scheme_id`
`sales_entry_items`.`subsidy_billed`
`sales_entry_items`.`other_discount_applicable`
`sales_entry_items`.`item_id`
`sales_entry_items`.`hsn_sac_id`
`sales_entry_items`.`uom_id`
`sales_entry_items`.`quantity`
`sales_entry_items`.`rate`
`sales_entry_items`.`price`
`sales_entry_items`.`discount_type`
`sales_entry_items`.`discount_source_id`
`sales_entry_items`.`discount_value`
`sales_entry_items`.`discount_amount`
`sales_entry_items`.`proportionate_discount`
`sales_entry_items`.`taxable_amount`
`sales_entry_items`.`proportionate_add_charges_amount`
`sales_entry_items`.`tax_percentage`
`sales_entry_items`.`cgst_percentage`
`sales_entry_items`.`sgst_percentage`
`sales_entry_items`.`igst_percentage`
`sales_entry_items`.`cess_percentage`
`sales_entry_items`.`tax_amount`
`sales_entry_items`.`cgst_amount`
`sales_entry_items`.`sgst_amount`
`sales_entry_items`.`igst_amount`
`sales_entry_items`.`cess_amount`
`sales_entry_items`.`branch_id`
`sales_entry_items`.`delete_status`
`sales_entry_items`.`created_at`
`sales_entry_items`.`updated_at`
`sales_invoice_discounts`.*
`sales_invoice_discounts`.`id`
`sales_invoice_discounts`.`invoice_id`
`sales_invoice_discounts`.`branch_id`
`sales_invoice_discounts`.`exchange_id`
`sales_invoice_discounts`.`subsidy_id`
`sales_invoice_discounts`.`discount_coupon_code`
`sales_invoice_discounts`.`other_discount_amount`
`sales_invoice_discounts`.`total_discount`
`sales_invoice_discounts`.`remarks`
`sales_invoice_discounts`.`selected_other_discount_items`
`sales_invoice_discounts`.`selected_subsidy_items`
`sales_invoice_discounts`.`delete_status`
`sales_invoice_discounts`.`created_at`
`sales_invoice_discounts`.`updated_at`
`sales_invoice_exchange`.*
`sales_invoice_exchange`.`id`
`sales_invoice_exchange`.`discount_id`
`sales_invoice_exchange`.`old_item_id`
`sales_invoice_exchange`.`machine_name`
`sales_invoice_exchange`.`list_price`
`sales_invoice_exchange`.`exchange_value`
`sales_invoice_exchange`.`remarks`
`sales_invoice_other_discounts`.*
`sales_invoice_other_discounts`.`id`
`sales_invoice_other_discounts`.`discount_id`
`sales_invoice_other_discounts`.`discount_type`
`sales_invoice_other_discounts`.`amount`
`sales_invoice_other_discounts`.`reason`
`sales_invoice_subsidy`.*
`sales_invoice_subsidy`.`id`
`sales_invoice_subsidy`.`invoice_id`
`sales_invoice_subsidy`.`scheme_id`
`sales_invoice_subsidy`.`scheme_document_id`
`sales_invoice_subsidy`.`document_name`
`sales_invoice_subsidy`.`document_verified`
`sales_invoice_subsidy`.`remarks`
`sales_invoice_subsidy`.`branch_id`
`sales_invoice_subsidy`.`created_by`
`sales_invoice_subsidy`.`modified_by`
`sales_invoice_subsidy`.`created_at`
`sales_invoice_subsidy`.`updated_at`
`sales_return_items`.*
`sales_return_items`.`id`
`sales_return_items`.`sales_return_id`
`sales_return_items`.`sales_entry_id`
`sales_return_items`.`sales_return_reason_id`
`sales_return_items`.`item_id`
`sales_return_items`.`godown_id`
`sales_return_items`.`hsn_sac_id`
`sales_return_items`.`uom_id`
`sales_return_items`.`quantity`
`sales_return_items`.`discounted_rate`
`sales_return_items`.`deduction_type`
`sales_return_items`.`deduction_value`
`sales_return_items`.`deduction_amount`
`sales_return_items`.`discounted_price`
`sales_return_items`.`proportionate_discount`
`sales_return_items`.`taxable_amount`
`sales_return_items`.`proportionate_add_charges_amount`
`sales_return_items`.`gst_percentage`
`sales_return_items`.`cgst_percentage`
`sales_return_items`.`sgst_percentage`
`sales_return_items`.`igst_percentage`
`sales_return_items`.`cess_percentage`
`sales_return_items`.`gst_amount`
`sales_return_items`.`cgst_amount`
`sales_return_items`.`sgst_amount`
`sales_return_items`.`igst_amount`
`sales_return_items`.`cess_amount`
`sales_return_items`.`deduction_reason`
`sales_return_items`.`branch_id`
`sales_return_items`.`delete_status`
`sales_return_items`.`created_at`
`sales_return_items`.`updated_at`
`sales_return_reasons`.*
`sales_return_reasons`.`id`
`sales_return_reasons`.`reason_title`
`sales_return_reasons`.`description`
`sales_return_reasons`.`is_active`
`sales_return_reasons`.`created_at`
`sales_return_reasons`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`voucher_number`
`sales_returns`.`voucher_type_id`
`sales_returns`.`voucher_date`
`sales_returns`.`ledger_id`
`sales_returns`.`discounted_rate`
`sales_returns`.`pri_discount`
`sales_returns`.`proportionate_discount`
`sales_returns`.`total_discount`
`sales_returns`.`total_deduction_amount`
`sales_returns`.`taxable_amount`
`sales_returns`.`item_tax_amout`
`sales_returns`.`add_charges_fixed_tax_amount`
`sales_returns`.`add_charges_proportionate_tax_amount`
`sales_returns`.`total_tax_amount`
`sales_returns`.`tds_amount`
`sales_returns`.`freight_charges`
`sales_returns`.`add_charges`
`sales_returns`.`sgst_amount`
`sales_returns`.`cgst_amount`
`sales_returns`.`igst_amount`
`sales_returns`.`cess_amount`
`sales_returns`.`payment_status`
`sales_returns`.`return_status`
`sales_returns`.`narration`
`sales_returns`.`receiver_name`
`sales_returns`.`receiver_contact_number`
`sales_returns`.`branch_id`
`sales_returns`.`finance_year_id`
`sales_returns`.`delete_status`
`sales_returns`.`created_at`
`sales_returns`.`user_id`
`sales_returns`.`updated_at`
`sales_returns`.`round_off`
`sales_returns`.`total_amount`
`sales_returns`.`posting_status`
`sales_settings`.*
`sales_settings`.`id`
`sales_settings`.`branch_id`
`sales_settings`.`price_base`
`sales_settings`.`discount_base`
`sales_settings`.`additional_discount_enabled`
`sales_settings`.`enable_scheme_discount`
`sales_settings`.`allow_negative_stock`
`sales_settings`.`default_payment_mode`
`sales_settings`.`default_terms_days`
`sales_settings`.`round_off_method`
`sales_settings`.`invoice_prefix`
`sales_settings`.`invoice_start_number`
`sales_settings`.`delete_status`
`sales_settings`.`created_at`
`sales_settings`.`updated_at`
`sales_targets`.*
`sales_targets`.`id`
`sales_targets`.`finance_year_id`
`sales_targets`.`branch_id`
`sales_targets`.`target_amount`
`sample_table`.*
`sample_table`.`id`
`sample_table`.`delete_status`
`sample_table`.`created_at`
`sample_table`.`updated_at`
`setting_allowed_ips`.*
`setting_allowed_ips`.`id`
`setting_allowed_ips`.`ip_address`
`setting_allowed_ips`.`description`
`setting_allowed_ips`.`is_active`
`setting_allowed_ips`.`created_at`
`setting_branch_details`.*
`setting_branch_details`.`id`
`setting_branch_details`.`branch_name`
`setting_branch_details`.`branch_code`
`setting_branch_details`.`address`
`setting_branch_details`.`city`
`setting_branch_details`.`pincode`
`setting_branch_details`.`state_id`
`setting_branch_details`.`country_id`
`setting_branch_details`.`contact_number`
`setting_branch_details`.`email`
`setting_branch_details`.`gstin`
`setting_branch_details`.`website`
`setting_branch_details`.`logo`
`setting_branch_details`.`dark_logo`
`setting_branch_details`.`light_logo`
`setting_branch_details`.`is_main_branch`
`setting_branch_details`.`delete_status`
`setting_branch_details`.`created_at`
`setting_branch_details`.`updated_at`
`setting_countries`.*
`setting_countries`.`id`
`setting_countries`.`country_name`
`setting_countries`.`short_name`
`setting_countries`.`is_default`
`setting_countries`.`delete_status`
`setting_countries`.`created_at`
`setting_countries`.`updated_at`
`setting_main_menu`.*
`setting_main_menu`.`id`
`setting_main_menu`.`main_menu`
`setting_main_menu`.`display_name`
`setting_main_menu`.`url`
`setting_main_menu`.`icon`
`setting_main_menu`.`sequence`
`setting_main_menu`.`is_voucher_entry`
`setting_main_menu`.`is_report`
`setting_main_menu`.`delete_status`
`setting_main_menu`.`created_at`
`setting_main_menu`.`updated_at`
`setting_states`.*
`setting_states`.`id`
`setting_states`.`state_name`
`setting_states`.`short_name`
`setting_states`.`delete_status`
`setting_states`.`is_default`
`setting_states`.`created_at`
`setting_states`.`updated_at`
`setting_sub_menu`.*
`setting_sub_menu`.`id`
`setting_sub_menu`.`sub_menu`
`setting_sub_menu`.`display_name`
`setting_sub_menu`.`mmenu_id`
`setting_sub_menu`.`is_master`
`setting_sub_menu`.`is_list`
`setting_sub_menu`.`is_voucher_entry`
`setting_sub_menu`.`is_report`
`setting_sub_menu`.`url`
`setting_sub_menu`.`sequence`
`setting_sub_menu`.`search_sequence`
`setting_sub_menu`.`delete_status`
`setting_sub_menu`.`created_at`
`setting_sub_menu`.`updated_at`
`subsidy_scheme_documents`.*
`subsidy_scheme_documents`.`id`
`subsidy_scheme_documents`.`scheme_id`
`subsidy_scheme_documents`.`doc_code`
`subsidy_scheme_documents`.`doc_name`
`subsidy_scheme_documents`.`is_mandatory`
`subsidy_scheme_documents`.`sequence_no`
`subsidy_scheme_documents`.`notes`
`subsidy_scheme_documents`.`branch_id`
`subsidy_scheme_documents`.`delete_status`
`subsidy_scheme_documents`.`created_at`
`subsidy_scheme_documents`.`updated_at`
`subsidy_schemes`.*
`subsidy_schemes`.`id`
`subsidy_schemes`.`scheme_name`
`subsidy_schemes`.`scheme_code`
`subsidy_schemes`.`description`
`subsidy_schemes`.`subsidy_type`
`subsidy_schemes`.`subsidy_rate`
`subsidy_schemes`.`subsidy_flat_amount`
`subsidy_schemes`.`cap_amount`
`subsidy_schemes`.`active_status`
`tally_posted_rows`.*
`tally_posted_rows`.`raw_row_id`
`tally_posted_rows`.`import_batch_id`
`tally_posted_rows`.`voucher_table`
`tally_posted_rows`.`voucher_id`
`tally_posted_rows`.`voucher_no`
`tally_posted_rows`.`created_at`
`tally_posting_issues`.*
`tally_posting_issues`.`id`
`tally_posting_issues`.`import_batch_id`
`tally_posting_issues`.`raw_row_id`
`tally_posting_issues`.`issue_code`
`tally_posting_issues`.`details`
`tally_posting_issues`.`created_at`
`tally_source_batches`.*
`tally_source_batches`.`import_batch_id`
`tally_source_batches`.`sheet_name`
`tally_source_batches`.`header_row_no`
`tally_source_batches`.`h1`
`tally_source_batches`.`h2`
`tally_source_batches`.`h3`
`tally_source_batches`.`h4`
`tally_source_batches`.`h5`
`tally_source_batches`.`h6`
`tally_source_batches`.`h7`
`tally_source_batches`.`h8`
`tally_source_batches`.`h9`
`tally_source_batches`.`h10`
`tally_source_batches`.`created_at`
`tally_source_raw10`.*
`tally_source_raw10`.`id`
`tally_source_raw10`.`import_batch_id`
`tally_source_raw10`.`sheet_name`
`tally_source_raw10`.`row_in_sheet`
`tally_source_raw10`.`c1`
`tally_source_raw10`.`c2`
`tally_source_raw10`.`c3`
`tally_source_raw10`.`c4`
`tally_source_raw10`.`c5`
`tally_source_raw10`.`c6`
`tally_source_raw10`.`c7`
`tally_source_raw10`.`c8`
`tally_source_raw10`.`c9`
`tally_source_raw10`.`c10`
`tally_source_raw10`.`created_at`
`tally_source_typed`.*
`tally_source_typed`.`id`
`tally_source_typed`.`import_batch_id`
`tally_source_typed`.`raw_row_id`
`tally_source_typed`.`txn_date`
`tally_source_typed`.`particulars`
`tally_source_typed`.`instrument_text`
`tally_source_typed`.`vch_type`
`tally_source_typed`.`voucher_type_id`
`tally_source_typed`.`vch_no`
`tally_source_typed`.`debit_amount`
`tally_source_typed`.`credit_amount`
`tally_source_typed`.`ledger_id`
`tally_source_typed`.`correspondent_ledger_id`
`tally_source_typed`.`is_ledger`
`tally_source_typed`.`is_main_ledger`
`tally_source_typed`.`is_main`
`tally_source_typed`.`is_correspondent`
`tally_source_typed`.`is_others`
`tally_source_typed`.`txn_date_forwardfill`
`tally_source_typed`.`vch_type_forwardfill`
`tally_source_typed`.`vch_no_forwardfill`
`tally_source_typed`.`main_ledger_name_ff`
`tally_source_typed`.`main_ledger_id_ff`
`tally_source_typed`.`is_pair_head`
`tally_source_typed`.`is_item`
`tally_source_typed`.`item_id`
`tally_source_typed`.`item_qty`
`tally_source_typed`.`rate_per_item`
`tally_source_typed`.`item_uom`
`tally_source_typed`.`item_name_key`
`tally_source_typed`.`ledger_type`
`tally_source_typed`.`created_at`
`tally_transactions`.*
`tally_transactions`.`id`
`tally_transactions`.`ledger_id`
`tally_transactions`.`voucher_type`
`tally_transactions`.`voucher_number`
`tally_transactions`.`voucher_date`
`tally_transactions`.`delete_status`
`tally_transactions`.`type`
`tally_transactions`.`amount`
`tally_transactions`.`narration`
`tally_transactions`.`branch_id`
`tally_transactions`.`created_at`
`tally_transactions`.`updated_at`
`tds_cumulative`.*
`tds_cumulative`.`id`
`tds_cumulative`.`vendor_id`
`tds_cumulative`.`ledger_id`
`tds_cumulative`.`section_code`
`tds_cumulative`.`finance_year_id`
`tds_cumulative`.`cumulative_amount`
`tds_cumulative`.`created_at`
`tds_cumulative`.`updated_at`
`tds_deductions`.*
`tds_deductions`.`id`
`tds_deductions`.`voucher_id`
`tds_deductions`.`voucher_type`
`tds_deductions`.`ledger_id`
`tds_deductions`.`vendor_id`
`tds_deductions`.`section_code`
`tds_deductions`.`amount`
`tds_deductions`.`narration`
`tds_deductions`.`finance_year_id`
`tds_deductions`.`branch_id`
`tds_deductions`.`voucher_date`
`tds_deductions`.`created_at`
`tds_deductions`.`delete_status`
`tds_deductions`.`deleted_by`
`tds_deductions`.`deleted_at`
`tds_master`.*
`tds_master`.`id`
`tds_master`.`section_code`
`tds_master`.`description`
`tds_master`.`applicable_on`
`tds_master`.`rate_percent`
`tds_master`.`threshold_per_txn`
`tds_master`.`threshold_annual`
`tds_master`.`resident_only`
`tds_master`.`is_active`
`tds_master`.`created_at`
`tds_master`.`updated_at`
`transaction_additional_charges`.*
`transaction_additional_charges`.`id`
`transaction_additional_charges`.`voucher_type_id`
`transaction_additional_charges`.`transaction_id`
`transaction_additional_charges`.`ledger_id`
`transaction_additional_charges`.`amount`
`transaction_additional_charges`.`tax_percentage`
`transaction_additional_charges`.`is_proportionate`
`transaction_additional_charges`.`branch_id`
`transaction_additional_charges`.`delete_status`
`transaction_additional_charges`.`created_at`
`transaction_additional_charges`.`updated_at`
`transaction_expenditure_categories`.*
`transaction_expenditure_categories`.`id`
`transaction_expenditure_categories`.`title`
`transaction_expenditure_categories`.`description`
`transaction_expenditure_categories`.`account_group_id`
`transaction_expenditure_categories`.`active_status`
`transaction_expenditure_categories`.`delete_status`
`transaction_expenditure_categories`.`created_at`
`transaction_expenditure_categories`.`updated_at`
`transaction_expenditure_vouchers`.*
`transaction_expenditure_vouchers`.`id`
`transaction_expenditure_vouchers`.`voucher_no`
`transaction_expenditure_vouchers`.`voucher_date`
`transaction_expenditure_vouchers`.`ledger_id`
`transaction_expenditure_vouchers`.`ledger_account_id`
`transaction_expenditure_vouchers`.`amount`
`transaction_expenditure_vouchers`.`gst_amount`
`transaction_expenditure_vouchers`.`is_gst_applicable`
`transaction_expenditure_vouchers`.`expenditure_category_id`
`transaction_expenditure_vouchers`.`branch_id`
`transaction_expenditure_vouchers`.`instrument_type`
`transaction_expenditure_vouchers`.`instrument_number`
`transaction_expenditure_vouchers`.`narration`
`transaction_expenditure_vouchers`.`delete_status`
`transaction_expenditure_vouchers`.`created_at`
`transaction_expenditure_vouchers`.`updated_at`
`transaction_expenditure_vouchers`.`expense_date`
`transaction_expenditure_vouchers`.`expense_type`
`transaction_payment_vouchers_expense`.*
`transaction_payment_vouchers_expense`.`id`
`transaction_payment_vouchers_expense`.`voucher_type_id`
`transaction_payment_vouchers_expense`.`voucher_no`
`transaction_payment_vouchers_expense`.`voucher_date`
`transaction_payment_vouchers_expense`.`ledger_id`
`transaction_payment_vouchers_expense`.`ledger_account_id`
`transaction_payment_vouchers_expense`.`instrument_type`
`transaction_payment_vouchers_expense`.`instrument_number`
`transaction_payment_vouchers_expense`.`amount`
`transaction_payment_vouchers_expense`.`expense_head`
`transaction_payment_vouchers_expense`.`gst`
`transaction_payment_vouchers_expense`.`branch_id`
`transaction_payment_vouchers_expense`.`user_id`
`transaction_payment_vouchers_expense`.`narration`
`transaction_payment_vouchers_expense`.`delete_status`
`transaction_payment_vouchers_expense`.`created_at`
`transaction_payment_vouchers_expense`.`updated_at`
`transaction_payment_vouchers_expense`.`payment_date`
`transaction_payment_vouchers_expense`.`created_by`
`transaction_payment_vouchers_expense`.`modified_by`
`transaction_payment_vouchers_expense`.`finance_year_id`
`transaction_payment_vouchers_expense`.`bank_name`
`transaction_payment_vouchers_expense`.`reference_id`
`transaction_payment_vouchers_expense`.`reference`
`transaction_receipt_vouchers_old`.*
`transaction_receipt_vouchers_old`.`id`
`transaction_receipt_vouchers_old`.`voucher_no`
`transaction_receipt_vouchers_old`.`voucher_date`
`transaction_receipt_vouchers_old`.`ledger_id`
`transaction_receipt_vouchers_old`.`ledger_account_id`
`transaction_receipt_vouchers_old`.`instrument_type`
`transaction_receipt_vouchers_old`.`instrument_number`
`transaction_receipt_vouchers_old`.`amount`
`transaction_receipt_vouchers_old`.`tds_amount`
`transaction_receipt_vouchers_old`.`branch_id`
`transaction_receipt_vouchers_old`.`narration`
`transaction_receipt_vouchers_old`.`delete_status`
`transaction_receipt_vouchers_old`.`created_at`
`transaction_receipt_vouchers_old`.`updated_at`
`transaction_receipt_vouchers_old`.`received_date`
`transaction_receipt_vouchers_old`.`user_id`
`transaction_receipt_vouchers_old`.`finance_year_id`
`transaction_receipt_vouchers_old`.`bank_name`
`transaction_receipt_vouchers_old`.`reference_id`
`universal_discount_rules`.*
`universal_discount_rules`.`id`
`universal_discount_rules`.`rule_name`
`universal_discount_rules`.`rule_scope`
`universal_discount_rules`.`operator`
`universal_discount_rules`.`value`
`universal_discount_rules`.`target_id`
`universal_discount_rules`.`customer_segment_id`
`universal_discount_rules`.`coupon_code`
`universal_discount_rules`.`min_qty`
`universal_discount_rules`.`min_amount`
`universal_discount_rules`.`valid_from`
`universal_discount_rules`.`valid_to`
`universal_discount_rules`.`priority`
`universal_discount_rules`.`combine_method`
`universal_discount_rules`.`is_active`
`universal_discount_rules`.`branch_id`
`universal_discount_rules`.`delete_status`
`universal_discount_rules`.`created_at`
`universal_discount_rules`.`updated_at`
`user_branches`.*
`user_branches`.`id`
`user_branches`.`user_id`
`user_branches`.`branch_id`
`user_branches`.`is_active`
`user_branches`.`is_default`
`user_branches`.`delete_status`
`user_branches`.`created_at`
`user_branches`.`updated_at`
`user_details`.*
`user_details`.`id`
`user_details`.`user_email`
`user_details`.`username`
`user_details`.`password_hash`
`user_details`.`role_id`
`user_details`.`emp_id`
`user_details`.`default_branch_id`
`user_details`.`financial_year_id`
`user_details`.`delete_status`
`user_details`.`created_at`
`user_details`.`updated_at`
`user_favorites`.*
`user_favorites`.`id`
`user_favorites`.`user_id`
`user_favorites`.`submenu_id`
`user_favorites`.`is_voucher_entry`
`user_favorites`.`sort_order`
`user_favorites`.`created_at`
`user_favorites`.`updated_at`
`user_financial_years`.*
`user_financial_years`.`id`
`user_financial_years`.`user_id`
`user_financial_years`.`financial_year_id`
`user_financial_years`.`is_active`
`user_financial_years`.`delete_status`
`user_financial_years`.`created_at`
`user_financial_years`.`updated_at`
`user_permissions`.*
`user_permissions`.`id`
`user_permissions`.`role_id`
`user_permissions`.`menu_id`
`user_permissions`.`submenu_id`
`user_permissions`.`can_add`
`user_permissions`.`can_edit`
`user_permissions`.`can_delete`
`user_permissions`.`can_view`
`user_permissions`.`branch_id`
`user_permissions`.`delete_status`
`user_permissions`.`created_at`
`user_permissions`.`updated_at`
`user_roles`.*
`user_roles`.`id`
`user_roles`.`role_name`
`user_roles`.`dashboard_link`
`user_roles`.`dashboard_link_lock_screen`
`user_roles`.`is_super_admin`
`user_roles`.`branch_id`
`user_roles`.`delete_status`
`user_roles`.`created_at`
`user_roles`.`updated_at`
`users`.*
`users`.`id`
`users`.`user_code`
`users`.`name`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`mobile`
`users`.`role_id`
`users`.`branch_id`
`users`.`status`
`users`.`last_login`
`users`.`created_by`
`users`.`created_at`
`users`.`updated_at`
`users`.`delete_status`
`voucher_additional_charges`.*
`voucher_additional_charges`.`id`
`voucher_additional_charges`.`voucher_type_id`
`voucher_additional_charges`.`ledger_id`
`voucher_additional_charges`.`tax_proportionate_flag`
`voucher_additional_charges`.`tax_percentage_override`
`voucher_additional_charges`.`hsn_sac_code`
`voucher_additional_charges`.`remarks`
`voucher_additional_charges`.`branch_id`
`voucher_additional_charges`.`created_at`
`voucher_additional_charges`.`updated_at`
`voucher_numbering_config`.*
`voucher_numbering_config`.`id`
`voucher_numbering_config`.`voucher_type_id`
`voucher_numbering_config`.`financial_year_id`
`voucher_numbering_config`.`branch_id`
`voucher_numbering_config`.`starting_number`
`voucher_numbering_config`.`number_width`
`voucher_numbering_config`.`prefix_zero`
`voucher_numbering_config`.`restart_periodicity`
`voucher_numbering_config`.`restart_applicable_from`
`voucher_numbering_config`.`restart_number`
`voucher_numbering_config`.`prefix_applicable_from`
`voucher_numbering_config`.`prefix_text`
`voucher_numbering_config`.`suffix_applicable_from`
`voucher_numbering_config`.`suffix_text`
`voucher_numbering_config`.`created_at`
`voucher_numbering_config`.`updated_at`
`voucher_series_master`.*
`voucher_series_master`.`id`
`voucher_series_master`.`voucher_code`
`voucher_series_master`.`branch_id`
`voucher_series_master`.`financial_year_id`
`voucher_series_master`.`prefix`
`voucher_series_master`.`suffix`
`voucher_series_master`.`current_number`
`voucher_series_master_old`.*
`voucher_series_master_old`.`id`
`voucher_series_master_old`.`voucher_type`
`voucher_series_master_old`.`branch_id`
`voucher_series_master_old`.`financial_year_id`
`voucher_series_master_old`.`prefix`
`voucher_series_master_old`.`suffix`
`voucher_series_master_old`.`current_number`
`voucher_taxes`.*
`voucher_taxes`.`id`
`voucher_taxes`.`voucher_type`
`voucher_taxes`.`voucher_id`
`voucher_taxes`.`tax_code`
`voucher_taxes`.`tax_name`
`voucher_taxes`.`tax_rate`
`voucher_taxes`.`tax_amount`
`voucher_taxes`.`ledger_id`
`voucher_taxes`.`branch_id`
`voucher_taxes`.`created_at`
`voucher_taxes`.`updated_at`
`voucher_taxes`.`taxable_value`
`voucher_taxes`.`charge_type`
`voucher_taxes`.`additional_charge_id`
`voucher_type_ledger_mappings`.*
`voucher_type_ledger_mappings`.`id`
`voucher_type_ledger_mappings`.`voucher_type_id`
`voucher_type_ledger_mappings`.`voucher_type`
`voucher_type_ledger_mappings`.`ledger_id`
`voucher_type_ledger_mappings`.`ledger_key_id`
`voucher_type_ledger_mappings`.`is_tds_applicable`
`voucher_type_ledger_mappings`.`narration_template`
`voucher_type_ledger_mappings`.`remarks`
`voucher_type_ledger_mappings`.`voucher_flow_type`
`voucher_type_ledger_mappings`.`sort_order`
`voucher_type_ledger_mappings`.`entry_side`
`voucher_type_ledger_mappings`.`is_default`
`voucher_type_ledger_mappings`.`delete_status`
`voucher_type_ledger_mappings`.`created_at`
`voucher_type_ledger_mappings`.`updated_at`
`voucher_types`.*
`voucher_types`.`id`
`voucher_types`.`voucher_code`
`voucher_types`.`title`
`voucher_types`.`abbreviation`
`voucher_types`.`primary_voucher`
`voucher_types`.`numbering_method`
`voucher_types`.`retain_original_number`
`voucher_types`.`is_optional`
`voucher_types`.`is_primary_voucher`
`voucher_types`.`is_posting`
`voucher_types`.`is_default`
`voucher_types`.`update_item_transaction`
`voucher_types`.`allow_narration`
`voucher_types`.`track_additional_costs`
`voucher_types`.`auto_print_on_save`
`voucher_types`.`auto_whatsapp_on_save`
`voucher_types`.`entry_side`
`voucher_types`.`is_active`
`voucher_types`.`sort_order`
`voucher_types`.`primary_voucher_type_id`
`voucher_types`.`created_at`
`voucher_types`.`updated_at`
`voucher_types_old`.*
`voucher_types_old`.`id`
`voucher_types_old`.`code`
`voucher_types_old`.`title`
`voucher_types_old`.`abbreviation`
`voucher_types_old`.`voucher_mode`
`voucher_types_old`.`numbering_method`
`voucher_types_old`.`retain_original_number`
`voucher_types_old`.`is_optional`
`voucher_types_old`.`allow_narration`
`voucher_types_old`.`track_additional_costs`
`voucher_types_old`.`auto_print_on_save`
`voucher_types_old`.`auto_whatsapp_on_save`
`voucher_types_old`.`nature`
`voucher_types_old`.`is_custom`
`voucher_types_old`.`is_active`
`voucher_types_old`.`sort_order`
`voucher_types_old`.`primary_voucher_type_id`
`voucher_types_old`.`created_at`
`voucher_types_old`.`updated_at`
`whatsapp_settings`.*
`whatsapp_settings`.`id`
`whatsapp_settings`.`provider`
`whatsapp_settings`.`api_url`
`whatsapp_settings`.`api_key`
`whatsapp_settings`.`auth_token`
`whatsapp_settings`.`sender_number`
`whatsapp_settings`.`is_active`
`whatsapp_settings`.`branch_id`
`whatsapp_settings`.`created_at`
`whatsapp_settings`.`updated_at`
`yearly_financial_summary`.*
`yearly_financial_summary`.`summary_year`
`yearly_financial_summary`.`branch_id`
`yearly_financial_summary`.`total_sales`
`yearly_financial_summary`.`total_purchases`
`yearly_financial_summary`.`total_receipts`
`yearly_financial_summary`.`total_payments`
`yearly_financial_summary`.`credit_note`
`yearly_financial_summary`.`debit_note`
`yearly_financial_summary`.`finance_year_id`
`alert_logs`.*
`alert_logs`.`id`
`alert_logs`.`alert_type`
`alert_logs`.`alert_message`
`alert_logs`.`triggered_on`
`alert_logs`.`item_id`
`alert_logs`.`ledger_id`
`alert_logs`.`invoice_id`
`alert_logs`.`lead_id`
`alert_logs`.`branch_id`
`alert_logs`.`user_id`
`alert_logs`.`alert_level`
`alert_logs`.`is_read`
`alert_logs`.`resolved`
`alert_logs`.`created_at`
`alert_logs`.`updated_at`
`api_student`.*
`api_student`.`id`
`api_student`.`name`
`api_student`.`age`
`api_student`.`grade`
`assign_item_to_subsidy_scheme`.*
`assign_item_to_subsidy_scheme`.`id`
`assign_item_to_subsidy_scheme`.`subsidy_scheme_id`
`assign_item_to_subsidy_scheme`.`item_id`
`assign_item_to_subsidy_scheme`.`delete_status`
`assign_item_to_subsidy_scheme`.`created_at`
`assign_item_to_subsidy_scheme`.`created_by`
`assign_item_to_subsidy_scheme`.`modified_at`
`assign_item_to_subsidy_scheme`.`modified_by`
`audit_logs`.*
`audit_logs`.`id`
`audit_logs`.`entity_type`
`audit_logs`.`entity_id`
`audit_logs`.`version`
`audit_logs`.`event_type`
`audit_logs`.`reason`
`audit_logs`.`branch_id`
`audit_logs`.`finance_year_id`
`audit_logs`.`changed_by`
`audit_logs`.`changed_at`
`audit_logs`.`changed_ip`
`audit_logs`.`snapshot`
`audit_logs`.`diff`
`audit_logs`.`aux`
`audit_logs`.`hash`
`audit_logs`.`prev_hash`
`audit_logs`.`invoice_no`
`audit_logs`.`voucher_no`
`audit_logs`.`voucher_date`
`auth_group`.*
`auth_group`.`id`
`auth_group`.`name`
`auth_group_permissions`.*
`auth_group_permissions`.`id`
`auth_group_permissions`.`group_id`
`auth_group_permissions`.`permission_id`
`auth_permission`.*
`auth_permission`.`id`
`auth_permission`.`name`
`auth_permission`.`content_type_id`
`auth_permission`.`codename`
`auth_user`.*
`auth_user`.`id`
`auth_user`.`password`
`auth_user`.`last_login`
`auth_user`.`is_superuser`
`auth_user`.`username`
`auth_user`.`first_name`
`auth_user`.`last_name`
`auth_user`.`email`
`auth_user`.`is_staff`
`auth_user`.`is_active`
`auth_user`.`date_joined`
`auth_user_groups`.*
`auth_user_groups`.`id`
`auth_user_groups`.`user_id`
`auth_user_groups`.`group_id`
`auth_user_user_permissions`.*
`auth_user_user_permissions`.`id`
`auth_user_user_permissions`.`user_id`
`auth_user_user_permissions`.`permission_id`
`bank_master`.*
`bank_master`.`id`
`bank_master`.`bank_code`
`bank_master`.`bank_name`
`bank_master`.`short_name`
`bank_master`.`swift_code`
`bank_master`.`logo_url`
`bank_master`.`is_active`
`bank_master`.`created_at`
`bank_master`.`updated_at`
`call_followup_master`.*
`call_followup_master`.`id`
`call_followup_master`.`customer_id`
`call_followup_master`.`customer_name`
`call_followup_master`.`mobile_number`
`call_followup_master`.`call_type`
`call_followup_master`.`due_amount`
`call_followup_master`.`assigned_agent`
`call_followup_master`.`scheduled_date`
`call_followup_master`.`call_status`
`call_followup_master`.`remarks`
`call_followup_master`.`next_followup_date`
`call_followup_master`.`miss_count`
`call_followup_master`.`created_at`
`call_followup_master`.`updated_at`
`cnc_job_parts`.*
`cnc_job_parts`.`id`
`cnc_job_parts`.`job_id`
`cnc_job_parts`.`part_name`
`cnc_job_parts`.`qty`
`cnc_job_parts`.`operation_remark`
`cnc_job_parts`.`delete_status`
`cnc_job_parts`.`created_at`
`cnc_job_parts`.`updated_at`
`cnc_jobs`.*
`cnc_jobs`.`id`
`cnc_jobs`.`branch_id`
`cnc_jobs`.`job_date`
`cnc_jobs`.`shift`
`cnc_jobs`.`operator_code`
`cnc_jobs`.`operator_name`
`cnc_jobs`.`machine_name`
`cnc_jobs`.`job_no`
`cnc_jobs`.`notes`
`cnc_jobs`.`delete_status`
`cnc_jobs`.`created_by`
`cnc_jobs`.`created_at`
`cnc_jobs`.`updated_at`
`contra_vouchers`.*
`contra_vouchers`.`id`
`contra_vouchers`.`voucher_no`
`contra_vouchers`.`voucher_type_id`
`contra_vouchers`.`voucher_date`
`contra_vouchers`.`contra_type`
`contra_vouchers`.`from_account_id`
`contra_vouchers`.`to_account_id`
`contra_vouchers`.`instrument_type`
`contra_vouchers`.`bank_name`
`contra_vouchers`.`instrument_number`
`contra_vouchers`.`amount`
`contra_vouchers`.`narration`
`contra_vouchers`.`branch_id`
`contra_vouchers`.`finance_year_id`
`contra_vouchers`.`created_by`
`contra_vouchers`.`updated_by`
`contra_vouchers`.`delete_status`
`contra_vouchers`.`created_at`
`contra_vouchers`.`updated_at`
`coupon_limits`.*
`coupon_limits`.`coupon_code`
`coupon_limits`.`max_global_uses`
`coupon_limits`.`max_uses_per_customer`
`coupon_limits`.`is_scratch`
`coupon_limits`.`valid_from`
`coupon_limits`.`valid_to`
`coupon_redemptions`.*
`coupon_redemptions`.`id`
`coupon_redemptions`.`coupon_code`
`coupon_redemptions`.`customer_id`
`coupon_redemptions`.`rule_id`
`coupon_redemptions`.`order_ref`
`coupon_redemptions`.`qty`
`coupon_redemptions`.`amount`
`coupon_redemptions`.`branch_id`
`coupon_redemptions`.`redeemed_at`
`crm_brochure_queue`.*
`crm_brochure_queue`.`id`
`crm_brochure_queue`.`enquiry_id`
`crm_brochure_queue`.`medium`
`crm_brochure_queue`.`template_id`
`crm_brochure_queue`.`status`
`crm_brochure_queue`.`scheduled_at`
`crm_brochure_queue`.`sent_at`
`crm_brochure_queue`.`created_by`
`crm_brochure_queue`.`created_at`
`crm_brochure_queue`.`updated_at`
`crm_brochure_queue`.`delete_status`
`crm_enquiry_links`.*
`crm_enquiry_links`.`id`
`crm_enquiry_links`.`enquiry_id`
`crm_enquiry_links`.`link_type`
`crm_enquiry_links`.`target_id`
`crm_enquiry_links`.`created_by`
`crm_enquiry_links`.`created_at`
`crm_leads`.*
`crm_leads`.`id`
`crm_leads`.`lead_type`
`crm_leads`.`customer_company`
`crm_leads`.`contact_person`
`crm_leads`.`phone`
`crm_leads`.`whatsapp`
`crm_leads`.`address`
`crm_leads`.`city`
`crm_leads`.`pincode`
`crm_leads`.`source`
`crm_leads`.`stage`
`crm_leads`.`next_followup`
`crm_leads`.`customer_role`
`crm_leads`.`next_steps`
`crm_leads`.`description`
`crm_leads`.`next_action`
`crm_leads`.`routed_at`
`crm_leads`.`auto_routed`
`crm_leads`.`auto_route_json`
`crm_leads`.`auto_route_conf`
`crm_leads`.`handled_by`
`crm_leads`.`branch_id`
`crm_leads`.`status`
`crm_leads`.`created_by`
`crm_leads`.`created_at`
`crm_leads`.`updated_at`
`crm_leads`.`delete_status`
`crm_quotations`.*
`crm_quotations`.`id`
`crm_quotations`.`enquiry_id`
`crm_quotations`.`customer_company`
`crm_quotations`.`contact_phone`
`crm_quotations`.`city`
`crm_quotations`.`stage`
`crm_quotations`.`remarks`
`crm_quotations`.`created_by`
`crm_quotations`.`created_at`
`crm_quotations`.`updated_at`
`crm_quotations`.`delete_status`
`crm_service_details`.*
`crm_service_details`.`id`
`crm_service_details`.`lead_id`
`crm_service_details`.`service_type`
`crm_service_details`.`machine_model`
`crm_service_details`.`serial_no`
`crm_service_details`.`preferred_visit_date`
`crm_service_details`.`technician_id`
`crm_service_details`.`priority`
`crm_service_details`.`warranty`
`crm_service_details`.`notes`
`crm_service_details`.`created_at`
`crm_service_details`.`updated_at`
`crm_tasks`.*
`crm_tasks`.`id`
`crm_tasks`.`entity_type`
`crm_tasks`.`entity_id`
`crm_tasks`.`task_type`
`crm_tasks`.`title`
`crm_tasks`.`due_at`
`crm_tasks`.`assigned_to`
`crm_tasks`.`status`
`crm_tasks`.`notes`
`crm_tasks`.`branch_id`
`crm_tasks`.`created_by`
`crm_tasks`.`created_at`
`crm_tasks`.`updated_at`
`crm_tasks`.`delete_status`
`crm_visits`.*
`crm_visits`.`id`
`crm_visits`.`enquiry_id`
`crm_visits`.`scheduled_at`
`crm_visits`.`address`
`crm_visits`.`city`
`crm_visits`.`pincode`
`crm_visits`.`assigned_to`
`crm_visits`.`status`
`crm_visits`.`notes`
`crm_visits`.`created_by`
`crm_visits`.`created_at`
`crm_visits`.`updated_at`
`crm_visits`.`delete_status`
`customer_segment`.*
`customer_segment`.`id`
`customer_segment`.`title`
`customer_segment`.`description`
`customer_segment`.`active_status`
`customer_segment`.`branch_id`
`customer_segment`.`created_by`
`customer_segment`.`modified_by`
`customer_segment`.`created_at`
`customer_segment`.`updated_at`
`customer_segment`.`delete_status`
`daily_financial_summary`.*
`daily_financial_summary`.`summary_date`
`daily_financial_summary`.`branch_id`
`daily_financial_summary`.`total_sales`
`daily_financial_summary`.`total_purchases`
`daily_financial_summary`.`total_receipts`
`daily_financial_summary`.`total_payments`
`daily_ledger_balance`.*
`daily_ledger_balance`.`summary_date`
`daily_ledger_balance`.`ledger_id`
`daily_ledger_balance`.`branch_id`
`daily_ledger_balance`.`dr_amount`
`daily_ledger_balance`.`cr_amount`
`dashboard_monthly_summary`.*
`dashboard_monthly_summary`.`summary_year`
`dashboard_monthly_summary`.`summary_month`
`dashboard_monthly_summary`.`total_sales`
`dashboard_monthly_summary`.`total_purchases`
`dashboard_monthly_summary`.`total_sales_return`
`dashboard_monthly_summary`.`total_purchase_return`
`dashboard_monthly_summary`.`total_revenue`
`dashboard_monthly_summary`.`total_expenditure`
`dashboard_monthly_summary`.`total_profit`
`dashboard_monthly_summary`.`created_at`
`dashboard_summary_snapshot`.*
`dashboard_summary_snapshot`.`id`
`dashboard_summary_snapshot`.`total_sales`
`dashboard_summary_snapshot`.`total_purchases`
`dashboard_summary_snapshot`.`total_sales_return`
`dashboard_summary_snapshot`.`total_purchase_return`
`dashboard_summary_snapshot`.`total_revenue`
`dashboard_summary_snapshot`.`total_expenditure`
`dashboard_summary_snapshot`.`total_profit`
`dashboard_summary_snapshot`.`top_customer`
`dashboard_summary_snapshot`.`top_item`
`dashboard_summary_snapshot`.`total_customers`
`dashboard_summary_snapshot`.`total_suppliers`
`dashboard_summary_snapshot`.`total_visits`
`dashboard_summary_snapshot`.`total_leads`
`dashboard_summary_snapshot`.`total_employees`
`dashboard_summary_snapshot`.`summary_date`
`dashboard_summary_snapshot`.`last_updated`
`dashboard_yearly_summary`.*
`dashboard_yearly_summary`.`summary_year`
`dashboard_yearly_summary`.`total_sales`
`dashboard_yearly_summary`.`total_purchases`
`dashboard_yearly_summary`.`total_sales_return`
`dashboard_yearly_summary`.`total_purchase_return`
`dashboard_yearly_summary`.`total_revenue`
`dashboard_yearly_summary`.`total_expenditure`
`dashboard_yearly_summary`.`total_profit`
`dashboard_yearly_summary`.`created_at`
`date_range_filters`.*
`date_range_filters`.`id`
`date_range_filters`.`filter_name`
`date_range_filters`.`query_value`
`date_range_filters`.`is_active`
`discount_rule_targets`.*
`discount_rule_targets`.`target_id`
`discount_rule_targets`.`discount_rule_id`
`discount_rule_targets`.`target_type`
`discount_rule_targets`.`target_ref_id`
`discount_rule_targets`.`customer_segment_id`
`discount_rule_targets`.`discount_value`
`discount_rule_targets`.`operator_override`
`discount_rule_targets`.`min_qty_override`
`discount_rule_targets`.`min_amount_override`
`discount_rule_targets`.`combine_override`
`discount_rule_targets`.`priority_override`
`discount_rule_targets`.`branch_id`
`discount_rule_targets`.`delete_status`
`discount_rule_targets`.`created_at`
`discount_rule_targets`.`updated_at`
`dispatch_details`.*
`dispatch_details`.`id`
`dispatch_details`.`sales_entry_id`
`dispatch_details`.`voucher_type_id`
`dispatch_details`.`delivery_note_no`
`dispatch_details`.`dispatch_doc_no`
`dispatch_details`.`dispatch_date`
`dispatch_details`.`dispatched_through`
`dispatch_details`.`destination`
`dispatch_details`.`carrier_ledger_id`
`dispatch_details`.`bill_of_lading`
`dispatch_details`.`lr_rr_date`
`dispatch_details`.`motor_vehicle_no`
`dispatch_details`.`buyer_order_no`
`dispatch_details`.`buyer_date`
`dispatch_details`.`branch_id`
`dispatch_details`.`created_by`
`dispatch_details`.`created_at`
`dispatch_details`.`updated_at`
`dispatch_details`.`delete_status`
`django_admin_log`.*
`django_admin_log`.`id`
`django_admin_log`.`action_time`
`django_admin_log`.`object_id`
`django_admin_log`.`object_repr`
`django_admin_log`.`action_flag`
`django_admin_log`.`change_message`
`django_admin_log`.`content_type_id`
`django_admin_log`.`user_id`
`django_content_type`.*
`django_content_type`.`id`
`django_content_type`.`app_label`
`django_content_type`.`model`
`django_migrations`.*
`django_migrations`.`id`
`django_migrations`.`app`
`django_migrations`.`name`
`django_migrations`.`applied`
`django_session`.*
`django_session`.`session_key`
`django_session`.`session_data`
`django_session`.`expire_date`
`dynamic_sales_price_competitor_prices`.*
`dynamic_sales_price_competitor_prices`.`competitor_price_id`
`dynamic_sales_price_competitor_prices`.`item_id`
`dynamic_sales_price_competitor_prices`.`competitor_name`
`dynamic_sales_price_competitor_prices`.`price`
`dynamic_sales_price_competitor_prices`.`branch_id`
`dynamic_sales_price_competitor_prices`.`last_checked`
`dynamic_sales_price_competitor_prices`.`is_active`
`dynamic_sales_price_competitor_prices`.`delete_status`
`dynamic_sales_price_competitor_prices`.`created_by`
`dynamic_sales_price_competitor_prices`.`updated_by`
`dynamic_sales_price_competitor_prices`.`created_at`
`dynamic_sales_price_competitor_prices`.`updated_at`
`dynamic_sales_price_competitor_rules`.*
`dynamic_sales_price_competitor_rules`.`id`
`dynamic_sales_price_competitor_rules`.`item_id`
`dynamic_sales_price_competitor_rules`.`strategy`
`dynamic_sales_price_competitor_rules`.`undercut_value`
`dynamic_sales_price_competitor_rules`.`branch_id`
`dynamic_sales_price_competitor_rules`.`is_active`
`dynamic_sales_price_competitor_rules`.`delete_status`
`dynamic_sales_price_competitor_rules`.`created_by`
`dynamic_sales_price_competitor_rules`.`updated_by`
`dynamic_sales_price_competitor_rules`.`created_at`
`dynamic_sales_price_competitor_rules`.`updated_at`
`dynamic_sales_price_configs`.*
`dynamic_sales_price_configs`.`id`
`dynamic_sales_price_configs`.`branch_id`
`dynamic_sales_price_configs`.`item_id`
`dynamic_sales_price_configs`.`brand_id`
`dynamic_sales_price_configs`.`category_id`
`dynamic_sales_price_configs`.`pricing_strategy`
`dynamic_sales_price_configs`.`costing_method`
`dynamic_sales_price_configs`.`min_margin_percent`
`dynamic_sales_price_configs`.`allow_competitor_price`
`dynamic_sales_price_configs`.`competitor_alignment_mode`
`dynamic_sales_price_configs`.`competitor_floor_margin_pct`
`dynamic_sales_price_configs`.`stock_low_threshold`
`dynamic_sales_price_configs`.`stock_high_threshold`
`dynamic_sales_price_configs`.`stock_low_markup_pct`
`dynamic_sales_price_configs`.`stock_high_markdown_pct`
`dynamic_sales_price_configs`.`average_sales_lookback_days`
`dynamic_sales_price_configs`.`rounding_rule`
`dynamic_sales_price_configs`.`effective_from`
`dynamic_sales_price_configs`.`effective_to`
`dynamic_sales_price_configs`.`delete_status`
`dynamic_sales_price_configs`.`created_at`
`dynamic_sales_price_configs`.`updated_at`
`dynamic_sales_price_discounts`.*
`dynamic_sales_price_discounts`.`id`
`dynamic_sales_price_discounts`.`rule_name`
`dynamic_sales_price_discounts`.`rule_type`
`dynamic_sales_price_discounts`.`reference_id`
`dynamic_sales_price_discounts`.`discount_type`
`dynamic_sales_price_discounts`.`discount_value`
`dynamic_sales_price_discounts`.`valid_from`
`dynamic_sales_price_discounts`.`valid_to`
`dynamic_sales_price_discounts`.`branch_id`
`dynamic_sales_price_discounts`.`is_active`
`dynamic_sales_price_discounts`.`delete_status`
`dynamic_sales_price_discounts`.`created_by`
`dynamic_sales_price_discounts`.`updated_by`
`dynamic_sales_price_discounts`.`created_at`
`dynamic_sales_price_discounts`.`updated_at`
`dynamic_sales_price_margin_rules`.*
`dynamic_sales_price_margin_rules`.`id`
`dynamic_sales_price_margin_rules`.`rule_type`
`dynamic_sales_price_margin_rules`.`reference_id`
`dynamic_sales_price_margin_rules`.`margin_percent`
`dynamic_sales_price_margin_rules`.`branch_id`
`dynamic_sales_price_margin_rules`.`is_active`
`dynamic_sales_price_margin_rules`.`delete_status`
`dynamic_sales_price_margin_rules`.`created_by`
`dynamic_sales_price_margin_rules`.`updated_by`
`dynamic_sales_price_margin_rules`.`created_at`
`dynamic_sales_price_margin_rules`.`updated_at`
`email_smtp_settings`.*
`email_smtp_settings`.`id`
`email_smtp_settings`.`mail_driver`
`email_smtp_settings`.`mail_from_name`
`email_smtp_settings`.`mail_from_email`
`email_smtp_settings`.`enable_queue`
`email_smtp_settings`.`host`
`email_smtp_settings`.`port`
`email_smtp_settings`.`username`
`email_smtp_settings`.`password`
`email_smtp_settings`.`encryption`
`email_smtp_settings`.`is_active`
`email_smtp_settings`.`created_at`
`email_smtp_settings`.`updated_at`
`employees`.*
`employees`.`id`
`employees`.`employee_code`
`employees`.`full_name`
`employees`.`designation`
`employees`.`email`
`employees`.`mobile_number`
`employees`.`date_of_joining`
`employees`.`branch_id`
`employees`.`user_role_id`
`employees`.`is_sales_person`
`employees`.`reporting_manager_id`
`employees`.`login_user_id`
`employees`.`address`
`employees`.`city`
`employees`.`state_id`
`employees`.`country_id`
`employees`.`pincode`
`employees`.`is_active`
`employees`.`delete_status`
`employees`.`created_at`
`employees`.`updated_at`
`exchange_items`.*
`exchange_items`.`id`
`exchange_items`.`item_name`
`exchange_items`.`item_code`
`exchange_items`.`item_description`
`exchange_items`.`mrp`
`exchange_items`.`gst_percent`
`exchange_items`.`exchange_value`
`exchange_items`.`branch_id`
`exchange_items`.`delete_status`
`exchange_items`.`created_at`
`exchange_items`.`updated_at`
`expense_voucher`.*
`expense_voucher`.`id`
`expense_voucher`.`voucher_type_id`
`expense_voucher`.`voucher_no`
`expense_voucher`.`voucher_date`
`expense_voucher`.`ledger_id`
`expense_voucher`.`ledger_account_id`
`expense_voucher`.`expense_head`
`expense_voucher`.`gst_aplicability`
`expense_voucher`.`ref_bill_no`
`expense_voucher`.`instrument_type`
`expense_voucher`.`instrument_number`
`expense_voucher`.`amount`
`expense_voucher`.`branch_id`
`expense_voucher`.`user_id`
`expense_voucher`.`narration`
`expense_voucher`.`delete_status`
`expense_voucher`.`created_at`
`expense_voucher`.`updated_at`
`expense_voucher`.`payment_date`
`expense_voucher`.`created_by`
`expense_voucher`.`modified_by`
`expense_voucher`.`finance_year_id`
`expense_voucher`.`bank_name`
`expense_voucher`.`reference_id`
`expense_voucher_allocations`.*
`expense_voucher_allocations`.`id`
`expense_voucher_allocations`.`expense_id`
`expense_voucher_allocations`.`invoice_id`
`expense_voucher_allocations`.`allocated_amount`
`expense_voucher_allocations`.`remarks`
`expense_voucher_allocations`.`delete_status`
`expense_voucher_allocations`.`created_at`
`expense_voucher_allocations`.`updated_at`
`final_ledger_balance`.*
`final_ledger_balance`.`ledger_id`
`final_ledger_balance`.`branch_id`
`final_ledger_balance`.`finance_year_id`
`final_ledger_balance`.`opening_balance`
`final_ledger_balance`.`transaction_dr`
`final_ledger_balance`.`transaction_cr`
`final_ledger_balance`.`closing_balance`
`financial_years`.*
`financial_years`.`id`
`financial_years`.`branch_id`
`financial_years`.`year`
`financial_years`.`fiscal_year`
`financial_years`.`start_date`
`financial_years`.`end_date`
`financial_years`.`delete_status`
`financial_years`.`created_at`
`financial_years`.`updated_at`
`gst_registration_types`.*
`gst_registration_types`.`id`
`gst_registration_types`.`type_name`
`gst_registration_types`.`description`
`gst_registration_types`.`is_default`
`gst_registration_types`.`is_active`
`gst_registration_types`.`delete_status`
`gst_registration_types`.`created_at`
`gst_registration_types`.`updated_at`
`invoice_outstanding`.*
`invoice_outstanding`.`id`
`invoice_outstanding`.`voucher_type_id`
`invoice_outstanding`.`voucher_id`
`invoice_outstanding`.`voucher_number`
`invoice_outstanding`.`ledger_id`
`invoice_outstanding`.`invoice_date`
`invoice_outstanding`.`dr_amount`
`invoice_outstanding`.`cr_amount`
`invoice_outstanding`.`branch_id`
`invoice_outstanding`.`finance_year_id`
`invoice_outstanding`.`narration`
`invoice_outstanding`.`created_at`
`invoice_outstanding`.`updated_at`
`invoice_outstanding`.`delete_status`
`invoice_outstanding`.`due_date`
`item_effective_pricing`.*
`item_effective_pricing`.`branch_id`
`item_effective_pricing`.`item_id`
`item_effective_pricing`.`price_basis`
`item_effective_pricing`.`base_price`
`item_effective_pricing`.`unit_price`
`item_effective_pricing`.`applied_rules_json`
`item_effective_pricing`.`rules_hash`
`item_effective_pricing`.`valid_from`
`item_effective_pricing`.`valid_to`
`item_effective_pricing`.`updated_at`
`item_transactions`.*
`item_transactions`.`id`
`item_transactions`.`item_id`
`item_transactions`.`branch_id`
`item_transactions`.`finance_year_id`
`item_transactions`.`godown_id`
`item_transactions`.`voucher_type_id`
`item_transactions`.`in_out_type`
`item_transactions`.`quantity`
`item_transactions`.`rate`
`item_transactions`.`transaction_value`
`item_transactions`.`transaction_date`
`item_transactions`.`voucher_id`
`item_transactions`.`voucher_type`
`item_transactions`.`reference_table`
`item_transactions`.`reference_id`
`item_transactions`.`narration`
`item_transactions`.`created_at`
`item_transactions`.`delete_status`
`items`.*
`items`.`id`
`items`.`item_name`
`items`.`item_code`
`items`.`packing`
`items`.`hsn_sac_id`
`items`.`item_cat_id`
`items`.`godown_id`
`items`.`uom_id`
`items`.`brand_id`
`items`.`company_id`
`items`.`price`
`items`.`mrp`
`items`.`cost`
`items`.`purchase_price`
`items`.`sale_price`
`items`.`tax_rate`
`items`.`stock_quantity`
`items`.`max_qty`
`items`.`min_qty`
`items`.`reorder_days`
`items`.`low_stock_alert`
`items`.`branch_id`
`items`.`delete_status`
`items`.`created_at`
`items`.`updated_at`
`items`.`valuation_method`
`items`.`item_type`
`items`.`item_name_key`
`items`.`name_norm`
`items`.`aliases_norm`
`items_brands`.*
`items_brands`.`id`
`items_brands`.`brand_name`
`items_brands`.`description`
`items_brands`.`branch_id`
`items_brands`.`is_active`
`items_brands`.`delete_status`
`items_brands`.`created_at`
`items_brands`.`updated_at`
`items_category`.*
`items_category`.`id`
`items_category`.`category_name`
`items_category`.`is_active`
`items_category`.`description`
`items_category`.`branch_id`
`items_category`.`delete_status`
`items_category`.`created_at`
`items_category`.`updated_at`
`items_category_discounts_map`.*
`items_category_discounts_map`.`id`
`items_category_discounts_map`.`item_cat_id`
`items_category_discounts_map`.`discount_source`
`items_category_discounts_map`.`source_id`
`items_category_discounts_map`.`discount_type`
`items_category_discounts_map`.`discount_value`
`items_category_discounts_map`.`is_active`
`items_category_discounts_map`.`branch_id`
`items_category_discounts_map`.`created_at`
`items_category_discounts_map`.`updated_at`
`items_company`.*
`items_company`.`id`
`items_company`.`company_name`
`items_company`.`description`
`items_company`.`branch_id`
`items_company`.`is_active`
`items_company`.`delete_status`
`items_company`.`created_at`
`items_company`.`updated_at`
`items_delivery_sources`.*
`items_delivery_sources`.`id`
`items_delivery_sources`.`code`
`items_delivery_sources`.`title`
`items_delivery_sources`.`description`
`items_delivery_sources`.`active_status`
`items_delivery_sources`.`created_at`
`items_delivery_sources`.`updated_at`
`items_discount_categories`.*
`items_discount_categories`.`id`
`items_discount_categories`.`category_name`
`items_discount_categories`.`description`
`items_discount_categories`.`discount_type_id`
`items_discount_categories`.`discount_type`
`items_discount_categories`.`is_default`
`items_discount_categories`.`delete_status`
`items_discount_categories`.`created_at`
`items_discount_categories`.`updated_at`
`items_discount_types`.*
`items_discount_types`.`id`
`items_discount_types`.`discount_type_name`
`items_discount_types`.`description`
`items_discount_types`.`is_active`
`items_discount_types`.`delete_status`
`items_discount_types`.`created_at`
`items_discount_types`.`updated_at`
`items_godowns`.*
`items_godowns`.`id`
`items_godowns`.`godown_name`
`items_godowns`.`code`
`items_godowns`.`description`
`items_godowns`.`branch_id`
`items_godowns`.`address`
`items_godowns`.`city`
`items_godowns`.`pincode`
`items_godowns`.`state_id`
`items_godowns`.`country_id`
`items_godowns`.`contact_number`
`items_godowns`.`email`
`items_godowns`.`incharge_name`
`items_godowns`.`is_primary`
`items_godowns`.`active_status`
`items_godowns`.`delete_status`
`items_godowns`.`created_at`
`items_godowns`.`updated_at`
`items_hsn_sac`.*
`items_hsn_sac`.`id`
`items_hsn_sac`.`hsn_sac_code`
`items_hsn_sac`.`effective_date`
`items_hsn_sac`.`active_status`
`items_hsn_sac`.`gst`
`items_hsn_sac`.`cgst`
`items_hsn_sac`.`sgst`
`items_hsn_sac`.`igst`
`items_hsn_sac`.`cess`
`items_hsn_sac`.`branch_id`
`items_hsn_sac`.`is_delete`
`items_hsn_sac`.`created_at`
`items_hsn_sac`.`updated_at`
`items_opening_stock`.*
`items_opening_stock`.`id`
`items_opening_stock`.`item_id`
`items_opening_stock`.`branch_id`
`items_opening_stock`.`finance_year_id`
`items_opening_stock`.`opening_qty`
`items_opening_stock`.`opening_rate`
`items_opening_stock`.`opening_value`
`items_opening_stock`.`created_at`
`items_opening_stock`.`updated_at`
`items_scheme_discounts`.*
`items_scheme_discounts`.`id`
`items_scheme_discounts`.`scheme_name`
`items_scheme_discounts`.`discount_type_id`
`items_scheme_discounts`.`discount_type`
`items_scheme_discounts`.`applicable_districts`
`items_scheme_discounts`.`effective_from`
`items_scheme_discounts`.`effective_to`
`items_scheme_discounts`.`poster_image`
`items_scheme_discounts`.`branch_id`
`items_scheme_discounts`.`is_active`
`items_scheme_discounts`.`delete_status`
`items_scheme_discounts`.`created_at`
`items_scheme_discounts`.`updated_at`
`items_stock_ledger`.*
`items_stock_ledger`.`id`
`items_stock_ledger`.`item_id`
`items_stock_ledger`.`branch_id`
`items_stock_ledger`.`trans_type`
`items_stock_ledger`.`trans_ref_id`
`items_stock_ledger`.`trans_date`
`items_stock_ledger`.`qty_in`
`items_stock_ledger`.`qty_out`
`items_stock_ledger`.`balance_qty`
`items_stock_ledger`.`narration`
`items_stock_ledger`.`created_at`
`items_stock_summary`.*
`items_stock_summary`.`id`
`items_stock_summary`.`item_id`
`items_stock_summary`.`branch_id`
`items_stock_summary`.`opening_qty`
`items_stock_summary`.`inward_qty`
`items_stock_summary`.`outward_qty`
`items_stock_summary`.`closing_qty`
`items_stock_summary`.`last_updated`
`items_tax_hsn_sac`.*
`items_tax_hsn_sac`.`id`
`items_tax_hsn_sac`.`hsn_sac_code`
`items_tax_hsn_sac`.`tax_percentage`
`items_tax_hsn_sac`.`cgst`
`items_tax_hsn_sac`.`sgst`
`items_tax_hsn_sac`.`igst`
`items_tax_hsn_sac`.`cess`
`items_tax_hsn_sac`.`tax_type`
`items_tax_hsn_sac`.`tax_group_name`
`items_tax_hsn_sac`.`effective_date`
`items_tax_hsn_sac`.`active_status`
`items_tax_hsn_sac`.`branch_id`
`items_tax_hsn_sac`.`company_id`
`items_tax_hsn_sac`.`state_id`
`items_tax_hsn_sac`.`country_id`
`items_tax_hsn_sac`.`is_delete`
`items_tax_hsn_sac`.`created_at`
`items_tax_hsn_sac`.`updated_at`
`items_uom`.*
`items_uom`.`id`
`items_uom`.`uom_name`
`items_uom`.`uom_code`
`items_uom`.`description`
`items_uom`.`branch_id`
`items_uom`.`created_at`
`items_uom`.`updated_at`
`items_uom`.`delete_status`
`journal_voucher_lines`.*
`journal_voucher_lines`.`id`
`journal_voucher_lines`.`journal_voucher_id`
`journal_voucher_lines`.`ledger_id`
`journal_voucher_lines`.`dr_amount`
`journal_voucher_lines`.`cr_amount`
`journal_voucher_lines`.`delete_status`
`journal_voucher_lines`.`created_at`
`journal_voucher_lines`.`updated_at`
`journal_vouchers`.*
`journal_vouchers`.`id`
`journal_vouchers`.`voucher_number`
`journal_vouchers`.`voucher_type_id`
`journal_vouchers`.`voucher_date`
`journal_vouchers`.`journal_date`
`journal_vouchers`.`branch_id`
`journal_vouchers`.`finance_year_id`
`journal_vouchers`.`narration`
`journal_vouchers`.`posting_status`
`journal_vouchers`.`delete_status`
`journal_vouchers`.`created_by`
`journal_vouchers`.`updated_by`
`journal_vouchers`.`created_at`
`journal_vouchers`.`updated_at`
`ledger_bank_accounts`.*
`ledger_bank_accounts`.`id`
`ledger_bank_accounts`.`ledger_id`
`ledger_bank_accounts`.`branch_id`
`ledger_bank_accounts`.`account_name`
`ledger_bank_accounts`.`account_no`
`ledger_bank_accounts`.`ifsc_code`
`ledger_bank_accounts`.`bank_name`
`ledger_bank_accounts`.`branch_name`
`ledger_bank_accounts`.`account_type`
`ledger_bank_accounts`.`upi_id`
`ledger_bank_accounts`.`swift_code`
`ledger_bank_accounts`.`micr_code`
`ledger_bank_accounts`.`bank_details_applies_to`
`ledger_bank_accounts`.`is_primary`
`ledger_bank_accounts`.`opening_balance`
`ledger_bank_accounts`.`balance_type`
`ledger_bank_accounts`.`notes`
`ledger_bank_accounts`.`active_status`
`ledger_bank_accounts`.`delete_status`
`ledger_bank_accounts`.`created_at`
`ledger_bank_accounts`.`updated_at`
`ledger_contact_details`.*
`ledger_contact_details`.`id`
`ledger_contact_details`.`ledger_id`
`ledger_contact_details`.`contact_person_name`
`ledger_contact_details`.`contact_person_last_name`
`ledger_contact_details`.`designation`
`ledger_contact_details`.`contact_number`
`ledger_contact_details`.`whatsapp_number`
`ledger_contact_details`.`email_address`
`ledger_contact_details`.`is_primary`
`ledger_contact_details`.`created_at`
`ledger_contact_details`.`updated_at`
`ledger_details`.*
`ledger_details`.`id`
`ledger_details`.`ledger_name`
`ledger_details`.`trade_name`
`ledger_details`.`contact_person_name`
`ledger_details`.`mail_to`
`ledger_details`.`address`
`ledger_details`.`city`
`ledger_details`.`pincode`
`ledger_details`.`state_id`
`ledger_details`.`state_code`
`ledger_details`.`country_id`
`ledger_details`.`gst_verified`
`ledger_details`.`gst_registration_types_id`
`ledger_details`.`gst_number`
`ledger_details`.`pan_number`
`ledger_details`.`company_contact_number`
`ledger_details`.`whatsapp_number`
`ledger_details`.`mobile`
`ledger_details`.`email_id`
`ledger_details`.`website`
`ledger_details`.`tags`
`ledger_details`.`party_cat_id`
`ledger_details`.`parent_group_id`
`ledger_details`.`account_group_id`
`ledger_details`.`led_group_id`
`ledger_details`.`credit_days`
`ledger_details`.`credit_amount`
`ledger_details`.`credit_limit`
`ledger_details`.`auto_block_on_overdue`
`ledger_details`.`delivery_source`
`ledger_details`.`delivery_source_id`
`ledger_details`.`branch_id`
`ledger_details`.`delete_status`
`ledger_details`.`module`
`ledger_details`.`ledger_key_id`
`ledger_details`.`voucher_type_id`
`ledger_details`.`tds_section_code`
`ledger_details`.`ledger_type`
`ledger_details`.`charge_kind`
`ledger_details`.`system_ledger_applies_to`
`ledger_details`.`is_carrier_agent`
`ledger_details`.`is_default_carrier_agent`
`ledger_details`.`opening_balance`
`ledger_details`.`opening_balance_type`
`ledger_details`.`created_at`
`ledger_details`.`updated_at`
`ledger_entries_cash`.*
`ledger_entries_cash`.`id`
`ledger_entries_cash`.`ledger_name`
`ledger_entries_cash`.`trade_name`
`ledger_entries_cash`.`led_type_id`
`ledger_entries_cash`.`voucher_type_id`
`ledger_entries_cash`.`sales_entry_id`
`ledger_entries_cash`.`address`
`ledger_entries_cash`.`city`
`ledger_entries_cash`.`pincode`
`ledger_entries_cash`.`state_id`
`ledger_entries_cash`.`country_id`
`ledger_entries_cash`.`gst_registration_types_id`
`ledger_entries_cash`.`gst_number`
`ledger_entries_cash`.`pan_number`
`ledger_entries_cash`.`company_contact_number`
`ledger_entries_cash`.`whatsapp_number`
`ledger_entries_cash`.`email_id`
`ledger_entries_cash`.`delivery_source`
`ledger_entries_cash`.`branch_id`
`ledger_entries_cash`.`delete_status`
`ledger_entries_cash`.`created_at`
`ledger_entries_cash`.`updated_at`
`ledger_groups`.*
`ledger_groups`.`id`
`ledger_groups`.`title`
`ledger_groups`.`parent_group_id`
`ledger_groups`.`is_primary`
`ledger_groups`.`is_secondary`
`ledger_groups`.`sub_group`
`ledger_groups`.`delete_status`
`ledger_groups`.`main_group`
`ledger_groups`.`parent_group_title`
`ledger_groups`.`description`
`ledger_groups`.`active_status`
`ledger_groups`.`created_at`
`ledger_groups`.`updated_at`
`ledger_keys`.*
`ledger_keys`.`id`
`ledger_keys`.`ledger_key`
`ledger_keys`.`header_field`
`ledger_keys`.`description`
`ledger_keys`.`section_code`
`ledger_keys`.`ledger_type`
`ledger_keys`.`editable`
`ledger_keys`.`apply_on`
`ledger_keys`.`module`
`ledger_keys`.`account_category`
`ledger_keys`.`account_group`
`ledger_keys`.`default_ledger`
`ledger_keys`.`is_active`
`ledger_keys`.`created_at`
`ledger_keys`.`created_by`
`ledger_keys`.`updated_at`
`ledger_keys`.`updated_by`
`ledger_keys`.`external_ref_code`
`ledger_opening_balances`.*
`ledger_opening_balances`.`id`
`ledger_opening_balances`.`ledger_id`
`ledger_opening_balances`.`finance_year_id`
`ledger_opening_balances`.`financial_year`
`ledger_opening_balances`.`opening_debit`
`ledger_opening_balances`.`opening_credit`
`ledger_opening_balances`.`credit_period`
`ledger_opening_balances`.`branch_id`
`ledger_opening_balances`.`created_at`
`ledger_opening_balances`.`updated_at`
`ledger_opening_balances`.`delete_status`
`ledger_postings`.*
`ledger_postings`.`id`
`ledger_postings`.`posting_date`
`ledger_postings`.`txn_date`
`ledger_postings`.`voucher_id`
`ledger_postings`.`voucher_no`
`ledger_postings`.`voucher_type_id`
`ledger_postings`.`voucher_date`
`ledger_postings`.`ledger_id`
`ledger_postings`.`group_id`
`ledger_postings`.`parent_group_id`
`ledger_postings`.`entry_side`
`ledger_postings`.`dr_amount`
`ledger_postings`.`cr_amount`
`ledger_postings`.`branch_id`
`ledger_postings`.`finance_year_id`
`ledger_postings`.`user_id`
`ledger_postings`.`narration`
`ledger_postings`.`sort_order`
`ledger_postings`.`is_main_row`
`ledger_postings`.`cash_or_bank`
`ledger_postings`.`by_or_to`
`ledger_postings`.`other_details`
`ledger_postings`.`correspondent_ledger_id`
`ledger_postings`.`created_at`
`ledger_postings`.`updated_at`
`ledger_postings`.`delete_status`
`ledger_postings`.`deleted_by`
`ledger_postings`.`deleted_at`
`ledger_postings_audit`.*
`ledger_postings_audit`.`id`
`ledger_postings_audit`.`posting_date`
`ledger_postings_audit`.`voucher_id`
`ledger_postings_audit`.`line_no`
`ledger_postings_audit`.`voucher_no`
`ledger_postings_audit`.`voucher_type_id`
`ledger_postings_audit`.`voucher_date`
`ledger_postings_audit`.`ledger_id`
`ledger_postings_audit`.`ledger_group_id`
`ledger_postings_audit`.`amount_signed`
`ledger_postings_audit`.`currency_code`
`ledger_postings_audit`.`fx_rate`
`ledger_postings_audit`.`amount_base`
`ledger_postings_audit`.`branch_id`
`ledger_postings_audit`.`finance_year_id`
`ledger_postings_audit`.`user_id`
`ledger_postings_audit`.`narration`
`ledger_postings_audit`.`correspondent_ledger_id`
`ledger_postings_audit`.`corr_ledger_group_id`
`ledger_postings_audit`.`instrument_no`
`ledger_postings_audit`.`instrument_date`
`ledger_postings_audit`.`recon_status`
`ledger_postings_audit`.`recon_date`
`ledger_postings_audit`.`cost_center_id`
`ledger_postings_audit`.`project_id`
`ledger_postings_audit`.`source_module`
`ledger_postings_audit`.`source_id`
`ledger_postings_audit`.`tds_deduction_id`
`ledger_postings_audit`.`created_at`
`ledger_postings_audit`.`updated_at`
`ledger_postings_audit`.`delete_status`
`ledger_postings_audit`.`deleted_by`
`ledger_postings_audit`.`deleted_at`
`ledger_shipping_details`.*
`ledger_shipping_details`.`id`
`ledger_shipping_details`.`ledger_id`
`ledger_shipping_details`.`ledger_cash_id`
`ledger_shipping_details`.`parent_led_id`
`ledger_shipping_details`.`voucher_type_id`
`ledger_shipping_details`.`is_primary`
`ledger_shipping_details`.`ship_to`
`ledger_shipping_details`.`mailing_name`
`ledger_shipping_details`.`shipping_address`
`ledger_shipping_details`.`shipping_contact`
`ledger_shipping_details`.`shipping_city`
`ledger_shipping_details`.`shipping_state_id`
`ledger_shipping_details`.`shipping_country_id`
`ledger_shipping_details`.`shipping_pincode`
`ledger_shipping_details`.`shipping_gstin`
`ledger_shipping_details`.`place_of_supply`
`ledger_shipping_details`.`delivery_source`
`ledger_shipping_details`.`godown_id`
`ledger_shipping_details`.`plant_id`
`ledger_shipping_details`.`branch_id`
`ledger_shipping_details`.`created_at`
`ledger_shipping_details`.`updated_at`
`ledger_transactions`.*
`ledger_transactions`.`id`
`ledger_transactions`.`ref_table`
`ledger_transactions`.`ref_id`
`ledger_transactions`.`voucher_type_id`
`ledger_transactions`.`voucher_type`
`ledger_transactions`.`voucher_id`
`ledger_transactions`.`voucher_number`
`ledger_transactions`.`voucher_date`
`ledger_transactions`.`ledger_id`
`ledger_transactions`.`ledger_name`
`ledger_transactions`.`parent_group_id`
`ledger_transactions`.`parent_group_title`
`ledger_transactions`.`ledger_group_id`
`ledger_transactions`.`ledger_group_title`
`ledger_transactions`.`dr_amount`
`ledger_transactions`.`cr_amount`
`ledger_transactions`.`narration`
`ledger_transactions`.`delete_status`
`ledger_transactions`.`correspondent_ledger`
`ledger_transactions`.`correspondent_ledger_id`
`ledger_transactions`.`branch_id`
`ledger_transactions`.`created_at`
`ledger_transactions`.`updated_at`
`ledger_transactions`.`by`
`ledger_transactions`.`to`
`ledger_transactions`.`is_other_details`
`ledger_transactions`.`is_cash_bank_detailsreport`
`ledger_transactions`.`correspondent_date`
`ledger_transactions`.`alias_ledger_id`
`ledger_types_deleted`.*
`ledger_types_deleted`.`id`
`ledger_types_deleted`.`title`
`ledger_types_deleted`.`group_type`
`ledger_types_deleted`.`is_default`
`ledger_types_deleted`.`description`
`ledger_types_deleted`.`active_status`
`ledger_types_deleted`.`created_at`
`ledger_types_deleted`.`updated_at`
`mastergst_tokens`.*
`mastergst_tokens`.`id`
`mastergst_tokens`.`gstin`
`mastergst_tokens`.`access_token`
`mastergst_tokens`.`token_expiry`
`mastergst_tokens`.`created_at`
`message_queue`.*
`message_queue`.`id`
`message_queue`.`phone_number`
`message_queue`.`message_text`
`message_queue`.`status`
`message_queue`.`created_at`
`monthly_financial_summary`.*
`monthly_financial_summary`.`summary_month`
`monthly_financial_summary`.`branch_id`
`monthly_financial_summary`.`total_sales`
`monthly_financial_summary`.`total_purchases`
`monthly_financial_summary`.`total_receipts`
`monthly_financial_summary`.`total_payments`
`monthly_financial_summary`.`credit_note`
`monthly_financial_summary`.`debit_note`
`monthly_financial_summary`.`finance_year_id`
`parts`.*
`parts`.`id`
`parts`.`part_id`
`parts`.`part_title`
`parts`.`part_cost`
`parts`.`image_path`
`parts`.`image_url`
`parts`.`is_active`
`parts`.`delete_status`
`parts`.`created_at`
`parts`.`updated_at`
`party_comments`.*
`party_comments`.`id`
`party_comments`.`party_id`
`party_comments`.`comment_type`
`party_comments`.`comment_text`
`party_comments`.`commenter`
`party_comments`.`comment_date`
`party_comments`.`branch_id`
`party_comments`.`delete_status`
`party_comments`.`created_at`
`party_comments`.`updated_at`
`payment_details_draft`.*
`payment_details_draft`.`id`
`payment_details_draft`.`transaction_id`
`payment_details_draft`.`voucher_type_id`
`payment_details_draft`.`voucher_date`
`payment_details_draft`.`ledger_id`
`payment_details_draft`.`ledger_account_id`
`payment_details_draft`.`ledger_account_name`
`payment_details_draft`.`instrument_type`
`payment_details_draft`.`instrument_number`
`payment_details_draft`.`amount`
`payment_details_draft`.`branch_id`
`payment_details_draft`.`narration`
`payment_details_draft`.`received_status`
`payment_details_draft`.`move_to_receipt`
`payment_details_draft`.`delete_status`
`payment_details_draft`.`created_at`
`payment_details_draft`.`updated_at`
`payment_purchase_mapping`.*
`payment_purchase_mapping`.`id`
`payment_purchase_mapping`.`payment_transaction_id`
`payment_purchase_mapping`.`purchase_entry_id`
`payment_purchase_mapping`.`allocated_amount`
`payment_purchase_mapping`.`branch_id`
`payment_purchase_mapping`.`delete_status`
`payment_purchase_mapping`.`created_at`
`payment_purchase_mapping`.`updated_at`
`payment_voucher_allocations`.*
`payment_voucher_allocations`.`id`
`payment_voucher_allocations`.`payment_voucher_id`
`payment_voucher_allocations`.`voucher_type_id`
`payment_voucher_allocations`.`invoice_id`
`payment_voucher_allocations`.`allocated_amount`
`payment_voucher_allocations`.`remarks`
`payment_voucher_allocations`.`delete_status`
`payment_voucher_allocations`.`created_at`
`payment_voucher_allocations`.`updated_at`
`payment_vouchers`.*
`payment_vouchers`.`id`
`payment_vouchers`.`entry_type`
`payment_vouchers`.`voucher_type_id`
`payment_vouchers`.`cash_or_bank`
`payment_vouchers`.`voucher_no`
`payment_vouchers`.`voucher_date`
`payment_vouchers`.`ledger_id`
`payment_vouchers`.`ledger_account_id`
`payment_vouchers`.`expense_head`
`payment_vouchers`.`gst_aplicability`
`payment_vouchers`.`ref_bill_no`
`payment_vouchers`.`instrument_type`
`payment_vouchers`.`instrument_number`
`payment_vouchers`.`amount`
`payment_vouchers`.`branch_id`
`payment_vouchers`.`user_id`
`payment_vouchers`.`narration`
`payment_vouchers`.`delete_status`
`payment_vouchers`.`created_at`
`payment_vouchers`.`updated_at`
`payment_vouchers`.`created_by`
`payment_vouchers`.`modified_by`
`payment_vouchers`.`finance_year_id`
`payment_vouchers`.`bank_name`
`payment_vouchers`.`account_no`
`payment_vouchers`.`ifsc_code`
`payment_vouchers`.`reference_id`
`plant_details`.*
`plant_details`.`id`
`plant_details`.`plant_name`
`plant_details`.`plant_code`
`plant_details`.`address`
`plant_details`.`city`
`plant_details`.`pincode`
`plant_details`.`state_id`
`plant_details`.`country_id`
`plant_details`.`contact_number`
`plant_details`.`email`
`plant_details`.`is_active`
`plant_details`.`branch_id`
`plant_details`.`delete_status`
`plant_details`.`created_at`
`plant_details`.`updated_at`
`posting_audit_log`.*
`posting_audit_log`.`id`
`posting_audit_log`.`voucher_type_id`
`posting_audit_log`.`ref_id`
`posting_audit_log`.`ref_table`
`posting_audit_log`.`posting_action`
`posting_audit_log`.`message`
`posting_audit_log`.`posting_time`
`posting_audit_log`.`posted_by`
`posting_control`.*
`posting_control`.`id`
`posting_control`.`voucher_type_id`
`posting_control`.`voucher_id`
`posting_control`.`posting_status`
`posting_control`.`posted_by`
`posting_control`.`posting_at`
`posting_period_control`.*
`posting_period_control`.`period_start`
`posting_period_control`.`period_end`
`posting_period_control`.`is_locked`
`posting_period_control`.`locked_by`
`posting_period_control`.`locked_at`
`postings_audit_log`.*
`postings_audit_log`.`id`
`postings_audit_log`.`voucher_id`
`postings_audit_log`.`voucher_type`
`postings_audit_log`.`table_name`
`postings_audit_log`.`row_data`
`postings_audit_log`.`deleted_by`
`postings_audit_log`.`deleted_at`
`postings_audit_log`.`recovered`
`pricing_recompute_queue`.*
`pricing_recompute_queue`.`id`
`pricing_recompute_queue`.`branch_id`
`pricing_recompute_queue`.`item_id`
`pricing_recompute_queue`.`reason`
`pricing_recompute_queue`.`created_at`
`purchase_entries`.*
`purchase_entries`.`id`
`purchase_entries`.`purchase_invoice_no`
`purchase_entries`.`purchase_invoice_date`
`purchase_entries`.`voucher_number`
`purchase_entries`.`voucher_type_id`
`purchase_entries`.`entry_mode`
`purchase_entries`.`grn_ref_id`
`purchase_entries`.`grn_status`
`purchase_entries`.`sales_channel`
`purchase_entries`.`sales_person_id`
`purchase_entries`.`source_quotation_id`
`purchase_entries`.`voucher_date`
`purchase_entries`.`voucher_time`
`purchase_entries`.`due_date`
`purchase_entries`.`ledger_id`
`purchase_entries`.`party_cat_id`
`purchase_entries`.`invoice_amount`
`purchase_entries`.`price`
`purchase_entries`.`pri_discount`
`purchase_entries`.`proportionate_discount`
`purchase_entries`.`total_discount`
`purchase_entries`.`discount_coupon_code`
`purchase_entries`.`applied_discount_category`
`purchase_entries`.`applied_discount_category_id`
`purchase_entries`.`taxable_amount`
`purchase_entries`.`item_tax_amout`
`purchase_entries`.`add_charges_fixed_tax_amount`
`purchase_entries`.`add_charges_proportionate_tax_amount`
`purchase_entries`.`total_tax_amount`
`purchase_entries`.`tds_amount`
`purchase_entries`.`freight_charges`
`purchase_entries`.`add_charges`
`purchase_entries`.`sgst_amount`
`purchase_entries`.`cgst_amount`
`purchase_entries`.`igst_amount`
`purchase_entries`.`cess_amount`
`purchase_entries`.`payment_status`
`purchase_entries`.`narration`
`purchase_entries`.`additional_discount_remarks`
`purchase_entries`.`discount_details`
`purchase_entries`.`receiver_name`
`purchase_entries`.`receiver_contact_number`
`purchase_entries`.`branch_id`
`purchase_entries`.`user_id`
`purchase_entries`.`finance_year_id`
`purchase_entries`.`delete_status`
`purchase_entries`.`created_at`
`purchase_entries`.`updated_at`
`purchase_entries`.`round_off`
`purchase_entries`.`total_amount`
`purchase_entries`.`irn`
`purchase_entries`.`ack_no`
`purchase_entries`.`ack_date`
`purchase_entries`.`qr_code`
`purchase_entries`.`einvoice_status`
`purchase_entries`.`einvoice_error`
`purchase_entries`.`ewaybill_no`
`purchase_entries`.`ewaybill_date`
`purchase_entries`.`ewaybill_status`
`purchase_entries`.`ewaybill_error`
`purchase_entries`.`posting_status`
`purchase_entries_old`.*
`purchase_entries_old`.`id`
`purchase_entries_old`.`voucher_number`
`purchase_entries_old`.`voucher_type`
`purchase_entries_old`.`voucher_date`
`purchase_entries_old`.`due_date`
`purchase_entries_old`.`ledger_id`
`purchase_entries_old`.`voucher_type_id`
`purchase_entries_old`.`finance_year_id`
`purchase_entries_old`.`invoice_no`
`purchase_entries_old`.`invoice_date`
`purchase_entries_old`.`price`
`purchase_entries_old`.`total_discount`
`purchase_entries_old`.`applied_discount_category_id`
`purchase_entries_old`.`taxable_amount`
`purchase_entries_old`.`total_amount`
`purchase_entries_old`.`tax_amount`
`purchase_entries_old`.`freight_charges`
`purchase_entries_old`.`add_charges`
`purchase_entries_old`.`sgst_amount`
`purchase_entries_old`.`cgst_amount`
`purchase_entries_old`.`igst_amount`
`purchase_entries_old`.`cess_amount`
`purchase_entries_old`.`payment_status`
`purchase_entries_old`.`narration`
`purchase_entries_old`.`branch_id`
`purchase_entries_old`.`delete_status`
`purchase_entries_old`.`created_at`
`purchase_entries_old`.`updated_at`
`purchase_entry_items`.*
`purchase_entry_items`.`id`
`purchase_entry_items`.`purchase_entry_id`
`purchase_entry_items`.`godown_id`
`purchase_entry_items`.`item_id`
`purchase_entry_items`.`hsn_sac_id`
`purchase_entry_items`.`uom_id`
`purchase_entry_items`.`quantity`
`purchase_entry_items`.`rate`
`purchase_entry_items`.`price`
`purchase_entry_items`.`discount_type`
`purchase_entry_items`.`discount_source_id`
`purchase_entry_items`.`discount_value`
`purchase_entry_items`.`discount_amount`
`purchase_entry_items`.`proportionate_discount`
`purchase_entry_items`.`taxable_amount`
`purchase_entry_items`.`proportionate_add_charges_amount`
`purchase_entry_items`.`tax_percentage`
`purchase_entry_items`.`cgst_percentage`
`purchase_entry_items`.`sgst_percentage`
`purchase_entry_items`.`igst_percentage`
`purchase_entry_items`.`cess_percentage`
`purchase_entry_items`.`tax_amount`
`purchase_entry_items`.`cgst_amount`
`purchase_entry_items`.`sgst_amount`
`purchase_entry_items`.`igst_amount`
`purchase_entry_items`.`cess_amount`
`purchase_entry_items`.`branch_id`
`purchase_entry_items`.`delete_status`
`purchase_entry_items`.`created_at`
`purchase_entry_items`.`updated_at`
`purchase_entry_items_old`.*
`purchase_entry_items_old`.`id`
`purchase_entry_items_old`.`purchase_entry_id`
`purchase_entry_items_old`.`item_id`
`purchase_entry_items_old`.`godown_id`
`purchase_entry_items_old`.`voucher_type_id`
`purchase_entry_items_old`.`hsn_sac_id`
`purchase_entry_items_old`.`uom_id`
`purchase_entry_items_old`.`quantity`
`purchase_entry_items_old`.`rate`
`purchase_entry_items_old`.`price`
`purchase_entry_items_old`.`discount_type_id`
`purchase_entry_items_old`.`discount_value`
`purchase_entry_items_old`.`discount_amount`
`purchase_entry_items_old`.`taxable_amount`
`purchase_entry_items_old`.`gst_percentage`
`purchase_entry_items_old`.`cgst_percentage`
`purchase_entry_items_old`.`sgst_percentage`
`purchase_entry_items_old`.`igst_percentage`
`purchase_entry_items_old`.`cess_percentage`
`purchase_entry_items_old`.`gst_amount`
`purchase_entry_items_old`.`cgst_amount`
`purchase_entry_items_old`.`sgst_amount`
`purchase_entry_items_old`.`igst_amount`
`purchase_entry_items_old`.`cess_amount`
`purchase_entry_items_old`.`branch_id`
`purchase_entry_items_old`.`delete_status`
`purchase_entry_items_old`.`created_at`
`purchase_entry_items_old`.`updated_at`
`purchase_order_items`.*
`purchase_order_items`.`id`
`purchase_order_items`.`purchase_order_id`
`purchase_order_items`.`item_id`
`purchase_order_items`.`quantity`
`purchase_order_items`.`unit_price`
`purchase_order_items`.`total_price`
`purchase_order_items`.`delete_status`
`purchase_order_items`.`modified_by`
`purchase_order_items`.`created_at`
`purchase_order_items`.`updated_at`
`purchase_orders`.*
`purchase_orders`.`id`
`purchase_orders`.`po_number`
`purchase_orders`.`supplier_id`
`purchase_orders`.`order_date`
`purchase_orders`.`status`
`purchase_orders`.`total_amount`
`purchase_orders`.`branch_id`
`purchase_orders`.`delete_status`
`purchase_orders`.`created_at`
`purchase_orders`.`updated_at`
`purchase_return_items`.*
`purchase_return_items`.`id`
`purchase_return_items`.`purchase_return_id`
`purchase_return_items`.`purchase_entry_id`
`purchase_return_items`.`purchase_return_reason_id`
`purchase_return_items`.`item_id`
`purchase_return_items`.`godown_id`
`purchase_return_items`.`hsn_sac_id`
`purchase_return_items`.`uom_id`
`purchase_return_items`.`quantity`
`purchase_return_items`.`discounted_rate`
`purchase_return_items`.`deduction_type`
`purchase_return_items`.`deduction_value`
`purchase_return_items`.`deduction_amount`
`purchase_return_items`.`discounted_price`
`purchase_return_items`.`proportionate_discount`
`purchase_return_items`.`taxable_amount`
`purchase_return_items`.`proportionate_add_charges_amount`
`purchase_return_items`.`gst_percentage`
`purchase_return_items`.`cgst_percentage`
`purchase_return_items`.`sgst_percentage`
`purchase_return_items`.`igst_percentage`
`purchase_return_items`.`cess_percentage`
`purchase_return_items`.`gst_amount`
`purchase_return_items`.`cgst_amount`
`purchase_return_items`.`sgst_amount`
`purchase_return_items`.`igst_amount`
`purchase_return_items`.`cess_amount`
`purchase_return_items`.`deduction_reason`
`purchase_return_items`.`branch_id`
`purchase_return_items`.`delete_status`
`purchase_return_items`.`created_at`
`purchase_return_items`.`updated_at`
`purchase_return_items_old`.*
`purchase_return_items_old`.`id`
`purchase_return_items_old`.`purchase_return_id`
`purchase_return_items_old`.`purchase_entry_id`
`purchase_return_items_old`.`purchase_entry_item_id`
`purchase_return_items_old`.`item_id`
`purchase_return_items_old`.`branch_id`
`purchase_return_items_old`.`return_quantity`
`purchase_return_items_old`.`unit_price_discounted`
`purchase_return_items_old`.`return_amount`
`purchase_return_items_old`.`return_reason_id`
`purchase_return_items_old`.`remarks`
`purchase_return_items_old`.`delete_status`
`purchase_return_items_old`.`created_at`
`purchase_return_items_old`.`updated_at`
`purchase_return_old`.*
`purchase_return_old`.`id`
`purchase_return_old`.`voucher_number`
`purchase_return_old`.`voucher_date`
`purchase_return_old`.`ledger_id`
`purchase_return_old`.`total_return_qty`
`purchase_return_old`.`total_return_amount`
`purchase_return_old`.`branch_id`
`purchase_return_old`.`return_status`
`purchase_return_old`.`approved_by`
`purchase_return_old`.`created_by`
`purchase_return_old`.`delete_status`
`purchase_return_old`.`created_at`
`purchase_return_old`.`updated_at`
`purchase_returns`.*
`purchase_returns`.`id`
`purchase_returns`.`voucher_number`
`purchase_returns`.`voucher_type_id`
`purchase_returns`.`voucher_date`
`purchase_returns`.`ledger_id`
`purchase_returns`.`discounted_rate`
`purchase_returns`.`pri_discount`
`purchase_returns`.`proportionate_discount`
`purchase_returns`.`total_discount`
`purchase_returns`.`total_deduction_amount`
`purchase_returns`.`taxable_amount`
`purchase_returns`.`item_tax_amout`
`purchase_returns`.`add_charges_fixed_tax_amount`
`purchase_returns`.`add_charges_proportionate_tax_amount`
`purchase_returns`.`total_tax_amount`
`purchase_returns`.`tds_amount`
`purchase_returns`.`freight_charges`
`purchase_returns`.`add_charges`
`purchase_returns`.`sgst_amount`
`purchase_returns`.`cgst_amount`
`purchase_returns`.`igst_amount`
`purchase_returns`.`cess_amount`
`purchase_returns`.`payment_status`
`purchase_returns`.`posting_status`
`purchase_returns`.`narration`
`purchase_returns`.`receiver_name`
`purchase_returns`.`receiver_contact_number`
`purchase_returns`.`branch_id`
`purchase_returns`.`finance_year_id`
`purchase_returns`.`delete_status`
`purchase_returns`.`created_at`
`purchase_returns`.`user_id`
`purchase_returns`.`updated_at`
`purchase_returns`.`total_amount`
`purchase_returns`.`round_off`
`quotation_entries`.*
`quotation_entries`.`id`
`quotation_entries`.`voucher_number`
`quotation_entries`.`voucher_type_id`
`quotation_entries`.`sales_channel`
`quotation_entries`.`sales_person_id`
`quotation_entries`.`source_quotation_id`
`quotation_entries`.`voucher_date`
`quotation_entries`.`voucher_time`
`quotation_entries`.`due_date`
`quotation_entries`.`ledger_id`
`quotation_entries`.`party_cat_id`
`quotation_entries`.`invoice_amount`
`quotation_entries`.`price`
`quotation_entries`.`pri_discount`
`quotation_entries`.`proportionate_discount`
`quotation_entries`.`total_discount`
`quotation_entries`.`discount_coupon_code`
`quotation_entries`.`applied_discount_category`
`quotation_entries`.`applied_discount_category_id`
`quotation_entries`.`taxable_amount`
`quotation_entries`.`item_tax_amout`
`quotation_entries`.`add_charges_fixed_tax_amount`
`quotation_entries`.`add_charges_proportionate_tax_amount`
`quotation_entries`.`total_tax_amount`
`quotation_entries`.`tds_amount`
`quotation_entries`.`freight_charges`
`quotation_entries`.`add_charges`
`quotation_entries`.`sgst_amount`
`quotation_entries`.`cgst_amount`
`quotation_entries`.`igst_amount`
`quotation_entries`.`cess_amount`
`quotation_entries`.`payment_status`
`quotation_entries`.`narration`
`quotation_entries`.`additional_discount_remarks`
`quotation_entries`.`discount_details`
`quotation_entries`.`receiver_name`
`quotation_entries`.`receiver_contact_number`
`quotation_entries`.`branch_id`
`quotation_entries`.`user_id`
`quotation_entries`.`finance_year_id`
`quotation_entries`.`delete_status`
`quotation_entries`.`created_at`
`quotation_entries`.`updated_at`
`quotation_entries`.`round_off`
`quotation_entries`.`total_amount`
`quotation_entries`.`irn`
`quotation_entries`.`ack_no`
`quotation_entries`.`ack_date`
`quotation_entries`.`qr_code`
`quotation_entries`.`einvoice_status`
`quotation_entries`.`einvoice_error`
`quotation_entries`.`ewaybill_no`
`quotation_entries`.`ewaybill_date`
`quotation_entries`.`ewaybill_status`
`quotation_entries`.`ewaybill_error`
`quotation_entries`.`posting_status`
`quotation_entry_items`.*
`quotation_entry_items`.`id`
`quotation_entry_items`.`sales_entry_id`
`quotation_entry_items`.`godown_id`
`quotation_entry_items`.`item_id`
`quotation_entry_items`.`hsn_sac_id`
`quotation_entry_items`.`uom_id`
`quotation_entry_items`.`quantity`
`quotation_entry_items`.`rate`
`quotation_entry_items`.`price`
`quotation_entry_items`.`discount_type`
`quotation_entry_items`.`discount_source_id`
`quotation_entry_items`.`discount_value`
`quotation_entry_items`.`discount_amount`
`quotation_entry_items`.`proportionate_discount`
`quotation_entry_items`.`taxable_amount`
`quotation_entry_items`.`proportionate_add_charges_amount`
`quotation_entry_items`.`tax_percentage`
`quotation_entry_items`.`cgst_percentage`
`quotation_entry_items`.`sgst_percentage`
`quotation_entry_items`.`igst_percentage`
`quotation_entry_items`.`cess_percentage`
`quotation_entry_items`.`tax_amount`
`quotation_entry_items`.`cgst_amount`
`quotation_entry_items`.`sgst_amount`
`quotation_entry_items`.`igst_amount`
`quotation_entry_items`.`cess_amount`
`quotation_entry_items`.`branch_id`
`quotation_entry_items`.`delete_status`
`quotation_entry_items`.`created_at`
`quotation_entry_items`.`updated_at`
`receipt_sales_mapping`.*
`receipt_sales_mapping`.`id`
`receipt_sales_mapping`.`receipt_transaction_id`
`receipt_sales_mapping`.`sales_entry_id`
`receipt_sales_mapping`.`allocated_amount`
`receipt_sales_mapping`.`created_at`
`receipt_sales_mapping`.`updated_at`
`receipt_voucher_allocations`.*
`receipt_voucher_allocations`.`id`
`receipt_voucher_allocations`.`receipt_voucher_id`
`receipt_voucher_allocations`.`voucher_type_id`
`receipt_voucher_allocations`.`invoice_id`
`receipt_voucher_allocations`.`allocated_amount`
`receipt_voucher_allocations`.`remarks`
`receipt_voucher_allocations`.`delete_status`
`receipt_voucher_allocations`.`created_at`
`receipt_voucher_allocations`.`updated_at`
`receipt_vouchers`.*
`receipt_vouchers`.`id`
`receipt_vouchers`.`voucher_type_id`
`receipt_vouchers`.`cash_or_bank`
`receipt_vouchers`.`voucher_no`
`receipt_vouchers`.`voucher_date`
`receipt_vouchers`.`ledger_id`
`receipt_vouchers`.`ledger_account_id`
`receipt_vouchers`.`instrument_type`
`receipt_vouchers`.`instrument_number`
`receipt_vouchers`.`bank_name`
`receipt_vouchers`.`amount`
`receipt_vouchers`.`tds_amount`
`receipt_vouchers`.`branch_id`
`receipt_vouchers`.`user_id`
`receipt_vouchers`.`finance_year_id`
`receipt_vouchers`.`reference_id`
`receipt_vouchers`.`narration`
`receipt_vouchers`.`delete_status`
`receipt_vouchers`.`created_by`
`receipt_vouchers`.`modified_by`
`receipt_vouchers`.`created_at`
`receipt_vouchers`.`updated_at`
`report_data_entries`.*
`report_data_entries`.`id`
`report_data_entries`.`entry_type`
`report_data_entries`.`entry_id`
`report_data_entries`.`ledger_id`
`report_data_entries`.`transaction_date`
`report_data_entries`.`voucher_number`
`report_data_entries`.`narration`
`report_data_entries`.`debit_amount`
`report_data_entries`.`credit_amount`
`report_data_entries`.`branch_id`
`report_data_entries`.`item_id`
`report_data_entries`.`hsn_code`
`report_data_entries`.`gst_percentage`
`report_data_entries`.`stock_qty`
`report_data_entries`.`stock_value`
`report_data_entries`.`created_at`
`report_data_entries`.`updated_at`
`sales_entries`.*
`sales_entries`.`id`
`sales_entries`.`voucher_number`
`sales_entries`.`voucher_type_id`
`sales_entries`.`entry_mode`
`sales_entries`.`proforma_ref_id`
`sales_entries`.`proforma_status`
`sales_entries`.`sales_channel`
`sales_entries`.`sales_person_id`
`sales_entries`.`source_quotation_id`
`sales_entries`.`source_sales_id`
`sales_entries`.`quotation_moved_status`
`sales_entries`.`voucher_date`
`sales_entries`.`voucher_time`
`sales_entries`.`due_date`
`sales_entries`.`ledger_id`
`sales_entries`.`party_cat_id`
`sales_entries`.`invoice_amount`
`sales_entries`.`price`
`sales_entries`.`subsidy_scheme_id`
`sales_entries`.`pri_discount`
`sales_entries`.`proportionate_discount`
`sales_entries`.`total_discount`
`sales_entries`.`discount_coupon_code`
`sales_entries`.`applied_discount_category`
`sales_entries`.`applied_discount_category_id`
`sales_entries`.`taxable_amount`
`sales_entries`.`item_tax_amout`
`sales_entries`.`add_charges_fixed_tax_amount`
`sales_entries`.`add_charges_proportionate_tax_amount`
`sales_entries`.`total_tax_amount`
`sales_entries`.`tds_amount`
`sales_entries`.`freight_charges`
`sales_entries`.`add_charges`
`sales_entries`.`sgst_amount`
`sales_entries`.`cgst_amount`
`sales_entries`.`igst_amount`
`sales_entries`.`cess_amount`
`sales_entries`.`payment_status`
`sales_entries`.`narration`
`sales_entries`.`additional_discount_remarks`
`sales_entries`.`discount_details`
`sales_entries`.`receiver_name`
`sales_entries`.`receiver_contact_number`
`sales_entries`.`branch_id`
`sales_entries`.`user_id`
`sales_entries`.`finance_year_id`
`sales_entries`.`delete_status`
`sales_entries`.`created_at`
`sales_entries`.`updated_at`
`sales_entries`.`round_off`
`sales_entries`.`total_amount`
`sales_entries`.`irn`
`sales_entries`.`ack_no`
`sales_entries`.`ack_date`
`sales_entries`.`qr_code`
`sales_entries`.`einvoice_status`
`sales_entries`.`einvoice_error`
`sales_entries`.`ewaybill_no`
`sales_entries`.`ewaybill_date`
`sales_entries`.`ewaybill_status`
`sales_entries`.`ewaybill_error`
`sales_entries`.`posting_status`
`sales_entry_items`.*
`sales_entry_items`.`id`
`sales_entry_items`.`sales_entry_id`
`sales_entry_items`.`godown_id`
`sales_entry_items`.`subsidy_scheme_id`
`sales_entry_items`.`subsidy_billed`
`sales_entry_items`.`other_discount_applicable`
`sales_entry_items`.`item_id`
`sales_entry_items`.`hsn_sac_id`
`sales_entry_items`.`uom_id`
`sales_entry_items`.`quantity`
`sales_entry_items`.`rate`
`sales_entry_items`.`price`
`sales_entry_items`.`discount_type`
`sales_entry_items`.`discount_source_id`
`sales_entry_items`.`discount_value`
`sales_entry_items`.`discount_amount`
`sales_entry_items`.`proportionate_discount`
`sales_entry_items`.`taxable_amount`
`sales_entry_items`.`proportionate_add_charges_amount`
`sales_entry_items`.`tax_percentage`
`sales_entry_items`.`cgst_percentage`
`sales_entry_items`.`sgst_percentage`
`sales_entry_items`.`igst_percentage`
`sales_entry_items`.`cess_percentage`
`sales_entry_items`.`tax_amount`
`sales_entry_items`.`cgst_amount`
`sales_entry_items`.`sgst_amount`
`sales_entry_items`.`igst_amount`
`sales_entry_items`.`cess_amount`
`sales_entry_items`.`branch_id`
`sales_entry_items`.`delete_status`
`sales_entry_items`.`created_at`
`sales_entry_items`.`updated_at`
`sales_invoice_discounts`.*
`sales_invoice_discounts`.`id`
`sales_invoice_discounts`.`invoice_id`
`sales_invoice_discounts`.`branch_id`
`sales_invoice_discounts`.`exchange_id`
`sales_invoice_discounts`.`subsidy_id`
`sales_invoice_discounts`.`discount_coupon_code`
`sales_invoice_discounts`.`other_discount_amount`
`sales_invoice_discounts`.`total_discount`
`sales_invoice_discounts`.`remarks`
`sales_invoice_discounts`.`selected_other_discount_items`
`sales_invoice_discounts`.`selected_subsidy_items`
`sales_invoice_discounts`.`delete_status`
`sales_invoice_discounts`.`created_at`
`sales_invoice_discounts`.`updated_at`
`sales_invoice_exchange`.*
`sales_invoice_exchange`.`id`
`sales_invoice_exchange`.`discount_id`
`sales_invoice_exchange`.`old_item_id`
`sales_invoice_exchange`.`machine_name`
`sales_invoice_exchange`.`list_price`
`sales_invoice_exchange`.`exchange_value`
`sales_invoice_exchange`.`remarks`
`sales_invoice_other_discounts`.*
`sales_invoice_other_discounts`.`id`
`sales_invoice_other_discounts`.`discount_id`
`sales_invoice_other_discounts`.`discount_type`
`sales_invoice_other_discounts`.`amount`
`sales_invoice_other_discounts`.`reason`
`sales_invoice_subsidy`.*
`sales_invoice_subsidy`.`id`
`sales_invoice_subsidy`.`invoice_id`
`sales_invoice_subsidy`.`scheme_id`
`sales_invoice_subsidy`.`scheme_document_id`
`sales_invoice_subsidy`.`document_name`
`sales_invoice_subsidy`.`document_verified`
`sales_invoice_subsidy`.`remarks`
`sales_invoice_subsidy`.`branch_id`
`sales_invoice_subsidy`.`created_by`
`sales_invoice_subsidy`.`modified_by`
`sales_invoice_subsidy`.`created_at`
`sales_invoice_subsidy`.`updated_at`
`sales_return_items`.*
`sales_return_items`.`id`
`sales_return_items`.`sales_return_id`
`sales_return_items`.`sales_entry_id`
`sales_return_items`.`sales_return_reason_id`
`sales_return_items`.`item_id`
`sales_return_items`.`godown_id`
`sales_return_items`.`hsn_sac_id`
`sales_return_items`.`uom_id`
`sales_return_items`.`quantity`
`sales_return_items`.`discounted_rate`
`sales_return_items`.`deduction_type`
`sales_return_items`.`deduction_value`
`sales_return_items`.`deduction_amount`
`sales_return_items`.`discounted_price`
`sales_return_items`.`proportionate_discount`
`sales_return_items`.`taxable_amount`
`sales_return_items`.`proportionate_add_charges_amount`
`sales_return_items`.`gst_percentage`
`sales_return_items`.`cgst_percentage`
`sales_return_items`.`sgst_percentage`
`sales_return_items`.`igst_percentage`
`sales_return_items`.`cess_percentage`
`sales_return_items`.`gst_amount`
`sales_return_items`.`cgst_amount`
`sales_return_items`.`sgst_amount`
`sales_return_items`.`igst_amount`
`sales_return_items`.`cess_amount`
`sales_return_items`.`deduction_reason`
`sales_return_items`.`branch_id`
`sales_return_items`.`delete_status`
`sales_return_items`.`created_at`
`sales_return_items`.`updated_at`
`sales_return_reasons`.*
`sales_return_reasons`.`id`
`sales_return_reasons`.`reason_title`
`sales_return_reasons`.`description`
`sales_return_reasons`.`is_active`
`sales_return_reasons`.`created_at`
`sales_return_reasons`.`updated_at`
`sales_returns`.*
`sales_returns`.`id`
`sales_returns`.`voucher_number`
`sales_returns`.`voucher_type_id`
`sales_returns`.`voucher_date`
`sales_returns`.`ledger_id`
`sales_returns`.`discounted_rate`
`sales_returns`.`pri_discount`
`sales_returns`.`proportionate_discount`
`sales_returns`.`total_discount`
`sales_returns`.`total_deduction_amount`
`sales_returns`.`taxable_amount`
`sales_returns`.`item_tax_amout`
`sales_returns`.`add_charges_fixed_tax_amount`
`sales_returns`.`add_charges_proportionate_tax_amount`
`sales_returns`.`total_tax_amount`
`sales_returns`.`tds_amount`
`sales_returns`.`freight_charges`
`sales_returns`.`add_charges`
`sales_returns`.`sgst_amount`
`sales_returns`.`cgst_amount`
`sales_returns`.`igst_amount`
`sales_returns`.`cess_amount`
`sales_returns`.`payment_status`
`sales_returns`.`return_status`
`sales_returns`.`narration`
`sales_returns`.`receiver_name`
`sales_returns`.`receiver_contact_number`
`sales_returns`.`branch_id`
`sales_returns`.`finance_year_id`
`sales_returns`.`delete_status`
`sales_returns`.`created_at`
`sales_returns`.`user_id`
`sales_returns`.`updated_at`
`sales_returns`.`round_off`
`sales_returns`.`total_amount`
`sales_returns`.`posting_status`
`sales_settings`.*
`sales_settings`.`id`
`sales_settings`.`branch_id`
`sales_settings`.`price_base`
`sales_settings`.`discount_base`
`sales_settings`.`additional_discount_enabled`
`sales_settings`.`enable_scheme_discount`
`sales_settings`.`allow_negative_stock`
`sales_settings`.`default_payment_mode`
`sales_settings`.`default_terms_days`
`sales_settings`.`round_off_method`
`sales_settings`.`invoice_prefix`
`sales_settings`.`invoice_start_number`
`sales_settings`.`delete_status`
`sales_settings`.`created_at`
`sales_settings`.`updated_at`
`sales_targets`.*
`sales_targets`.`id`
`sales_targets`.`finance_year_id`
`sales_targets`.`branch_id`
`sales_targets`.`target_amount`
`sample_table`.*
`sample_table`.`id`
`sample_table`.`delete_status`
`sample_table`.`created_at`
`sample_table`.`updated_at`
`setting_allowed_ips`.*
`setting_allowed_ips`.`id`
`setting_allowed_ips`.`ip_address`
`setting_allowed_ips`.`description`
`setting_allowed_ips`.`is_active`
`setting_allowed_ips`.`created_at`
`setting_branch_details`.*
`setting_branch_details`.`id`
`setting_branch_details`.`branch_name`
`setting_branch_details`.`branch_code`
`setting_branch_details`.`address`
`setting_branch_details`.`city`
`setting_branch_details`.`pincode`
`setting_branch_details`.`state_id`
`setting_branch_details`.`country_id`
`setting_branch_details`.`contact_number`
`setting_branch_details`.`email`
`setting_branch_details`.`gstin`
`setting_branch_details`.`website`
`setting_branch_details`.`logo`
`setting_branch_details`.`dark_logo`
`setting_branch_details`.`light_logo`
`setting_branch_details`.`is_main_branch`
`setting_branch_details`.`delete_status`
`setting_branch_details`.`created_at`
`setting_branch_details`.`updated_at`
`setting_countries`.*
`setting_countries`.`id`
`setting_countries`.`country_name`
`setting_countries`.`short_name`
`setting_countries`.`is_default`
`setting_countries`.`delete_status`
`setting_countries`.`created_at`
`setting_countries`.`updated_at`
`setting_main_menu`.*
`setting_main_menu`.`id`
`setting_main_menu`.`main_menu`
`setting_main_menu`.`display_name`
`setting_main_menu`.`url`
`setting_main_menu`.`icon`
`setting_main_menu`.`sequence`
`setting_main_menu`.`is_voucher_entry`
`setting_main_menu`.`is_report`
`setting_main_menu`.`delete_status`
`setting_main_menu`.`created_at`
`setting_main_menu`.`updated_at`
`setting_states`.*
`setting_states`.`id`
`setting_states`.`state_name`
`setting_states`.`short_name`
`setting_states`.`delete_status`
`setting_states`.`is_default`
`setting_states`.`created_at`
`setting_states`.`updated_at`
`setting_sub_menu`.*
`setting_sub_menu`.`id`
`setting_sub_menu`.`sub_menu`
`setting_sub_menu`.`display_name`
`setting_sub_menu`.`mmenu_id`
`setting_sub_menu`.`is_master`
`setting_sub_menu`.`is_list`
`setting_sub_menu`.`is_voucher_entry`
`setting_sub_menu`.`is_report`
`setting_sub_menu`.`url`
`setting_sub_menu`.`sequence`
`setting_sub_menu`.`search_sequence`
`setting_sub_menu`.`delete_status`
`setting_sub_menu`.`created_at`
`setting_sub_menu`.`updated_at`
`subsidy_scheme_documents`.*
`subsidy_scheme_documents`.`id`
`subsidy_scheme_documents`.`scheme_id`
`subsidy_scheme_documents`.`doc_code`
`subsidy_scheme_documents`.`doc_name`
`subsidy_scheme_documents`.`is_mandatory`
`subsidy_scheme_documents`.`sequence_no`
`subsidy_scheme_documents`.`notes`
`subsidy_scheme_documents`.`branch_id`
`subsidy_scheme_documents`.`delete_status`
`subsidy_scheme_documents`.`created_at`
`subsidy_scheme_documents`.`updated_at`
`subsidy_schemes`.*
`subsidy_schemes`.`id`
`subsidy_schemes`.`scheme_name`
`subsidy_schemes`.`scheme_code`
`subsidy_schemes`.`description`
`subsidy_schemes`.`subsidy_type`
`subsidy_schemes`.`subsidy_rate`
`subsidy_schemes`.`subsidy_flat_amount`
`subsidy_schemes`.`cap_amount`
`subsidy_schemes`.`active_status`
`tally_posted_rows`.*
`tally_posted_rows`.`raw_row_id`
`tally_posted_rows`.`import_batch_id`
`tally_posted_rows`.`voucher_table`
`tally_posted_rows`.`voucher_id`
`tally_posted_rows`.`voucher_no`
`tally_posted_rows`.`created_at`
`tally_posting_issues`.*
`tally_posting_issues`.`id`
`tally_posting_issues`.`import_batch_id`
`tally_posting_issues`.`raw_row_id`
`tally_posting_issues`.`issue_code`
`tally_posting_issues`.`details`
`tally_posting_issues`.`created_at`
`tally_source_batches`.*
`tally_source_batches`.`import_batch_id`
`tally_source_batches`.`sheet_name`
`tally_source_batches`.`header_row_no`
`tally_source_batches`.`h1`
`tally_source_batches`.`h2`
`tally_source_batches`.`h3`
`tally_source_batches`.`h4`
`tally_source_batches`.`h5`
`tally_source_batches`.`h6`
`tally_source_batches`.`h7`
`tally_source_batches`.`h8`
`tally_source_batches`.`h9`
`tally_source_batches`.`h10`
`tally_source_batches`.`created_at`
`tally_source_raw10`.*
`tally_source_raw10`.`id`
`tally_source_raw10`.`import_batch_id`
`tally_source_raw10`.`sheet_name`
`tally_source_raw10`.`row_in_sheet`
`tally_source_raw10`.`c1`
`tally_source_raw10`.`c2`
`tally_source_raw10`.`c3`
`tally_source_raw10`.`c4`
`tally_source_raw10`.`c5`
`tally_source_raw10`.`c6`
`tally_source_raw10`.`c7`
`tally_source_raw10`.`c8`
`tally_source_raw10`.`c9`
`tally_source_raw10`.`c10`
`tally_source_raw10`.`created_at`
`tally_source_typed`.*
`tally_source_typed`.`id`
`tally_source_typed`.`import_batch_id`
`tally_source_typed`.`raw_row_id`
`tally_source_typed`.`txn_date`
`tally_source_typed`.`particulars`
`tally_source_typed`.`instrument_text`
`tally_source_typed`.`vch_type`
`tally_source_typed`.`voucher_type_id`
`tally_source_typed`.`vch_no`
`tally_source_typed`.`debit_amount`
`tally_source_typed`.`credit_amount`
`tally_source_typed`.`ledger_id`
`tally_source_typed`.`correspondent_ledger_id`
`tally_source_typed`.`is_ledger`
`tally_source_typed`.`is_main_ledger`
`tally_source_typed`.`is_main`
`tally_source_typed`.`is_correspondent`
`tally_source_typed`.`is_others`
`tally_source_typed`.`txn_date_forwardfill`
`tally_source_typed`.`vch_type_forwardfill`
`tally_source_typed`.`vch_no_forwardfill`
`tally_source_typed`.`main_ledger_name_ff`
`tally_source_typed`.`main_ledger_id_ff`
`tally_source_typed`.`is_pair_head`
`tally_source_typed`.`is_item`
`tally_source_typed`.`item_id`
`tally_source_typed`.`item_qty`
`tally_source_typed`.`rate_per_item`
`tally_source_typed`.`item_uom`
`tally_source_typed`.`item_name_key`
`tally_source_typed`.`ledger_type`
`tally_source_typed`.`created_at`
`tally_transactions`.*
`tally_transactions`.`id`
`tally_transactions`.`ledger_id`
`tally_transactions`.`voucher_type`
`tally_transactions`.`voucher_number`
`tally_transactions`.`voucher_date`
`tally_transactions`.`delete_status`
`tally_transactions`.`type`
`tally_transactions`.`amount`
`tally_transactions`.`narration`
`tally_transactions`.`branch_id`
`tally_transactions`.`created_at`
`tally_transactions`.`updated_at`
`tds_cumulative`.*
`tds_cumulative`.`id`
`tds_cumulative`.`vendor_id`
`tds_cumulative`.`ledger_id`
`tds_cumulative`.`section_code`
`tds_cumulative`.`finance_year_id`
`tds_cumulative`.`cumulative_amount`
`tds_cumulative`.`created_at`
`tds_cumulative`.`updated_at`
`tds_deductions`.*
`tds_deductions`.`id`
`tds_deductions`.`voucher_id`
`tds_deductions`.`voucher_type`
`tds_deductions`.`ledger_id`
`tds_deductions`.`vendor_id`
`tds_deductions`.`section_code`
`tds_deductions`.`amount`
`tds_deductions`.`narration`
`tds_deductions`.`finance_year_id`
`tds_deductions`.`branch_id`
`tds_deductions`.`voucher_date`
`tds_deductions`.`created_at`
`tds_deductions`.`delete_status`
`tds_deductions`.`deleted_by`
`tds_deductions`.`deleted_at`
`tds_master`.*
`tds_master`.`id`
`tds_master`.`section_code`
`tds_master`.`description`
`tds_master`.`applicable_on`
`tds_master`.`rate_percent`
`tds_master`.`threshold_per_txn`
`tds_master`.`threshold_annual`
`tds_master`.`resident_only`
`tds_master`.`is_active`
`tds_master`.`created_at`
`tds_master`.`updated_at`
`transaction_additional_charges`.*
`transaction_additional_charges`.`id`
`transaction_additional_charges`.`voucher_type_id`
`transaction_additional_charges`.`transaction_id`
`transaction_additional_charges`.`ledger_id`
`transaction_additional_charges`.`amount`
`transaction_additional_charges`.`tax_percentage`
`transaction_additional_charges`.`is_proportionate`
`transaction_additional_charges`.`branch_id`
`transaction_additional_charges`.`delete_status`
`transaction_additional_charges`.`created_at`
`transaction_additional_charges`.`updated_at`
`transaction_expenditure_categories`.*
`transaction_expenditure_categories`.`id`
`transaction_expenditure_categories`.`title`
`transaction_expenditure_categories`.`description`
`transaction_expenditure_categories`.`account_group_id`
`transaction_expenditure_categories`.`active_status`
`transaction_expenditure_categories`.`delete_status`
`transaction_expenditure_categories`.`created_at`
`transaction_expenditure_categories`.`updated_at`
`transaction_expenditure_vouchers`.*
`transaction_expenditure_vouchers`.`id`
`transaction_expenditure_vouchers`.`voucher_no`
`transaction_expenditure_vouchers`.`voucher_date`
`transaction_expenditure_vouchers`.`ledger_id`
`transaction_expenditure_vouchers`.`ledger_account_id`
`transaction_expenditure_vouchers`.`amount`
`transaction_expenditure_vouchers`.`gst_amount`
`transaction_expenditure_vouchers`.`is_gst_applicable`
`transaction_expenditure_vouchers`.`expenditure_category_id`
`transaction_expenditure_vouchers`.`branch_id`
`transaction_expenditure_vouchers`.`instrument_type`
`transaction_expenditure_vouchers`.`instrument_number`
`transaction_expenditure_vouchers`.`narration`
`transaction_expenditure_vouchers`.`delete_status`
`transaction_expenditure_vouchers`.`created_at`
`transaction_expenditure_vouchers`.`updated_at`
`transaction_expenditure_vouchers`.`expense_date`
`transaction_expenditure_vouchers`.`expense_type`
`transaction_payment_vouchers_expense`.*
`transaction_payment_vouchers_expense`.`id`
`transaction_payment_vouchers_expense`.`voucher_type_id`
`transaction_payment_vouchers_expense`.`voucher_no`
`transaction_payment_vouchers_expense`.`voucher_date`
`transaction_payment_vouchers_expense`.`ledger_id`
`transaction_payment_vouchers_expense`.`ledger_account_id`
`transaction_payment_vouchers_expense`.`instrument_type`
`transaction_payment_vouchers_expense`.`instrument_number`
`transaction_payment_vouchers_expense`.`amount`
`transaction_payment_vouchers_expense`.`expense_head`
`transaction_payment_vouchers_expense`.`gst`
`transaction_payment_vouchers_expense`.`branch_id`
`transaction_payment_vouchers_expense`.`user_id`
`transaction_payment_vouchers_expense`.`narration`
`transaction_payment_vouchers_expense`.`delete_status`
`transaction_payment_vouchers_expense`.`created_at`
`transaction_payment_vouchers_expense`.`updated_at`
`transaction_payment_vouchers_expense`.`payment_date`
`transaction_payment_vouchers_expense`.`created_by`
`transaction_payment_vouchers_expense`.`modified_by`
`transaction_payment_vouchers_expense`.`finance_year_id`
`transaction_payment_vouchers_expense`.`bank_name`
`transaction_payment_vouchers_expense`.`reference_id`
`transaction_payment_vouchers_expense`.`reference`
`transaction_receipt_vouchers_old`.*
`transaction_receipt_vouchers_old`.`id`
`transaction_receipt_vouchers_old`.`voucher_no`
`transaction_receipt_vouchers_old`.`voucher_date`
`transaction_receipt_vouchers_old`.`ledger_id`
`transaction_receipt_vouchers_old`.`ledger_account_id`
`transaction_receipt_vouchers_old`.`instrument_type`
`transaction_receipt_vouchers_old`.`instrument_number`
`transaction_receipt_vouchers_old`.`amount`
`transaction_receipt_vouchers_old`.`tds_amount`
`transaction_receipt_vouchers_old`.`branch_id`
`transaction_receipt_vouchers_old`.`narration`
`transaction_receipt_vouchers_old`.`delete_status`
`transaction_receipt_vouchers_old`.`created_at`
`transaction_receipt_vouchers_old`.`updated_at`
`transaction_receipt_vouchers_old`.`received_date`
`transaction_receipt_vouchers_old`.`user_id`
`transaction_receipt_vouchers_old`.`finance_year_id`
`transaction_receipt_vouchers_old`.`bank_name`
`transaction_receipt_vouchers_old`.`reference_id`
`universal_discount_rules`.*
`universal_discount_rules`.`id`
`universal_discount_rules`.`rule_name`
`universal_discount_rules`.`rule_scope`
`universal_discount_rules`.`operator`
`universal_discount_rules`.`value`
`universal_discount_rules`.`target_id`
`universal_discount_rules`.`customer_segment_id`
`universal_discount_rules`.`coupon_code`
`universal_discount_rules`.`min_qty`
`universal_discount_rules`.`min_amount`
`universal_discount_rules`.`valid_from`
`universal_discount_rules`.`valid_to`
`universal_discount_rules`.`priority`
`universal_discount_rules`.`combine_method`
`universal_discount_rules`.`is_active`
`universal_discount_rules`.`branch_id`
`universal_discount_rules`.`delete_status`
`universal_discount_rules`.`created_at`
`universal_discount_rules`.`updated_at`
`user_branches`.*
`user_branches`.`id`
`user_branches`.`user_id`
`user_branches`.`branch_id`
`user_branches`.`is_active`
`user_branches`.`is_default`
`user_branches`.`delete_status`
`user_branches`.`created_at`
`user_branches`.`updated_at`
`user_details`.*
`user_details`.`id`
`user_details`.`user_email`
`user_details`.`username`
`user_details`.`password_hash`
`user_details`.`role_id`
`user_details`.`emp_id`
`user_details`.`default_branch_id`
`user_details`.`financial_year_id`
`user_details`.`delete_status`
`user_details`.`created_at`
`user_details`.`updated_at`
`user_favorites`.*
`user_favorites`.`id`
`user_favorites`.`user_id`
`user_favorites`.`submenu_id`
`user_favorites`.`is_voucher_entry`
`user_favorites`.`sort_order`
`user_favorites`.`created_at`
`user_favorites`.`updated_at`
`user_financial_years`.*
`user_financial_years`.`id`
`user_financial_years`.`user_id`
`user_financial_years`.`financial_year_id`
`user_financial_years`.`is_active`
`user_financial_years`.`delete_status`
`user_financial_years`.`created_at`
`user_financial_years`.`updated_at`
`user_permissions`.*
`user_permissions`.`id`
`user_permissions`.`role_id`
`user_permissions`.`menu_id`
`user_permissions`.`submenu_id`
`user_permissions`.`can_add`
`user_permissions`.`can_edit`
`user_permissions`.`can_delete`
`user_permissions`.`can_view`
`user_permissions`.`branch_id`
`user_permissions`.`delete_status`
`user_permissions`.`created_at`
`user_permissions`.`updated_at`
`user_roles`.*
`user_roles`.`id`
`user_roles`.`role_name`
`user_roles`.`dashboard_link`
`user_roles`.`dashboard_link_lock_screen`
`user_roles`.`is_super_admin`
`user_roles`.`branch_id`
`user_roles`.`delete_status`
`user_roles`.`created_at`
`user_roles`.`updated_at`
`users`.*
`users`.`id`
`users`.`user_code`
`users`.`name`
`users`.`username`
`users`.`password`
`users`.`email`
`users`.`mobile`
`users`.`role_id`
`users`.`branch_id`
`users`.`status`
`users`.`last_login`
`users`.`created_by`
`users`.`created_at`
`users`.`updated_at`
`users`.`delete_status`
`voucher_additional_charges`.*
`voucher_additional_charges`.`id`
`voucher_additional_charges`.`voucher_type_id`
`voucher_additional_charges`.`ledger_id`
`voucher_additional_charges`.`tax_proportionate_flag`
`voucher_additional_charges`.`tax_percentage_override`
`voucher_additional_charges`.`hsn_sac_code`
`voucher_additional_charges`.`remarks`
`voucher_additional_charges`.`branch_id`
`voucher_additional_charges`.`created_at`
`voucher_additional_charges`.`updated_at`
`voucher_numbering_config`.*
`voucher_numbering_config`.`id`
`voucher_numbering_config`.`voucher_type_id`
`voucher_numbering_config`.`financial_year_id`
`voucher_numbering_config`.`branch_id`
`voucher_numbering_config`.`starting_number`
`voucher_numbering_config`.`number_width`
`voucher_numbering_config`.`prefix_zero`
`voucher_numbering_config`.`restart_periodicity`
`voucher_numbering_config`.`restart_applicable_from`
`voucher_numbering_config`.`restart_number`
`voucher_numbering_config`.`prefix_applicable_from`
`voucher_numbering_config`.`prefix_text`
`voucher_numbering_config`.`suffix_applicable_from`
`voucher_numbering_config`.`suffix_text`
`voucher_numbering_config`.`created_at`
`voucher_numbering_config`.`updated_at`
`voucher_series_master`.*
`voucher_series_master`.`id`
`voucher_series_master`.`voucher_code`
`voucher_series_master`.`branch_id`
`voucher_series_master`.`financial_year_id`
`voucher_series_master`.`prefix`
`voucher_series_master`.`suffix`
`voucher_series_master`.`current_number`
`voucher_series_master_old`.*
`voucher_series_master_old`.`id`
`voucher_series_master_old`.`voucher_type`
`voucher_series_master_old`.`branch_id`
`voucher_series_master_old`.`financial_year_id`
`voucher_series_master_old`.`prefix`
`voucher_series_master_old`.`suffix`
`voucher_series_master_old`.`current_number`
`voucher_taxes`.*
`voucher_taxes`.`id`
`voucher_taxes`.`voucher_type`
`voucher_taxes`.`voucher_id`
`voucher_taxes`.`tax_code`
`voucher_taxes`.`tax_name`
`voucher_taxes`.`tax_rate`
`voucher_taxes`.`tax_amount`
`voucher_taxes`.`ledger_id`
`voucher_taxes`.`branch_id`
`voucher_taxes`.`created_at`
`voucher_taxes`.`updated_at`
`voucher_taxes`.`taxable_value`
`voucher_taxes`.`charge_type`
`voucher_taxes`.`additional_charge_id`
`voucher_type_ledger_mappings`.*
`voucher_type_ledger_mappings`.`id`
`voucher_type_ledger_mappings`.`voucher_type_id`
`voucher_type_ledger_mappings`.`voucher_type`
`voucher_type_ledger_mappings`.`ledger_id`
`voucher_type_ledger_mappings`.`ledger_key_id`
`voucher_type_ledger_mappings`.`is_tds_applicable`
`voucher_type_ledger_mappings`.`narration_template`
`voucher_type_ledger_mappings`.`remarks`
`voucher_type_ledger_mappings`.`voucher_flow_type`
`voucher_type_ledger_mappings`.`sort_order`
`voucher_type_ledger_mappings`.`entry_side`
`voucher_type_ledger_mappings`.`is_default`
`voucher_type_ledger_mappings`.`delete_status`
`voucher_type_ledger_mappings`.`created_at`
`voucher_type_ledger_mappings`.`updated_at`
`voucher_types`.*
`voucher_types`.`id`
`voucher_types`.`voucher_code`
`voucher_types`.`title`
`voucher_types`.`abbreviation`
`voucher_types`.`primary_voucher`
`voucher_types`.`numbering_method`
`voucher_types`.`retain_original_number`
`voucher_types`.`is_optional`
`voucher_types`.`is_primary_voucher`
`voucher_types`.`is_posting`
`voucher_types`.`is_default`
`voucher_types`.`update_item_transaction`
`voucher_types`.`allow_narration`
`voucher_types`.`track_additional_costs`
`voucher_types`.`auto_print_on_save`
`voucher_types`.`auto_whatsapp_on_save`
`voucher_types`.`entry_side`
`voucher_types`.`is_active`
`voucher_types`.`sort_order`
`voucher_types`.`primary_voucher_type_id`
`voucher_types`.`created_at`
`voucher_types`.`updated_at`
`voucher_types_old`.*
`voucher_types_old`.`id`
`voucher_types_old`.`code`
`voucher_types_old`.`title`
`voucher_types_old`.`abbreviation`
`voucher_types_old`.`voucher_mode`
`voucher_types_old`.`numbering_method`
`voucher_types_old`.`retain_original_number`
`voucher_types_old`.`is_optional`
`voucher_types_old`.`allow_narration`
`voucher_types_old`.`track_additional_costs`
`voucher_types_old`.`auto_print_on_save`
`voucher_types_old`.`auto_whatsapp_on_save`
`voucher_types_old`.`nature`
`voucher_types_old`.`is_custom`
`voucher_types_old`.`is_active`
`voucher_types_old`.`sort_order`
`voucher_types_old`.`primary_voucher_type_id`
`voucher_types_old`.`created_at`
`voucher_types_old`.`updated_at`
`whatsapp_settings`.*
`whatsapp_settings`.`id`
`whatsapp_settings`.`provider`
`whatsapp_settings`.`api_url`
`whatsapp_settings`.`api_key`
`whatsapp_settings`.`auth_token`
`whatsapp_settings`.`sender_number`
`whatsapp_settings`.`is_active`
`whatsapp_settings`.`branch_id`
`whatsapp_settings`.`created_at`
`whatsapp_settings`.`updated_at`
`yearly_financial_summary`.*
`yearly_financial_summary`.`summary_year`
`yearly_financial_summary`.`branch_id`
`yearly_financial_summary`.`total_sales`
`yearly_financial_summary`.`total_purchases`
`yearly_financial_summary`.`total_receipts`
`yearly_financial_summary`.`total_payments`
`yearly_financial_summary`.`credit_note`
`yearly_financial_summary`.`debit_note`
`yearly_financial_summary`.`finance_year_id`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
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_job_parts
cnc_jobs
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
item_effective_pricing
item_transactions
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
journal_voucher_lines
journal_vouchers
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_voucher_allocations
payment_vouchers
plant_details
posting_audit_log
posting_control
posting_period_control
postings_audit_log
pricing_recompute_queue
purchase_entries
purchase_entries_old
purchase_entry_items
purchase_entry_items_old
purchase_order_items
purchase_orders
purchase_return_items
purchase_return_items_old
purchase_return_old
purchase_returns
quotation_entries
quotation_entry_items
receipt_sales_mapping
receipt_voucher_allocations
receipt_vouchers
report_data_entries
sales_entries
sales_entry_items
sales_invoice_discounts
sales_invoice_exchange
sales_invoice_other_discounts
sales_invoice_subsidy
sales_return_items
sales_return_reasons
sales_returns
sales_settings
sales_targets
sample_table
setting_allowed_ips
setting_branch_details
setting_countries
setting_main_menu
setting_states
setting_sub_menu
subsidy_scheme_documents
subsidy_schemes
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
user_branches
user_details
user_favorites
user_financial_years
user_permissions
user_roles
users
voucher_additional_charges
voucher_numbering_config
voucher_series_master
voucher_series_master_old
voucher_taxes
voucher_type_ledger_mappings
voucher_types
voucher_types_old
whatsapp_settings
yearly_financial_summary
SQL query on database
surena_edbroad_old
: