ai.surenasolutions.in / 127.0.0.1 / sgm_crm / ledger_details

There are no favorite tables.

New
aiskgl
competitive_exam
- competitive_exam
- competitive_exam_qa
edbroad
- ai
  - edbroad_ai
  - edbroad_ai_sumanth
- edbroad_phonepe_standard
fee_fay_india
information_schema
mysql
omr
- omr_platform
- omr_web
performance_schema
phpmyadmin
rajkamal_crm
- rajkamal_crm
- rajkamal_crm_schema_backup_20260919
scoobyai
sgm_crm
surena
- crm
  - surena_crm
  - surena_crm_control
- support
  - surena_support
  - surena_support_sjcebt
test
whatsapp_platform

Customize 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`).
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.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize 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 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 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 display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

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 :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (3357 total, Query took 0.0032 seconds.) [tags: ... - ...]

SELECT * FROM `ledger_details` ORDER BY `tags` ASC

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			id	ledger_name	alias_name	primary_group_id	reverse_charge	is_gst_applicable	hsn_code_id	trade_name	contact_person_name	mail_to	address	city	pincode	state_id	district_id	country_id	customer_type_id party_type	caste_category	gender	gst_verified	gst_registration_types_id	gst_number	pan_number	company_contact_number	whatsapp_number	mobile	email_id	website	tags 1	party_type_id_del	party_cat_id customer_segment	parent_group_id	account_group_id 1 - Customer, 2 - Supplier	led_group_id ledger_groups	credit_days	credit_limit	auto_block_on_overdue	delivery_source	delivery_source_id	branch_id	delete_status	module	ledger_key_id	voucher_type_id	tds_section_code	ledger_type	sale_order	charge_kind	is_cash_ledger_override_id	system_ledger_applies_to	is_carrier_agent	is_default_carrier_agent	finance_year_id	created_by	modified_by	created_at	updated_at
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3072	3072	Sumithramma W/o. Late M Basappa		NULL	NA	NA	NULL	Sumithramma W/o. Late M Basappa	NULL	NULL	Kunibelekere Harihar	Davangere	577601	29	13	1	6	0		NO	3				8884531691	8884531691			NULL	0	5	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		Y	N	13	0	0	2026-05-18 15:39:41	2026-05-20 16:13:09
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3328	3328	Sharanayya		NULL	NA	NA	NULL	Sharanayya	NULL	NULL		Shivamogga	57702	29	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	2	0	2026-08-19 11:57:49	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3073	3073	SGM technologies, Kaimara Branch		NULL	NA	NA	NULL	SGM technologies, Kaimara Branch	NULL	NULL	Kaimara	Bhadravathi	577301	29	26	1	2		NULL	NO	3				9886503315	9886503315			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		Y	N	13	0	0	2026-05-23 17:03:54	2026-06-01 11:08:42
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3329	3329	Donation		NULL	NO	NO	NULL	Donation	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	1		NULL	NA	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	7	0	7	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EXPENSE	NA	NULL	N		N	N	13	2	0	2026-08-19 12:20:46	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3074	3074	Kariyappa		NULL	NA	NA	NULL	Kariyappa	NULL	NULL	Modadakere	holalkere	577518	29	11	1	6		NULL	NO	3				9535863947	9535863947			NULL	0	5	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		Y	N	13	0	0	2026-05-23 17:15:44	2026-05-23 17:16:18
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3330	3330	Temple (seva Trust)		NULL	NA	NA	NULL	Temple (seva Trust)	NULL	NULL	temple	Shivamogga	577202	29	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	2	0	2026-08-19 12:22:14	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3075	3075	K.P Jagannath S/o. Channabasappa Gowda		NULL	NA	NA	NULL	K.P Jagannath S/o. Channabasappa Gowda	NULL	NULL	Kyasinakere	honnali	577224	29	13	1	6	19	Male	NO	3				9900155987	9900155987			NULL	0	5	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		N	N	13	0	0	2026-05-25 17:12:36	2026-07-22 11:24:10
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3331	3331	Service Charges Paid		NULL	YES	YES	22250	Service Charges Paid	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	1		NULL	NA	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	7	0	7	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EXPENSE	NA	NULL	N		N	N	13	2	0	2026-08-19 12:27:54	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3076	3076	Gowtham M. S/o. Manjunath		NULL	NA	NA	NULL	Gowtham M. S/o. Manjunath	NULL	NULL	Gajanur	Shimoga	577202	29	26	1	6	0		NO	3				9590038873	9590038873			NULL	0	5	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		Y	N	13	0	0	2026-05-26 10:56:24	2026-05-27 17:55:02
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3332	3332	SURESH(AUTO)		NULL	NA	NA	NULL	SURESH(AUTO)	NULL	NULL	SGM	Shimoga	577202	29	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	5	5	2026-08-19 12:46:14	2026-08-19 15:48:51
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3077	3077	OMKARANNA		NULL	NA	NA	NULL	OMKARANNA	NULL	NULL	Halakkanahalu	Davangere	577213	29	13	1	6		NULL	NO	3				7026689878	7026689878			NULL	0	5	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		Y	N	13	0	0	2026-05-26 15:34:34	2026-05-26 15:34:55
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3333	3333	Kamal Trading Corporation		NULL	NO	NO	NULL	Kamal Trading Corporation	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	1		NULL	NA	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	7	0	7	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EXPENSE	NA	NULL	N		N	N	13	2	0	2026-08-19 13:02:30	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3078	3078	SADASHIVAPPA S/O SANNARANGAPPA		NULL	NA	NA	NULL	SADASHIVAPPA S/O SANNARANGAPPA	NULL	NULL	Adanur	Chitradurga	577526	29	11	1	6	0		NO	3				9902857354	9902857354			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	CONFIRM	NULL	N		N	N	13	0	0	2026-05-27 16:12:22	2026-05-27 16:13:46
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3334	3334	Nurula (auto Driver)		NULL	NA	NA	NULL	Nurula (auto Driver)	NULL	NULL	auto driver	Shivamogga	577202	0	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	2	0	2026-08-19 13:06:13	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3079	3079	PREM KUMAR H M S/O H M MAHESHWARAPPA		NULL	NA	NA	NULL	PREM KUMAR H M S/O H M MAHESHWARAPPA	NULL	NULL	7 TH CROSS KRUSHI NAGAR NAVLE	Shimoga	577204	29	26	1	6	19	Male	NO	3				9886393096	9886393096			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	CONFIRM	NULL	N		Y	N	13	0	0	2026-05-29 16:05:45	2026-05-29 16:59:01
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3335	3335	Employee Wages		NULL	NO	NO	NULL	Employee Wages	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	1		NULL	NA	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	0	NULL	7	0	7	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EXPENSE	NA	NULL	N		N	N	13	2	0	2026-08-19 13:17:27	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3080	3080	THIPPESH GOWDRU		NULL	NA	NA	NULL	THIPPESH GOWDRU	NULL	NULL	MARAVANJJI (V) CHANNAGIRI TALUK DVG (D)	CHANNAGIRI	577213	29	13	1	8	0		NO	3				9449580160	9449580160			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	CONFIRM	NULL	N		Y	N	13	0	0	2026-05-30 13:41:52	2026-05-30 13:42:44
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3336	3336	Krishnamurthy (employee)		NULL	NA	NA	NULL	Krishnamurthy (employee)	NULL	NULL	employee	Shivamogga	577202	29	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	2	0	2026-08-19 13:19:03	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3081	3081	SHIVANANDAPPA IRAPPA KABBUR		NULL	NA	NA	NULL	SHIVANANDAPPA IRAPPA KABBUR	NULL	NULL	MAKARAVALLI VILLAGE, SHESHAGIRI POST	Haveri	581102	29	17	1	6	0		NO	3				6363151036	6363151036			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		N	N	13	0	0	2026-06-01 16:18:32	2026-06-01 16:19:31
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3337	3337	Madhana (worker)		NULL	NA	NA	NULL	Madhana (worker)	NULL	NULL	worker	Shivamogga	577202	29	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	2	0	2026-08-19 13:31:07	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 10	10	Cash		19	NO	NO	NULL	Cash	NULL	NULL	Karnataka 577201, India	NULL	577201	29	26	1	0			NO	0		NULL	NULL		NULL	NULL	NULL	NULL	0	0	3	0	19	NULL	0	0	NA	0	1	0	NULL	0	0	NULL	CASH	REQUEST	NULL	N	["Sales","Purchase","Payment","Receipt","Contra","...	N	N	2	0	0	2026-01-26 18:28:36	2026-08-28 16:57:56
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3082	3082	KAMALAMMA BASAVANTHAPPA KABBUR		NULL	NA	NA	NULL	KAMALAMMA BASAVANTHAPPA KABBUR	NULL	NULL	MAKARVALLI VILLAGE, SHESHAGIRI POST	Haveri	581102	29	17	1	6	0		NO	3				6363151036	6363151036			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	REQUEST	NULL	N		N	N	13	0	0	2026-06-01 16:27:05	2026-06-01 16:31:49
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3338	3338	Chandan		NULL	NA	NA	NULL	Chandan	NULL	NULL	auto	Shivamogga	577202	29	0	1	1		NULL	NA	NULL	NULL	NULL	NULL			NULL	NULL	NULL	0	NULL	4	0	4	NULL	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	EMPLOYEE	NA	NULL	N		N	N	13	2	0	2026-08-19 13:36:14	NULL
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3083	3083	SANJAY S/O ESHWARAPPA		NULL	NA	NA	NULL	SANJAY S/O ESHWARAPPA	NULL	NULL	KANASINAKATTE VILLAGE BHADRAVATHI TALUK	Shimoga	577227	29	26	1	6	0		NO	3				9480577413	9480577413			NULL	0	7	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	CONFIRM	NULL	N		Y	N	13	0	0	2026-06-03 16:20:36	2026-06-03 16:21:32
Edit	Copy	Delete DELETE FROM ledger_details WHERE `ledger_details`.`id` = 3339	3339	SARVAMANGALAMMA WO LATE M B BASAVARAJ		NULL	NA	NA	NULL	SARVAMANGALAMMA WO LATE M B BASAVARAJ	NULL	NULL	Manchenahalli (v) Chikkaballapura	Chikkaballapura	561211	29	0	1	6	19	Female	NO	3				9945081994	9945081994			NULL	0	1	NULL	1	28	0	0	0	NA	NULL	1	0	NULL	NULL	NULL	NULL	DEBTOR	CONFIRM	NULL	N		Y	N	13	4	0	2026-08-19 13:50:17	2026-08-19 13:50:49

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view