jay-mis.com / 127.0.0.1 / anud_intend / v_anud_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

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.0082 seconds.) [purchase_2m: 24578.000... - 7864.000...]

SELECT * FROM `v_anud_items` ORDER BY `purchase_2m` DESC

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

Filter rows:

			id	item_id	item_name	unit	department	category	sub_category	brand	buyer	supplier_id	supplier_name	last_grn_date	last_intercompany_date	avg_cost	selling_price	loc_retail_plastic	loc_showroom	loc_wholesale_plastic	loc_warehouse_1	loc_warehouse_2	loc_warehouse_3	loc_central_warehouse	loc_shaharzad_warehouse	loc_global_star	loc_meena_port	loc_delivery_warehouse_bounty	loc_tr_in_progress	stock_qty	stock_value	dmg_loc_s_plastic	dmg_loc_shop	dmg_loc_w1	dmg_loc_w2	dmg_loc_w3	dmg_loc_w4	dmg_stock_qty	avg_sale_day	opening_qty_3m	three_month_sales	intercompany_issue_3m	adj_prctn_phycnt_3m	purchase_3m	opening_qty_2m	two_month_sales	intercompany_issue_2m	adj_prctn_phycnt_2m	purchase_2m 1	lead_time	lead_time_avg	balance_stock	excess_short_qty	excess_short_value	slow_qty_3m	slow_val_3m	slow_qty_2m	slow_val_2m	is_zero_sale	recent_30	is_oos	is_excess	is_shortage	is_damage	is_slow_3m	is_slow_2m	wh_total_qty	dmg_calc_total_qty	movement_status	overstock_qty	overstock_value	shortage_qty	shortage_value	damage_qty	damage_value	is_transfer_showroom	is_transfer_w2
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 200571	200571	FRA857	POTATO AL JOUF(GOLDEN) 4*2.5KG	CTN	FROZEN	FROZEN VEGETABLES	FROZEN POTATO	NULL	BUYER 2	AS0074	AL JOUF FOOD CO. FOR INDUSTRY.(POTTATO)	2026-10-13	2026-01-18	56.8900	59.0000	0.000	140.000	0.000	1175.000	252.000	0.000	0.000	0.000	1225.000	2448.000	0.000	0.000	5240.000	298103.54	0.000	0.000	0.000	0.000	0.000	0.000	0.000	239.258	4719.750	21533.250	13236.000	1.500	35288.000	4712.500	14259.500	9792.000	1.000	24578.000	12	2871.100	5240.000	2368.900	134766.69	0.000	0.00	0.000	0.00	0	1	0	1	0	0	0	0	5100.000	0.000	fast	2368.900	134766.72	0.000	0.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 197423	197423	AB468	WATER WE 40*330 ML	CTN	GROCERY FOOD	WATER	WATER	NULL	BUYER 2	A11118	AL-SUMOU FACTORY FOR DRINKING WATER PRODUCTION CO....	2026-10-12	NULL	7.7960	8.6957	0.000	170.050	0.000	0.000	203.250	1268.000	1.000	0.000	0.000	0.000	0.000	2.000	1644.300	12818.98	0.000	0.000	0.000	0.000	0.000	0.000	0.000	310.440	2061.150	27939.575	958.000	-50.300	28531.000	1633.450	18313.175	628.000	0.000	18952.000	12	3725.277	1644.300	-2080.977	-16223.32	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	1474.250	0.000	fast	0.000	0.00	2080.977	16223.30	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 203336	203336	WL011	WATER NOVA (40x330-ml)	CTN	GROCERY FOOD	WATER	WATER	NULL	BUYER 2	A212	LOCAL PURCHASE	2026-10-13	2026-10-12	13.4724	14.5000	0.000	153.000	0.000	0.000	159.000	648.000	0.000	0.000	0.000	0.000	0.000	0.000	960.000	12933.55	0.000	0.000	0.000	0.000	0.000	0.000	0.000	291.953	1505.800	26275.750	328.000	-6.050	26064.000	1435.900	18155.900	248.000	0.000	17928.000	30	8758.583	960.000	-7798.583	-105066.00	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	807.000	0.000	fast	0.000	0.00	7798.583	105065.63	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 198976	198976	AZ610	OIL MOMIN PALM OLEIN 17 L	TIN	GROCERY FOOD	OIL	VEGETABLE OIL	NULL	BUYER 1	A212	LOCAL PURCHASE	2026-10-11	2026-09-02	93.0123	95.0000	0.000	4.000	0.000	0.000	12.000	0.000	3120.000	0.000	0.000	0.000	0.000	0.000	3136.000	291686.46	0.000	1.000	0.000	3.000	0.000	0.000	4.000	239.189	1353.000	21527.000	308.000	-2.000	23624.000	3590.000	17530.000	306.000	-2.000	17388.000	12	2870.267	3136.000	265.733	24716.46	0.000	0.00	0.000	0.00	0	1	0	1	0	1	0	0	3132.000	4.000	fast	265.733	24716.44	0.000	0.00	4.000	372.05	1	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201176	201176	OL1015	OIL DALAL (17-L)	TIN	GROCERY FOOD	OIL	VEGETABLE OIL	NULL	BUYER 1	A018	AFIA INTERNATIONAL COMPANY	2026-09-24	2026-10-11	99.9436	104.0000	0.000	161.000	0.000	0.000	296.000	1800.000	2567.000	0.000	0.000	0.000	0.000	11.000	4835.000	483227.37	0.000	0.000	0.000	0.000	2.000	6.000	8.000	345.167	8356.000	31065.000	138.000	0.000	27690.000	7803.000	19802.000	66.000	0.000	16908.000	30	10355.000	4835.000	-5520.000	-551688.74	0.000	0.00	0.000	0.00	0	1	0	0	1	1	0	0	4674.000	8.000	fast	0.000	0.00	5520.000	551688.67	8.000	799.55	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 200013	200013	EGG001	EGG KADHI 12 TRAY	CTN	CHILLED & DIARY	EGG	CHICKEN EGG	NULL	BUYER 3	A1086	KADI AGRI & POULTRY COMPANY	2026-10-12	2026-04-02	112.3418	120.0000	0.000	83.166	0.000	0.000	1209.083	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1292.249	145173.62	0.000	3.000	0.000	2.166	0.000	0.000	5.166	273.470	685.655	24612.333	173.667	-9.240	25409.000	1778.457	16861.000	27.500	3.457	16404.000	30	8204.111	1292.249	-6911.862	-776491.25	0.000	0.00	0.000	0.00	0	1	0	0	1	1	0	0	1209.083	5.166	fast	0.000	0.00	6911.862	776491.02	5.166	580.36	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 199935	199935	DT306	WATER HANA (6x1.5-L)	CTN	GROCERY FOOD	WATER	WATER	NULL	BUYER 2	A155	HANA	2026-10-12	2026-07-30	4.5000	5.5000	0.000	253.167	0.000	0.000	365.000	699.000	0.000	0.000	0.000	0.000	0.000	0.000	1317.167	5927.25	0.000	0.000	0.000	0.000	0.000	0.000	0.000	192.528	675.001	17327.500	8089.833	-5.500	26065.000	727.501	10702.333	5085.000	0.000	16377.000	30	5775.833	1317.167	-4458.666	-20064.00	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	1064.000	0.000	fast	0.000	0.00	4458.666	20064.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 200937	200937	MK034	MILK ALMARAI (12x1-L) PKT	CTN	GROCERY FOOD	MILK AND MILK POWDER	UHT MILK	NULL	BUYER 1	A046	AL MARAI COMPANY	2026-10-11	2026-09-10	49.0808	50.0000	0.000	103.084	0.000	0.000	1517.833	0.000	0.000	0.000	0.000	8698.000	0.000	0.000	10318.916	506460.66	0.000	0.000	0.000	0.000	0.000	0.000	0.000	134.650	1783.250	12118.500	42.333	-0.917	20697.417	2568.416	8051.417	21.833	0.000	15823.750	30	4039.500	10318.916	6279.416	308198.77	0.000	0.00	0.000	0.00	0	1	0	1	0	0	0	0	10215.833	0.000	fast	6279.416	308198.76	0.000	0.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201173	201173	OL099	OIL MAHA VEGITABLE (17-LTR)	TIN	GROCERY FOOD	OIL	VEGETABLE OIL	NULL	BUYER 1	A11306	PURE FOOD CO.(OIL)	2026-09-10	2025-06-18	95.8522	98.0000	0.000	89.000	0.000	0.000	341.000	1378.000	6474.000	0.000	0.000	0.000	0.000	3.000	8285.000	794135.57	0.000	0.000	0.000	1.000	24.000	0.000	25.000	130.789	-3.000	11771.000	0.000	1.000	20083.000	2770.000	10256.000	0.000	0.000	15796.000	12	1569.467	8285.000	6715.533	643698.72	0.000	0.00	0.000	0.00	0	0	0	1	0	1	0	0	8196.000	25.000	fast	6715.533	643698.61	0.000	0.00	25.000	2396.31	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 200389	200389	FRA184	WATER WE 30*600ML	CTN	GROCERY FOOD	WATER	WATER	NULL	BUYER 2	A11118	AL-SUMOU FACTORY FOR DRINKING WATER PRODUCTION CO....	2026-10-12	2026-08-12	8.0400	8.6957	0.000	129.333	0.000	0.000	161.000	756.000	0.000	0.000	0.000	0.000	0.000	0.000	1046.333	8412.52	0.000	0.000	0.000	0.000	0.000	0.000	0.000	254.637	1864.760	22917.333	1658.000	5.906	23751.000	17.066	12366.733	968.000	0.000	14364.000	12	3055.644	1046.333	-2009.311	-16154.86	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	917.000	0.000	fast	0.000	0.00	2009.311	16154.86	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 203140	203140	VA510	WATER WE 48*200ml	CTN	GROCERY FOOD	WATER	WATER	NULL	BUYER 2	A11118	AL-SUMOU FACTORY FOR DRINKING WATER PRODUCTION CO....	2026-10-12	NULL	7.8058	8.6957	0.000	83.459	0.000	0.000	229.000	942.000	0.000	0.000	0.000	0.000	0.000	0.000	1254.459	9792.09	0.000	0.000	0.000	0.000	0.000	0.000	0.000	185.550	800.979	16699.521	49.000	1.000	17201.000	1046.979	11620.521	17.000	0.000	11845.000	12	2226.603	1254.459	-972.144	-7588.39	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	1171.000	0.000	fast	0.000	0.00	972.144	7588.36	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 202841	202841	SW510	SUGAR SAUDI (50-kg)	BAG	GROCERY FOOD	HONEY,SALT & SUGAR	SUGAR	NULL	BUYER 1	A018	AFIA INTERNATIONAL COMPANY	2026-09-24	2026-10-07	106.1254	109.0000	0.000	53.000	0.000	0.000	175.000	547.000	3248.000	0.000	0.000	0.000	28.000	0.000	4051.000	429913.91	0.000	0.000	0.000	0.000	0.000	0.000	0.000	156.167	3998.000	14055.000	23.000	18.000	14113.000	3029.000	10049.000	18.000	0.000	11088.000	30	4685.000	4051.000	-634.000	-67283.49	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	3998.000	0.000	fast	0.000	0.00	634.000	67283.50	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 200835	200835	JCR01	JUICE RABIE ORANGE (PKT)(30x250ml)	CTN	GROCERY FOOD	BEVERAGES	JUICE	NULL	BUYER 2	A058	AL RABIE SAUDI FOODS CO.	2026-10-05	NULL	42.9804	43.0435	0.000	91.000	0.000	1096.000	127.000	0.000	1760.000	0.000	0.000	0.000	0.000	0.000	3074.000	132121.77	0.000	0.000	6.000	0.000	0.000	0.000	6.000	165.611	2086.000	14905.000	11.000	10.000	15900.000	3025.000	10200.000	7.000	0.000	10262.000	30	4968.333	3074.000	-1894.333	-81419.21	0.000	0.00	0.000	0.00	0	1	0	0	1	1	0	0	2983.000	6.000	fast	0.000	0.00	1894.333	81419.19	6.000	257.88	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201845	201845	RP50	MAIDA (45-kg)	BAG	GROCERY FOOD	FLOUR	WHITE FLOUR	NULL	BUYER 1	A1095	MILLING COMPANY FOUR	2026-10-13	2025-01-20	22.9991	27.0000	0.000	95.000	0.000	0.000	92.000	1504.000	0.000	0.000	0.000	0.000	32.000	0.000	1723.000	39627.37	0.000	0.000	0.000	0.000	0.000	0.000	0.000	147.400	1451.000	13266.000	210.000	10.000	13738.000	958.000	9333.000	137.000	0.000	10235.000	30	4422.000	1723.000	-2699.000	-62074.45	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	1628.000	0.000	fast	0.000	0.00	2699.000	62074.57	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 199355	199355	BL202	BEEF LIVER KILCOY (AUS)	KG	FROZEN	BEEF	FROZEN BEEF LIVER	NULL	BUYER 2	A0127	IBN HAYYAN TRADING CO.	2026-09-28	2026-05-10	17.0602	19.0000	0.000	174.450	0.000	2795.810	945.519	0.000	0.000	0.000	0.000	0.000	0.000	0.000	3915.779	66803.92	0.000	0.000	0.000	0.000	0.000	0.000	0.000	127.926	3370.700	11513.351	0.000	-8.720	12067.150	22.309	5834.190	0.000	0.000	9727.660	30	3837.784	3915.779	77.995	1330.62	0.000	0.00	0.000	0.00	0	1	0	1	0	0	0	0	3741.329	0.000	fast	77.995	1330.61	0.000	0.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201166	201166	OL044	OIL VEGITABLE(NASREEN) (17-L)	TIN	GROCERY FOOD	OIL	VEGETABLE OIL	NULL	BUYER 1	A018	AFIA INTERNATIONAL COMPANY	2026-08-19	2026-10-11	96.7689	98.0000	0.000	106.000	0.000	0.000	201.000	598.000	4270.000	0.000	0.000	0.000	0.000	2.000	5177.000	500972.80	0.000	0.000	0.000	0.000	1.000	0.000	1.000	117.922	5200.000	10613.000	239.000	1.000	10829.000	2600.000	6619.000	78.000	0.000	9275.000	30	3537.667	5177.000	1639.333	158636.55	0.000	0.00	0.000	0.00	0	1	0	1	0	1	0	0	5071.000	1.000	fast	1639.333	158636.45	0.000	0.00	1.000	96.77	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201155	201155	OL004	OIL AL ARABI (17-L)	TIN	GROCERY FOOD	OIL	VEGETABLE OIL	NULL	BUYER 1	A018	AFIA INTERNATIONAL COMPANY	2026-10-11	2026-10-05	102.2723	105.0000	0.000	79.000	0.000	0.000	341.000	960.000	4111.000	0.000	0.000	0.000	0.000	2.000	5493.000	561781.83	0.000	0.000	0.000	0.000	0.000	61.000	61.000	178.856	7982.000	16097.000	3.000	1.000	13671.000	6911.000	10453.000	2.000	0.000	9098.000	30	5365.667	5493.000	127.333	13022.67	0.000	0.00	0.000	0.00	0	1	0	1	0	1	0	0	5414.000	61.000	fast	127.333	13022.64	0.000	0.00	61.000	6238.61	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201491	201491	PT014	POTATO AMERICANA CALIFORNIA (BELGIUM/FRANCE) (4x2....	CTN	FROZEN	FROZEN VEGETABLES	FROZEN POTATO	NULL	BUYER 2	A075	NATIONAL FOOD COMPANY (AMERICANA)	2026-10-13	2026-07-16	42.7137	47.0000	0.000	167.750	0.000	1187.000	181.500	0.000	0.000	0.000	432.000	0.000	0.000	0.000	1968.250	84071.31	0.000	0.000	0.000	0.000	0.000	0.000	0.000	103.119	465.000	9280.750	8351.000	1.000	19134.000	3138.750	6504.500	3551.000	0.000	8885.000	30	3093.583	1968.250	-1125.333	-48067.19	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	1800.500	0.000	fast	0.000	0.00	1125.333	48067.14	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201177	201177	OL1018	OIL HAYATH (17-LTR)	TIN	GROCERY FOOD	OIL	VEGETABLE OIL	HAYAT	BUYER 1	A10827	AL MUNAJEM FOODS COMPANY	2026-09-27	2025-11-26	100.4041	105.0000	0.000	49.000	0.000	0.000	186.000	727.000	2580.000	0.000	0.000	2160.000	0.000	0.000	5702.000	572504.00	0.000	0.000	0.000	0.000	1.000	0.000	1.000	72.256	3464.000	6503.000	171.000	1.000	8912.000	985.000	4035.000	39.000	0.000	8792.000	30	2167.667	5702.000	3534.333	354861.45	0.000	0.00	0.000	0.00	0	1	0	1	0	1	0	0	5653.000	1.000	fast	3534.333	354861.52	0.000	0.00	1.000	100.40	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 203302	203302	WA019	WATER HANA 30*550ml	CTN	GROCERY FOOD	WATER	WATER	NULL	BUYER 2	A155	HANA	2026-09-28	NULL	7.8300	8.6957	0.000	93.208	0.000	0.000	2.000	216.000	0.000	0.000	0.000	0.000	0.000	0.000	311.208	2436.76	0.000	0.000	0.000	0.000	0.000	0.000	0.000	95.953	0.000	8635.792	334.000	0.000	9281.000	190.000	8223.792	289.000	0.000	8634.000	12	1151.439	311.208	-840.231	-6579.01	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	218.000	0.000	fast	0.000	0.00	840.231	6579.01	0.000	0.00	0	1
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 199176	199176	BF005	BEEF TOPSIDE BRAZIL	KG	FROZEN	BEEF	FROZEN BEEF TOPSIDE	NULL	BUYER 2	A10827	AL MUNAJEM FOODS COMPANY	2026-10-06	NULL	29.7015	31.0000	0.000	142.601	0.000	834.640	605.190	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1582.431	47000.64	0.000	0.000	0.000	0.000	0.000	0.000	0.000	134.260	1899.735	12083.360	300.970	0.556	12066.470	1954.963	8898.102	0.000	0.000	8525.570	30	4027.787	1582.431	-2445.356	-72630.83	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	1439.830	0.000	fast	0.000	0.00	2445.356	72630.74	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 199651	199651	CH965	CHEESE ALMARAI BLUE (3x2x900-gm) PROMO	CTN	CHILLED & DIARY	CHEESE	ANALOGUE CHEESE CREAM	NULL	BUYER 1	A046	AL MARAI COMPANY	2026-09-24	2026-01-04	86.8937	95.0000	0.000	35.666	0.000	0.000	3928.333	0.000	0.000	0.000	0.000	2304.000	0.000	0.000	6267.999	544649.48	0.000	0.000	0.000	0.000	0.000	0.000	0.000	46.119	1303.499	4150.667	96.000	-1.833	9213.000	941.333	2832.667	96.000	0.000	8254.667	20	922.370	6267.999	5345.629	464501.33	0.000	0.00	0.000	0.00	0	1	0	1	0	0	0	0	6232.333	0.000	fast	5345.629	464501.48	0.000	0.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 200640	200640	FZ250	MUTTON CURCUS	KG	FROZEN	MUTTON	FROZEN MUTTON CURCUS	NULL	BUYER 2	A0127	IBN HAYYAN TRADING CO.	2026-09-27	2026-08-29	27.5860	29.0000	0.000	151.665	0.000	2498.740	228.050	0.000	0.000	0.000	0.000	0.000	0.000	0.000	2878.455	79404.98	0.000	0.000	0.000	0.000	0.000	0.000	0.000	116.732	2795.287	10505.875	354.850	-803.007	11746.900	3107.900	7605.375	354.850	-503.460	8234.240	20	2334.639	2878.455	543.816	15001.70	0.000	0.00	0.000	0.00	0	1	0	1	0	0	0	0	2726.790	0.000	fast	543.816	15001.71	0.000	0.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 199391	199391	BT003	CHICKEN BREST LAR/AJC/EVA (4x2.5-kg)	CTN	FROZEN	CHICKEN	FROZEN CHICKEN BREAST	NULL	BUYER 2	A043	AL-MADANI FOOD -CHICKEN	2026-10-13	2025-10-11	181.8516	188.0000	0.000	38.750	0.000	1887.000	144.250	0.000	0.000	0.000	1593.000	0.000	0.000	0.000	3663.000	666122.38	0.000	0.000	0.000	0.000	0.000	0.000	0.000	105.469	1821.000	9492.250	175.000	-6.750	11516.000	1799.250	6235.000	3.000	-0.250	8102.000	30	3164.083	3663.000	498.917	90728.79	0.000	0.00	0.000	0.00	0	1	0	1	0	0	0	0	3624.250	0.000	fast	498.917	90728.85	0.000	0.00	0.000	0.00	0	0
Edit	Copy	Delete DELETE FROM v_anud_items WHERE `v_anud_items`.`id` = 201820	201820	RP069	CAKE POWDER FOOM (45kg)	BAG	GROCERY FOOD	FLOUR	WHITE FLOUR	NULL	BUYER 1	A1095	MILLING COMPANY FOUR	2026-10-13	2026-05-02	28.9723	38.0000	0.000	61.000	0.000	0.000	162.000	192.000	0.000	0.000	0.000	0.000	0.000	0.000	415.000	12023.51	0.000	0.000	0.000	0.000	0.000	0.000	0.000	147.000	682.000	13230.000	244.000	33.000	13173.000	764.000	8057.000	160.000	2.000	7864.000	30	4410.000	415.000	-3995.000	-115744.37	0.000	0.00	0.000	0.00	0	1	0	0	1	0	0	0	354.000	0.000	fast	0.000	0.00	3995.000	115744.34	0.000	0.00	0	0

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view