dev.surenasolutions.in / 127.0.0.1 / surena_crm / items

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.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

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.

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.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

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

Press Ctrl+Enter to execute query

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

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

			id	item_name	alias_name	item_code	packing	hsn_sac_id	ledger_id	item_cat_id	godown_id	uom_id	brand_id	company_id	item_type	valuation_method	standard_cost	price_basis	mrp	profit_logic	price_type	profit_value	price sale_price	average_price	last_purchase_price	purchase_price	sale_price_delete	tax_rate	stock_quantity_del	opening_value_del	max_qty	min_qty	reorder_days	low_stock_alert	is_subsidy_item	is_edit_mrp	branch_id	item_name_key	name_norm 1	aliases_norm	delete_status	created_at	updated_at
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3539	3539	ZxZ		SDA		27	0	59	29	9	0	0			14.00		12.00	Markup	Percentage	20.00	16.80	0.00	0.00	0.00	0.00	18.00	0	0	0	0	0	0	N	N	1	ZXZ	zxz	NULL	0	2026-03-10 13:42:38	NULL
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3410	3410	WL400010OOOOKWH METER CL1 RS485		3410	NULL	85	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	WL400010OOOOKWHMETERCL1RS485	wl400010ooookwhmetercl1rs485	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3493	3493	Winkler Sprinkler 3/4''		3493	NULL	58	0	1	0	1	0	0	NULL	WAC	0.00	MRP	35.71	NULL	NULL	0.00	35.71	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	WINKLERSPRINKLER34	winklersprinkler34	NULL	0	0000-00-00 00:00:00	2025-08-14 05:18:49
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3492	3492	Winkler Jet 1/2"		3492	NULL	58	0	1	0	1	0	0	NULL	WAC	0.00	MRP	35.71	NULL	NULL	0.00	35.71	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	WINKLERJET12	winklerjet12	NULL	0	0000-00-00 00:00:00	2025-08-14 05:18:49
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3409	3409	WIDE BAND COIL MK1 200-440V		3409	NULL	80	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	WIDEBANDCOILMK1200440V	widebandcoilmk1200440v	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3408	3408	Water Tec Floot Valve 1"		3408	NULL	3	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	WATERTECFLOOTVALVE1	watertecflootvalve1	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3407	3407	VERTIK - 178 ART BASIN WHITE BELL		3407	NULL	44	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	VERTIK178ARTBASINWHITEBELL	vertik178artbasinwhitebell	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3406	3406	VERTICAL TERMINALS 800-1600A SL93282OOOO		3406	NULL	80	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	VERTICALTERMINALS8001600ASL93282OOOO	verticalterminals8001600asl93282oooo	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3405	3405	VER. TERMINALS 800/1000 C & 630-1250 SL93281OOOO		3405	NULL	80	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	VERTERMINALS8001000C6301250SL93281OOOO	verterminals8001000c6301250sl93281oooo	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3404	3404	Vectus Smart White 1000ltr Tank		3404	NULL	41	0	1	0	1	0	0	NULL	WAC	0.00	MRP	5084.75	NULL	NULL	0.00	5084.75	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	VECTUSSMARTWHITE1000LTRTANK	vectussmartwhite1000ltrtank	NULL	0	0000-00-00 00:00:00	2025-08-14 05:18:49
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3403	3403	VAF + PF METER CI 1 WL411010OOOO		3403	NULL	85	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	VAF+PFMETERCI1WL411010OOOO	vafpfmeterci1wl411010oooo	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3402	3402	VAF + PF METER CI 0.5 WL411020OOOO L&T		3402	NULL	85	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	VAF+PFMETERCI05WL411020OOOOLT	vafpfmeterci05wl411020oooolt	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3401	3401	Under-Voltage Release 240V AC SL92720BOOO		3401	NULL	80	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	UNDERVOLTAGERELEASE240VACSL92720BOOO	undervoltagerelease240vacsl92720booo	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3400	3400	Un-Co Module Acb & Mccb Cl908520000		3400	NULL	80	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	UNCOMODULEACBMCCBCL908520000	uncomoduleacbmccbcl908520000	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3399	3399	TVM 3P4W 240V10-60A 1.0 WR301BC7D10 L&T		3399	NULL	83	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TVM3P4W240V1060A10WR301BC7D10LT	tvm3p4w240v1060a10wr301bc7d10lt	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3495	3495	TVM 3P4W 240V10-60A 1.0 WR301BC7D10		3495	NULL	83	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TVM3P4W240V1060A10WR301BC7D10	tvm3p4w240v1060a10wr301bc7d10	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3398	3398	TVM 3P4W 240V 10-40A 1.0A WR301BC6D20		3398	NULL	83	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TVM3P4W240V1040A10AWR301BC6D20	tvm3p4w240v1040a10awr301bc6d20	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3397	3397	TPN 8W DD IP43 DBTPN008DD		3397	NULL	78	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TPN8WDDIP43DBTPN008DD	tpn8wddip43dbtpn008dd	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3396	3396	TPN 6W DD IP43 DBTPN006DD		3396	NULL	78	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TPN6WDDIP43DBTPN006DD	tpn6wddip43dbtpn006dd	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3395	3395	TPN 4W DD IP43 DBTPN004DD		3395	NULL	78	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TPN4WDDIP43DBTPN004DD	tpn4wddip43dbtpn004dd	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3394	3394	Towel Rod S S		3394	NULL	51	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TOWELRODSS	towelrodss	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3393	3393	TOPLINE NEXT FLUSHING CISTERN WHITE BELL		3393	NULL	40	0	1	0	1	0	0	NULL	WAC	0.00	MRP	380.00	NULL	NULL	0.00	380.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TOPLINENEXTFLUSHINGCISTERNWHITEBELL	toplinenextflushingcisternwhitebell	NULL	0	0000-00-00 00:00:00	2025-08-14 05:18:49
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3392	3392	Three Phase ACCL - 63A/63A AUCL03063063		3392	NULL	76	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	THREEPHASEACCL63A63AAUCL03063063	threephaseaccl63a63aaucl03063063	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3391	3391	Three Phase ACCL-40A/40A AUCL03040040		3391	NULL	73	0	1	0	1	0	0	NULL	WAC	0.00	MRP	1500.00	NULL	NULL	0.00	25.00	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	THREEPHASEACCL40A40AAUCL03040040	threephaseaccl40a40aaucl03040040	NULL	0	0000-00-00 00:00:00	2026-03-14 10:26:18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 3390	3390	TFT -1210 P.T.F.E. THREAD SEAL TAPE		3390	NULL	37	0	1	0	1	0	0	NULL	WAC	0.00	MRP	25.42	NULL	NULL	0.00	25.42	0.00	0.00	0.00	0.00	0.00	0	0	0	0	5	0	N	N	1	TFT1210PTFETHREADSEALTAPE	tft1210ptfethreadsealtape	NULL	0	0000-00-00 00:00:00	2025-08-14 05:18:49

Customise appearance of the navigation panel.

Customise the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customise browse mode.

Navigation panel

Customise appearance of the navigation panel.

Navigation tree

Customise the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customise browse mode.