jay-mis.com / 127.0.0.1 / mashriq_intend / v_mashriq_status

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.0013 seconds.) [is_zero_sale: 1... - 1...]

SELECT * FROM `v_mashriq_status` ORDER BY `is_zero_sale` DESC

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

Filter rows:

			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	is_zero_sale 1	recent_30	recent_90	is_oos	is_excess	is_shortage
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9728	9728	NONFOOD	RE-24	CONTAINER REC 24 OZ BLACK W/LID DELSY (150 PC)	CTN	Delsy	Non Food	FOOD CONTAINER	ACP5063	NINGBO PRIMAX PACKAGING CO LTD	2024-09-11	49.5500	2.000	99.10	0.000	0.000	0.000	0.000	0.000	0.000	0.000	2.000	0.000	2.000	90	0.000	2.000	99.10	99.10	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9473	9473	NONFOOD	509-TS2-45	WIPER STEEL DELSY 45CM-48PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5019	E TIME IMPORT AND EXPORT	2024-08-03	187.1400	0.020	3.74	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.021	0.000	0.021	90	0.000	0.020	3.74	3.93	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9729	9729	NONFOOD	RO 250(RO250)-B	CURRY CUP ROUND 250ML BLACK W/L DELSY (250 PC)	CTN	Delsy	Non Food	CURRY CUP	ACP5019	E TIME IMPORT AND EXPORT	2025-09-18	27.5300	2.000	55.06	0.000	0.000	0.000	0.000	0.000	0.000	0.000	30.000	28.000	2.000	90	0.000	2.000	55.06	55.06	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9474	9474	NONFOOD	533-T3-45	FLOOR WIPER DELSY 45CM 24PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	82.4000	0.290	23.90	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.292	0.000	0.292	90	0.000	0.290	23.90	24.06	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9730	9730	NONFOOD	RO450 B	CURRY CUP BLACK 450 ML W/LID 500PC	CTN	NULL	Non Food	FOOD CONTAINERS_old	ACP5063	NINGBO PRIMAX PACKAGING CO LTD	2024-09-11	73.4000	4.000	293.60	0.000	0.000	0.000	0.000	0.000	0.000	1.000	13.000	10.000	4.000	90	0.000	4.000	293.60	293.60	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9731	9731	NONFOOD	RX 5	ALUMINIUM FOIL DELSY (6*45 CM)	CTN	Delsy	Non Food	ALUMINUM FOIL	ACP5036	RUI XUAN DEVELOPMENT LTD	2025-10-21	116.3000	1.320	153.52	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.490	0.166	1.324	90	0.000	1.320	153.52	153.98	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9220	9220	DRY	PM001	Packing Material 500gm	Kg	NULL	NULL	PACKING BAG	NULL	NULL	NULL	15.0000	528.000	7920.00	0.000	0.000	0.000	0.000	0.000	0.000	528.000	0.000	0.000	528.000	90	0.000	528.000	7920.00	528.00	0.00	0.00	528.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9732	9732	NONFOOD	RX1	PVC CLING FILM DELSY (6 PC30 CM200 MT)	CTN	Delsy	Non Food	PVC CLING FILM	ACP5019	E TIME IMPORT AND EXPORT	2024-06-06	52.7100	0.670	35.32	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.667	0.000	0.667	90	0.000	0.670	35.32	35.16	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9221	9221	DRY	PM002	Packing Material 1Kg	Kg	NULL	NULL	PACKING BAG	NULL	NULL	NULL	15.0000	270.300	4054.50	0.000	0.000	0.000	0.000	0.000	0.000	358.800	0.000	88.500	270.300	90	0.000	270.300	4054.50	358.80	0.00	88.50	270.30	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9733	9733	NONFOOD	RX2	PVC CLING FILM DELSY (6 PC45 CM200 MT)	CTN	Delsy	Non Food	PVC CLING FILM	ACP5019	E TIME IMPORT AND EXPORT	2025-10-21	70.1000	2.830	198.38	0.000	0.000	0.000	0.000	0.000	0.000	2.500	0.333	0.000	2.833	90	0.000	2.830	198.38	23.34	0.00	0.00	175.25	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9222	9222	DRY	PM003	Packing Material-Master Bag	Kg	NULL	Dry	BLADE	NULL	NULL	NULL	7.0000	180.000	1260.00	0.000	0.000	0.000	0.000	0.000	0.000	180.000	0.000	0.000	180.000	90	0.000	180.000	1260.00	180.00	0.00	0.00	180.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9478	9478	NONFOOD	552-T-35	FLOOR WIPER DELSY 35CM 48PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	132.9800	9.000	1196.82	0.000	0.000	0.000	0.000	0.000	0.000	9.000	0.000	0.000	9.000	90	0.000	9.000	1196.82	0.00	0.00	0.00	1196.82	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9735	9735	NONFOOD	RX4	ALUMINIUM FOIL DELSY (6*30 CM)	CTN	Delsy	Non Food	ALUMINUM FOIL	ACP5036	RUI XUAN DEVELOPMENT LTD	2025-10-21	80.9900	2.330	188.71	0.000	0.000	0.000	0.000	0.000	0.000	0.833	1.500	0.000	2.333	90	0.000	2.330	188.71	120.00	0.00	0.00	66.64	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9480	9480	NONFOOD	8008	CLEANING SPONGE BIG DELSY (10*12 PC)	Bundle	Delsy	Non Food	SPONGE	ACP5019	E TIME IMPORT AND EXPORT	2026-01-13	47.3600	0.700	33.15	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.700	0.000	0.700	90	0.000	0.700	33.15	33.15	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9225	9225	DRY	PP100	PLASTIC PALLETS (100*120CM)	Nos	NULL	NULL	PALLETS	NULL	NULL	NULL	150.0000	34.000	5100.00	0.000	0.000	0.000	0.000	0.000	0.000	62.000	6.000	34.000	34.000	90	0.000	34.000	5100.00	62.00	6.00	34.00	34.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9737	9737	NONFOOD	S-45-PINK	HOUSE HOLD RUBBER GLOVES PINK -SMALL 12*10=120	CTN	NULL	Non Food	CLEANING PRODUCTS_old	ACP5031	PIDEGREE INDUSTRIAL CO LTD	2024-07-30	129.4300	87.000	11260.41	0.000	0.000	0.000	0.000	0.000	0.000	87.000	0.000	0.000	87.000	90	0.000	87.000	11260.41	0.00	0.00	0.00	11260.41	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9738	9738	NONFOOD	S-45-YELLOW	HOUSE HOLD RUBBER GLOVES YELLOW-SMALL 12*10=120	CTN	NULL	Non Food	CLEANING PRODUCTS_old	ACP5031	PIDEGREE INDUSTRIAL CO LTD	2024-07-30	129.4300	84.000	10872.12	0.000	0.000	0.000	0.000	0.000	0.000	81.500	2.500	0.000	84.000	90	0.000	84.000	10872.12	323.58	0.00	0.00	10548.55	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9483	9483	NONFOOD	8053-DN	DUST PAN DELSY-60PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5019	E TIME IMPORT AND EXPORT	2024-02-05	59.6000	7.430	442.83	0.000	0.000	0.000	0.000	0.000	0.000	0.000	7.430	0.000	7.430	90	0.000	7.430	442.83	442.83	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9741	9741	NONFOOD	SB00L	SHOPPING BAG PURE - L - COLOR - 13-KG	Bundle	NULL	NULL	SHOPPING BAG	AL ANUD ARABIA TRADING	AL ANUD ARABIA TRADING COMPANY	2026-06-03	71.0000	4.000	284.00	0.000	0.000	0.000	0.000	0.000	0.000	4.000	0.000	0.000	4.000	90	0.000	4.000	284.00	0.00	0.00	0.00	284.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9742	9742	NONFOOD	SB00M	SHOPPING BAG PURE - M - COLOR - 13-KG	Bundle	NULL	NULL	SHOPPING BAG	MAZZAYA ALSARWAT PLASTIC FACTORY	MAZZAYA ALSARWAT PLASTIC FACTORY	2026-06-22	73.3000	27.000	1979.10	0.000	0.000	0.000	0.000	0.000	0.000	27.000	0.000	0.000	27.000	90	0.000	27.000	1979.10	0.00	0.00	0.00	2079.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`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	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9488	9488	NONFOOD	8827-F	MOP CLIP PLASTICK 120PC	CTN	NULL	Non Food	CLEANING PRODUCTS_old	ACP5048	METIS HOUSEWARE CO LTD	2024-08-03	185.9500	10.850	2017.56	0.000	-0.848	0.000	0.000	-0.848	-0.009	0.000	11.696	0.848	10.848	90	0.000	10.850	2017.56	2017.19	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9489	9489	NONFOOD	8889-80CM	DUST MOP DELSY 80CM-24PC W/STICK STEEL	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5019	E TIME IMPORT AND EXPORT	2024-02-05	243.8100	0.290	70.70	0.000	0.000	0.000	0.000	0.000	0.000	0.294	0.000	0.000	0.294	90	0.000	0.290	70.70	0.00	0.00	0.00	71.68	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9493	9493	NONFOOD	9064	HAND BRUSH DELSY-48PC	CTN	Delsy	Non Food	CLEANING PRODUCTS_old	ACP5019	E TIME IMPORT AND EXPORT	2024-02-05	89.0400	0.470	41.85	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.470	0.000	0.470	90	0.000	0.470	41.85	41.85	0.00	0.00	0.00	1	0	0	0	1	0
Edit	Copy	Delete DELETE FROM v_mashriq_status WHERE `v_mashriq_status`.`id` = 9749	9749	NONFOOD	SF120	SUFRA AL AQEED 120x120 - 20 ROLL	Bundle	NULL	NULL	SUFRA	AL ANUD ARABIA TRADING	AL ANUD ARABIA TRADING COMPANY	2026-06-03	70.0000	1.000	70.00	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	1.000	90	0.000	1.000	70.00	0.00	0.00	0.00	70.00	1	0	0	0	1	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view