jay-mis.com / 127.0.0.1 / madeena_intend / v_items_full

There are no favorite tables.

New
anud
- anud_intend
- anud_sales
information_schema
madeena
- madeena_intend
- madeena_sales
mashriq_intend
mysql
performance_schema
phpmyadmin
portal_db
stock_db
test
weone_stock_db

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

Current selection does not contain a unique column. Grid edit, Edit, Copy and Delete features may result in undesired behavior.

Showing rows 0 - ...

(Query took 0.0009 seconds.)

SELECT * FROM `v_items_full`

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

Filter rows:

			id	material	uom	description	buyer	vendor_code	vendor_name	group2	category	avg_cost	msp	msp_gp	pos	pos_gp	stock_qty	stock_value	avg_sale_qty_day	max_qty	last_grn_date	last_intercompany_date	aging_0_30	aging_30_60	aging_60_90	aging_90_plus	slow_moving_value	inventory_bin	damage_bin	inventory_bin_value	damage_bin_value	movement_status	is_oos	overstock_qty	overstock_value
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480559	480559	2000055	EA	TRAY PRESTIGE 1016 W/LID 1016/360 1000pc	SIRAJUDHEEN	102497	PRESTIGE PACKING INDUSTRY CO.	GROCERY NON FOOD	ALUMINIUM TRAYS & FO	128.3100	128.3100	0.000000	145.0000	0.115103	12.000	1539.72	0.044	0.010	2026-05-30	NULL	0.00	0.00	0.00	1539.72	1539.72	0.000	0.000	0.0000000	0.0000000	slow	0	11.990	1538.436900000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480560	480560	2000057	CAR	NIVEA BODY COCOA LOTION 26250ml 70601	RETAIL	102044	AHMED MOHAMMED ABDUL WAHAB NAGI &SO	GROCERY NON FOOD	SKIN CARE	139.4400	141.3600	0.013582	151.0000	0.076556	0.500	69.72	0.023	0.098	2026-08-21	NULL	0.00	69.72	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	moderate	0	0.402	56.054880000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480561	480561	2000059	CAR	FANTA STRAWBERY CAN 30*250ML	SIRAJUDHEEN	102519	COCA COLA BOTTLING COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	39.0000	39.3000	0.007634	46.0900	0.153829	38.000	1482.00	0.511	6.000	2026-09-16	NULL	1482.00	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	moderate	0	32.000	1248.000000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480562	480562	2000060	CAR	FANTA CITRUS CAN 30*250ml	SIRAJUDHEEN	102519	COCA COLA BOTTLING COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	39.6000	43.5000	0.089655	48.0400	0.175687	34.033	1347.71	0.356	5.056	2026-09-16	NULL	1188.00	0.00	0.00	159.71	159.71	0.000	12.000	0.0000000	475.2000000	slow	0	28.977	1147.489200000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480563	480563	2000061	CAR	DEW DIET CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	35.7600	35.6500	-0.003086	40.8700	0.125031	56.208	2010.00	0.965	11.000	2026-10-13	NULL	1430.40	579.60	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	moderate	0	45.208	1616.638080000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480564	480564	2000062	CAR	SHANI CAN 30*150gm	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	41.7000	41.7500	0.001198	44.3000	0.058691	15.000	625.50	0.278	3.000	2026-09-02	NULL	0.00	625.50	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	moderate	0	12.000	500.400000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480565	480565	2000063	CAR	ALSI FIFA MIXED BERRIES 30*250ml	SIRAJUDHEEN	102017	AL ESAYI DISTRIBUTION COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	27.6000	28.0000	0.014286	32.0000	0.137500	14.067	388.25	0.044	7.272	2026-05-19	NULL	0.00	0.00	0.00	388.25	388.25	0.000	0.000	0.0000000	0.0000000	slow	0	6.795	187.542000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480566	480566	2000064	CAR	COCA COLA CAN 24*320ml	SIRAJUDHEEN	102519	COCA COLA BOTTLING COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	43.9200	44.0000	0.001818	46.0500	0.046254	1115.717	49002.29	21.978	268.000	2026-09-29	2024-10-31	22838.40	26163.89	0.00	0.00	0.00	0.000	10.000	0.0000000	439.2000000	fast	0	847.717	37231.730640000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480567	480567	2000065	CAR	COCA COLA DIET CAN 24*320ml	SIRAJUDHEEN	102519	COCA COLA BOTTLING COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	44.1600	44.0000	-0.003636	50.0000	0.116800	113.208	4999.27	7.980	88.000	2026-09-30	2026-03-19	5043.43	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	25.208	1113.185280000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480568	480568	2000066	EA	TRAY PRESTIGE 3377 DIVID 3/COP 600pc	SIRAJUDHEEN	102497	PRESTIGE PACKING INDUSTRY CO.	GROCERY NON FOOD	ALUMINIUM TRAYS & FO	167.8000	168.0000	0.001190	178.2600	0.058678	4.000	671.20	0.000	0.000	2026-03-30	NULL	0.00	0.00	0.00	671.20	671.20	0.000	0.000	0.0000000	0.0000000	dead	0	4.000	671.200000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480569	480569	2000067	CAR	SPRITE CAN 24*320ml	SIRAJUDHEEN	102519	COCA COLA BOTTLING COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	41.7600	42.0000	0.005714	50.0000	0.164800	135.000	5637.60	5.390	77.000	2026-09-16	2024-12-26	5428.80	208.80	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	58.000	2422.080000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480570	480570	2000069	CAR	FANTA ORANGE CAN 24*320ml	SIRAJUDHEEN	102519	COCA COLA BOTTLING COMPANY	GROCERY FOOD	SPARKLING & SOFT DRI	41.7600	42.0000	0.005714	48.0000	0.130000	190.000	7934.40	2.248	18.000	2026-09-29	2024-12-24	5428.80	0.00	2505.60	0.00	2505.60	0.000	0.000	0.0000000	0.0000000	fast	0	172.000	7182.720000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480571	480571	2000070	CAR	PEPSI DIET CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	35.7600	35.6500	-0.003086	40.8700	0.125031	111.375	3982.77	18.444	224.000	2026-10-08	2025-10-07	3982.77	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	0.000	0.000000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480572	480572	2000071	CAR	PEPSI CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.0800	43.9100	-0.049419	49.1300	0.062080	533.417	24579.86	36.004	463.000	2026-10-12	2024-10-31	24579.86	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	70.417	3244.815360000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480573	480573	2000072	CAR	7UP CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.0800	43.9100	-0.049419	49.1300	0.062080	434.375	20016.00	15.239	236.000	2026-09-28	2024-10-31	20016.00	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	198.375	9141.120000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480574	480574	2000073	CAR	7UP DIET CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	35.7600	35.6700	-0.002523	40.0000	0.106000	120.917	4323.99	10.618	124.000	2026-10-07	2025-10-07	4323.99	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	0.000	0.000000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480575	480575	2000074	CAR	MIRINDA CITRUS CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	40.5600	43.9100	0.076292	49.0000	0.172245	596.917	24210.95	33.960	459.000	2026-10-14	2024-10-31	24210.95	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	137.917	5593.913520000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480576	480576	2000075	CAR	MIRINDA ORANGE CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.0800	43.9100	-0.049419	47.5000	0.029895	23.458	1080.94	5.596	53.000	2026-09-15	2024-06-01	1080.94	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	0.000	0.000000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480577	480577	2000076	CAR	MIRINDA APPLE CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.0800	43.9100	-0.049419	49.0000	0.059592	45.250	2085.12	0.942	14.000	2026-10-13	NULL	1382.40	702.72	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	moderate	0	31.250	1440.000000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480578	480578	2000077	EA	TRAY PRESTIGE 8582 DIVID 2/COP 600pc	SIRAJUDHEEN	102497	PRESTIGE PACKING INDUSTRY CO.	GROCERY NON FOOD	ALUMINIUM TRAYS & FO	198.8100	202.0000	0.015792	218.0000	0.088028	17.000	3379.77	0.089	0.000	2026-10-10	NULL	3379.77	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	moderate	0	17.000	3379.770000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480579	480579	2000078	CAR	MIRINDA STRAWBERY CAN 24*320ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.0800	43.9100	-0.049419	47.5000	0.029895	48.958	2255.98	0.400	5.000	2026-10-13	NULL	1382.40	0.00	873.58	0.00	873.58	0.000	0.000	0.0000000	0.0000000	slow	0	43.958	2025.584640000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480580	480580	2000079	CAR	DEW CAN 24*320ML	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.0800	43.9100	-0.049419	49.0000	0.059592	561.250	25862.40	24.237	321.000	2026-10-14	2025-06-08	25862.40	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	240.250	11070.720000000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480581	480581	2000080	CAR	PEPSI CAN M 30*240ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.2000	43.9100	-0.052152	46.9600	0.016184	495.533	22893.62	18.531	223.000	2026-10-14	2024-06-15	22893.62	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	272.533	12591.024600000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480582	480582	2000081	CAR	MIRINDA CITRUS CAN M 30*240/245ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.2000	43.9100	-0.052152	46.9600	0.016184	473.733	21886.46	26.497	311.000	2026-10-12	2024-06-15	21886.46	0.00	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	162.733	7518.264600000
Edit	Copy	Delete DELETE FROM v_items_full WHERE `v_items_full`.`id` = 480583	480583	2000082	CAR	SHANI CAN M 30*240ml	SIRAJUDHEEN	102056	AL JOMAIH BEVERAGES CO LTD (PEPSI)	GROCERY FOOD	SPARKLING & SOFT DRI	46.2000	43.9100	-0.052152	48.2600	0.042685	59.367	2742.76	1.487	20.000	2026-09-09	NULL	0.00	2742.76	0.00	0.00	0.00	0.000	0.000	0.0000000	0.0000000	fast	0	39.367	1818.755400000

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view