jay-mis.com / 127.0.0.1 / mashriq_intend / items

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

Showing rows 0 - 24 (911 total, Query took 0.0076 seconds.) [aging_above_90_val: 440701.23... - 12347.62...]

SELECT * FROM `items` ORDER BY `aging_above_90_val` DESC

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

Filter rows:

Sort by key:

			id	division	material	description	uom	brand	category	sub_category	vendor_code	vendor_name	last_grn_date	avg_cost	stock_qty	stock_value	damage_qty	customer_sales_qty	inter_company_sales_qty	route_sales_qty	three_month_sale_qty	avg_sale_qty_day	opening_stock	in_qty	out_qty	closing_qty	lead_days	stock_required_quarter	excess_short_qty	excess_short_value	aging_0_30_val	aging_30_60_val	aging_60_90_val	aging_above_90_val 1
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9431	9431	FROZEN	FRIT1081	FROZEN CHICKEN GRILLERS 10X1100GM AL ZAEEM RUSSIA	Nos	NULL	Frozen	Gre	FRYSTMAT MENA FOODS AB	FRYSTMAT MENA FOODS AB	2026-06-08	123.7900	3560.000	440692.40	0.000	225.000	0.000	0.000	225.000	2.500	3885.000	0.000	325.000	3560.000	90	225.000	3335.000	412839.65	0.00	0.00	0.00	440701.23
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9432	9432	FROZEN	FRIT1082	FROZEN CHICKEN GRILLERS 10X1200GM AL ZAEEM RUSSIA	Nos	NULL	Frozen	Gre	FRYSTMAT MENA FOODS AB	FRYSTMAT MENA FOODS AB	2026-06-08	133.8600	2040.000	273074.40	0.000	0.000	0.000	0.000	0.000	0.000	2040.000	0.000	0.000	2040.000	90	0.000	2040.000	273074.40	0.00	0.00	0.00	273065.90
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9647	9647	NONFOOD	LP-022	LID FOR CAPPUCCINO CUP BLACK 8OZ DELSY (20*50-1000...	CTN	Delsy	Non Food	PLASTIC CUP& LIDS_old	ACP5038	ANQING MILLENNIUM LOONG PACK CO LTD	2024-10-07	43.3700	1184.000	51350.08	0.000	65.000	0.000	0.000	65.000	0.722	1254.000	26.000	96.000	1184.000	90	65.000	1119.000	48531.03	0.00	0.00	607.18	50742.90
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9433	9433	FROZEN	FRIT1083	FROZEN CHICKEN GRILLERS 10X1300GM AL ZAEEM RUSSIA	Nos	NULL	Frozen	Gre	FRYSTMAT MENA FOODS AB	FRYSTMAT MENA FOODS AB	2026-06-08	142.7300	325.000	46387.25	0.000	0.000	0.000	0.000	0.000	0.000	325.000	0.000	0.000	325.000	90	0.000	325.000	46387.25	0.00	0.00	0.00	46387.95
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9505	9505	NONFOOD	9306	DUST PAN DELSY W/ LONG BRUSH 24PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	175.8100	173.000	30415.13	0.000	-0.008	0.000	0.000	-0.008	0.000	184.000	1.008	12.008	173.000	90	0.000	173.000	30415.13	0.00	177.22	0.00	30237.97
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9762	9762	NONFOOD	SP021W	TABLE SPOON WHITE DELSY (20*50 PC)	CTN	Delsy	Non Food	SPOON	HASTECH LIMITED	HASTECH LIMITED	2026-05-06	26.1200	1085.550	28354.57	0.000	183.000	0.000	0.000	183.000	2.033	1268.000	174.600	357.050	1085.550	90	183.000	902.550	23574.61	67.91	0.00	1645.56	26641.09
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9470	9470	NONFOOD	5005-2	DUST PAN BRUSH ( 5PC ) DELSY -12 SET	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-09-02	102.8400	321.000	33011.64	0.000	35.000	1.000	0.000	36.000	0.400	348.583	91.667	119.250	321.001	90	36.000	285.000	29309.40	6033.31	205.68	514.20	26258.45
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9789	9789	NONFOOD	WOODEN -55	WOODEN BROOM DELSY 55 CM 24 PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	287.3900	78.830	22654.95	0.000	0.000	0.000	0.000	0.000	0.000	78.875	0.000	0.042	78.833	90	0.000	78.830	22654.95	0.00	0.00	0.00	22655.97
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9782	9782	NONFOOD	TY2355MIM	MINI MITT COTTON DELSY 25 CM 72 PC	CTN	Delsy	Non Food	KITCHEN TOOLS_old	ACP5072	SIHUI GOLD EAGLE WORKING HARD TRADING CO.	2024-10-31	220.8800	85.840	18960.34	0.000	0.168	0.000	0.000	0.168	0.002	88.000	0.000	2.160	85.840	90	0.168	85.672	18923.23	0.00	0.00	0.00	18960.34
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9545	9545	NONFOOD	DEL 300 -3	TISSUE 3 PLY DELSY (510300 PC)	Bundle	Delsy	Non Food	TISSUE	White Tissue For Paper Products Company	White Tissue For Paper Products Company	2026-07-01	55.0000	374.400	20592.00	0.000	122.000	0.000	0.000	122.000	1.356	466.000	88.800	180.400	374.400	90	122.000	252.400	13882.00	2079.00	330.00	55.00	18128.00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9503	9503	NONFOOD	9225	SOFT BROOM DELSY 24PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-09-02	73.7000	268.790	19809.82	0.000	5.000	0.000	0.000	5.000	0.056	259.916	30.000	21.126	268.790	90	5.000	263.790	19441.32	2137.30	0.00	73.70	17598.80
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9552	9552	NONFOOD	DEL007	BAMBOO HEART STICK DELSY 60*100PC 15CM	CTN	Delsy	Non Food	KITCHEN TOOLS_old	ACP5045	UNITED INFULL LIMITED	2024-09-15	308.6900	57.000	17595.33	0.000	0.000	3.000	0.000	3.000	0.033	69.000	0.000	12.000	57.000	90	3.000	54.000	16669.26	0.00	0.00	0.00	17595.33
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9657	9657	NONFOOD	M-50-PINK	HOUSE HOLD RUBBER GLOVES PINK -MEDUM 12*10=120	CTN	NULL	Non Food	CLEANING PRODUCTS_old	ACP5031	PIDEGREE INDUSTRIAL CO LTD	2024-07-30	129.4300	134.500	17408.34	0.000	0.100	0.000	0.000	0.100	0.001	134.600	0.000	0.100	134.500	90	0.100	134.400	17395.39	0.00	0.00	0.00	17408.34
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9541	9541	NONFOOD	DEL 103	BUTTER PAPER MEAT DELSY (8*300 PC)	CTN	Delsy	Non Food	SANDWICH PAPER	ACP5066	SHANDONG SHENGHE INTERNATIONAL TRADE CO.LTD	2025-10-21	42.3800	380.000	16104.40	0.000	45.000	10.000	0.000	55.000	0.611	448.000	0.000	68.000	380.000	90	55.000	325.000	13773.50	0.00	0.00	0.00	16104.40
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9568	9568	NONFOOD	DEL-127 (CLR)	SAUCE CUP CLEAR WITH LID 2OZ DELSY (10*100PC)	CTN	Delsy	Non Food	SAUCE CUP	ACP5019	E TIME IMPORT AND EXPORT	2025-12-14	59.4800	262.000	15583.76	0.000	0.000	0.000	0.000	0.000	0.000	263.000	0.000	1.000	262.000	90	0.000	262.000	15583.76	0.00	0.00	0.00	15583.76
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9551	9551	NONFOOD	DEL006	BAMBOO HEART STICK DELSY 60* 100PC 10CM	CTN	Delsy	Non Food	KITCHEN TOOLS_old	ACP5045	UNITED INFULL LIMITED	2024-09-15	300.3200	50.000	15016.00	0.000	20.000	0.000	0.000	20.000	0.222	76.000	0.000	26.000	50.000	90	20.000	30.000	9009.60	0.00	0.00	0.00	15016.00
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9436	9436	FROZEN	FRIT1031	FROZEN LEAF SPINACH (CHPD) 4*2.5KG, BELGIUM	CTN	NULL	Frozen	Gre	NULL	NULL	NULL	43.1400	337.000	14538.18	0.000	115.000	0.000	0.000	115.000	1.278	455.000	0.000	118.000	337.000	90	115.000	222.000	9577.08	0.00	0.00	0.00	14538.18
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9785	9785	NONFOOD	TY405SLOM-40CM	OVEN GLOVES COTTON 40CM 48 PC	CTN	Delsy	Non Food	KITCHEN TOOLS_old	ACP5072	SIHUI GOLD EAGLE WORKING HARD TRADING CO.	2024-10-31	178.8100	82.040	14669.57	0.000	2.252	0.000	0.000	2.252	0.025	91.750	5.000	14.708	82.042	90	2.252	79.788	14266.89	0.00	0.00	536.43	14133.50
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9790	9790	NONFOOD	WOODEN-45	WOODEN BROOM DELSY 45CM 24PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	228.7800	60.870	13925.84	0.000	3.000	0.000	0.000	3.000	0.033	64.000	0.000	3.125	60.874	90	3.000	57.870	13239.50	0.00	0.00	0.00	13926.98
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9778	9778	NONFOOD	TC1009	TEA CUP 9OZ (20x50PC)	Nos	NULL	Non Food	TEA CUP	AL ANUD ARABIA TRADING	AL ANUD ARABIA TRADING COMPANY	2026-07-21	39.0700	377.000	14729.39	0.000	123.000	0.000	0.000	123.000	1.367	502.000	23.000	148.000	377.000	90	123.000	254.000	9923.78	781.40	0.00	78.14	13869.85
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9753	9753	NONFOOD	SL-06	JUICE CUP PAPER DELSY 12OZ	CTN	Delsy	Non Food	PAPER CUPS_old	ACP5019	E TIME IMPORT AND EXPORT	2024-05-29	76.0500	178.950	13609.15	0.000	5.000	5.000	0.000	10.000	0.111	189.950	0.000	11.000	178.950	90	10.000	168.950	12848.65	0.00	0.00	0.00	13609.15
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9487	9487	NONFOOD	8825-F CLIP SET	MOP 300g DELSY STEE CLIP W/STEEL STICK 24 PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	NULL	209.1700	96.960	20281.12	0.000	0.000	0.000	0.000	0.000	0.000	63.700	35.258	2.000	96.958	90	0.000	96.960	20281.12	6956.58	209.17	0.00	13114.96
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9502	9502	NONFOOD	9223	SOFT BROOM DELSY 24PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	77.7600	169.540	13183.43	0.000	4.000	3.000	0.000	7.000	0.078	190.791	2.875	24.126	169.540	90	7.000	162.540	12639.11	68.04	0.00	155.52	12959.85
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9783	9783	NONFOOD	TY26SOM	OVEN GLOVES COTTON 26CM 72 PC	CTN	NULL	Non Food	KITCHEN TOOLS_old	ACP5072	SIHUI GOLD EAGLE WORKING HARD TRADING CO.	2024-10-31	167.2400	77.510	12962.77	0.000	1.168	0.000	0.000	1.168	0.013	79.833	2.000	4.321	77.512	90	1.168	76.342	12767.44	0.00	0.00	334.48	12628.62
Edit	Copy	Delete DELETE FROM items WHERE `items`.`id` = 9793	9793	NONFOOD	XL-60-PINK	HOUSE HOLD RUBBER GLOVES PINK -XL LARGE 12*10=120	CTN	NULL	Non Food	CLEANING PRODUCTS_old	ACP5031	PIDEGREE INDUSTRIAL CO LTD	2024-07-30	129.4300	97.300	12593.54	0.000	10.100	5.000	0.000	15.100	0.168	110.500	1.900	15.100	97.300	90	15.100	82.200	10639.15	245.92	0.00	0.00	12347.62

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view