bicson.lalskomputer.my.id / 127.0.0.1 / new_data_master / tbv_mon_stok

There are no favorite tables.

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.0497 seconds.)

SELECT * FROM `tbv_mon_stok`

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

Filter rows:

			PRDCD	DESK	CAT_COD	KRITERIA_ITEM	ACOST	PKM	PKM_RP	PKM15	PKM15_RP	LPP	LPP_RP	OVER15	OVER15_RP	SPD	SPD_RP	STO	STO_RP	DSI	TK_MAIN	TK_OVER	TRN_PJG_HR	MAX_DC_TRIM_HR	PER_UMUR	JENIS_PROD	TGL_HR
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000019 AND `tbv_mon_stok`.`DESK` = 'INDOMILK SUSU KENTAL MANIS PUTIH KLG 370g' AND `tbv_mon_stok`.`CAT_COD` = '10201' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 0 AND `tbv_mon_stok`.`PKM` = 3473 AND `tbv_mon_stok`.`PKM_RP` = 0 AND `tbv_mon_stok`.`PKM15` = 5210 AND `tbv_mon_stok`.`PKM15_RP` = 0 AND `tbv_mon_stok`.`LPP` = 0 AND `tbv_mon_stok`.`LPP_RP` = 0 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-5209.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) IS NULL AND `tbv_mon_stok`.`TK_MAIN` = 948 AND `tbv_mon_stok`.`TK_OVER` = 0 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) IS NULL AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000019	INDOMILK SUSU KENTAL MANIS PUTIH KLG 370g	10201	Barang RT - Returnable	0	3473	0	5210	0	0	0	-5209.500000	0.000000	0.000000	0.000000	0	0	NULL	948	0	30	270	NULL	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000020 AND `tbv_mon_stok`.`DESK` = 'INDOMILK SUSU KENTAL MANIS CHOCOLATE KLG 370g' AND `tbv_mon_stok`.`CAT_COD` = '10201' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 0 AND `tbv_mon_stok`.`PKM` = 2355 AND `tbv_mon_stok`.`PKM_RP` = 0 AND `tbv_mon_stok`.`PKM15` = 3533 AND `tbv_mon_stok`.`PKM15_RP` = 0 AND `tbv_mon_stok`.`LPP` = 0 AND `tbv_mon_stok`.`LPP_RP` = 0 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-3532.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) IS NULL AND `tbv_mon_stok`.`TK_MAIN` = 477 AND `tbv_mon_stok`.`TK_OVER` = 0 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) IS NULL AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000020	INDOMILK SUSU KENTAL MANIS CHOCOLATE KLG 370g	10201	Barang RT - Returnable	0	2355	0	3533	0	0	0	-3532.500000	0.000000	0.000000	0.000000	0	0	NULL	477	0	30	270	NULL	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000021 AND `tbv_mon_stok`.`DESK` = 'CAP ENAK KENTAL MANIS PUTIH KLG 370g' AND `tbv_mon_stok`.`CAT_COD` = '10201' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 9760 AND `tbv_mon_stok`.`PKM` = 6600 AND `tbv_mon_stok`.`PKM_RP` = 64416000 AND `tbv_mon_stok`.`PKM15` = 9900 AND `tbv_mon_stok`.`PKM15_RP` = 96624000 AND `tbv_mon_stok`.`LPP` = 15080 AND `tbv_mon_stok`.`LPP_RP` = 147180800 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '5180.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '50556800.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.142056' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '1386.466560' AND `tbv_mon_stok`.`STO` = 12 AND `tbv_mon_stok`.`STO_RP` = 117120 AND CONCAT(`tbv_mon_stok`.`DSI`) = '99.558195' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 584 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '36.8734055556' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000021	CAP ENAK KENTAL MANIS PUTIH KLG 370g	10201	Barang RT - Returnable	9760	6600	64416000	9900	96624000	15080	147180800	5180.000000	50556800.000000	0.142056	1386.466560	12	117120	99.558195	1064	584	30	270	36.8734055556	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000052 AND `tbv_mon_stok`.`DESK` = 'AIM CRACKERS CRISPY PCK 150g' AND `tbv_mon_stok`.`CAT_COD` = '11104' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 7018 AND `tbv_mon_stok`.`PKM` = 9056 AND `tbv_mon_stok`.`PKM_RP` = 63555008 AND `tbv_mon_stok`.`PKM15` = 13584 AND `tbv_mon_stok`.`PKM15_RP` = 95332512 AND `tbv_mon_stok`.`LPP` = 4034 AND `tbv_mon_stok`.`LPP_RP` = 28310612 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-9550.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-67021900.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.078106' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '548.147908' AND `tbv_mon_stok`.`STO` = 430 AND `tbv_mon_stok`.`STO_RP` = 3017740 AND CONCAT(`tbv_mon_stok`.`DSI`) = '49.076885' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 124 AND `tbv_mon_stok`.`TRN_PJG_HR` = 90 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 300 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '16.3589616667' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000052	AIM CRACKERS CRISPY PCK 150g	11104	Barang RT - Returnable	7018	9056	63555008	13584	95332512	4034	28310612	-9550.000000	-67021900.000000	0.078106	548.147908	430	3017740	49.076885	1064	124	90	300	16.3589616667	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000088 AND `tbv_mon_stok`.`DESK` = 'FRISIAN FLAG SUSU KENTAL MANIS COKLAT KLG 370g' AND `tbv_mon_stok`.`CAT_COD` = '10201' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang Putus - Non returnable' AND `tbv_mon_stok`.`ACOST` = 0 AND `tbv_mon_stok`.`PKM` = 3399 AND `tbv_mon_stok`.`PKM_RP` = 0 AND `tbv_mon_stok`.`PKM15` = 5099 AND `tbv_mon_stok`.`PKM15_RP` = 0 AND `tbv_mon_stok`.`LPP` = 0 AND `tbv_mon_stok`.`LPP_RP` = 0 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-5098.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) IS NULL AND `tbv_mon_stok`.`TK_MAIN` = 994 AND `tbv_mon_stok`.`TK_OVER` = 0 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 240 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) IS NULL AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000088	FRISIAN FLAG SUSU KENTAL MANIS COKLAT KLG 370g	10201	Barang Putus - Non returnable	0	3399	0	5099	0	0	0	-5098.500000	0.000000	0.000000	0.000000	0	0	NULL	994	0	30	240	NULL	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000090 AND `tbv_mon_stok`.`DESK` = 'ABC BATTERY BIRU R6 4\'S PCK' AND `tbv_mon_stok`.`CAT_COD` = '32404' AND `tbv_mon_stok`.`KRITERIA_ITEM` = '' AND `tbv_mon_stok`.`ACOST` = 10174 AND `tbv_mon_stok`.`PKM` = 5580 AND `tbv_mon_stok`.`PKM_RP` = 56770920 AND `tbv_mon_stok`.`PKM15` = 8370 AND `tbv_mon_stok`.`PKM15_RP` = 85156380 AND `tbv_mon_stok`.`LPP` = 10307 AND `tbv_mon_stok`.`LPP_RP` = 104863418 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '1937.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '19707038.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.130943' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '1332.214082' AND `tbv_mon_stok`.`STO` = 17 AND `tbv_mon_stok`.`STO_RP` = 172958 AND CONCAT(`tbv_mon_stok`.`DSI`) = '74.014038' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 557 AND `tbv_mon_stok`.`TRN_PJG_HR` = 0 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 0 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) IS NULL AND `tbv_mon_stok`.`JENIS_PROD` = '' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000090	ABC BATTERY BIRU R6 4'S PCK	32404		10174	5580	56770920	8370	85156380	10307	104863418	1937.000000	19707038.000000	0.130943	1332.214082	17	172958	74.014038	1070	557	0	0	NULL		2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000097 AND `tbv_mon_stok`.`DESK` = 'CAP KAPAK MINYAK ANGIN BTL 10mL' AND `tbv_mon_stok`.`CAT_COD` = '21502' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 17876 AND `tbv_mon_stok`.`PKM` = 5344 AND `tbv_mon_stok`.`PKM_RP` = 95529344 AND `tbv_mon_stok`.`PKM15` = 8016 AND `tbv_mon_stok`.`PKM15_RP` = 143294016 AND `tbv_mon_stok`.`LPP` = 4637 AND `tbv_mon_stok`.`LPP_RP` = 82891012 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-3379.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-60403004.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.039645' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '708.694020' AND `tbv_mon_stok`.`STO` = 12 AND `tbv_mon_stok`.`STO_RP` = 214512 AND CONCAT(`tbv_mon_stok`.`DSI`) = '109.194608' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 71 AND `tbv_mon_stok`.`TRN_PJG_HR` = 60 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 810 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '13.4808158025' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000097	CAP KAPAK MINYAK ANGIN BTL 10mL	21502	Barang RT - Returnable	17876	5344	95529344	8016	143294016	4637	82891012	-3379.000000	-60403004.000000	0.039645	708.694020	12	214512	109.194608	1070	71	60	810	13.4808158025	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000098 AND `tbv_mon_stok`.`DESK` = 'CABE KOYO KECIL 10\'S PCK' AND `tbv_mon_stok`.`CAT_COD` = '21501' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 10750 AND `tbv_mon_stok`.`PKM` = 4298 AND `tbv_mon_stok`.`PKM_RP` = 46203500 AND `tbv_mon_stok`.`PKM15` = 6447 AND `tbv_mon_stok`.`PKM15_RP` = 69305250 AND `tbv_mon_stok`.`LPP` = 5610 AND `tbv_mon_stok`.`LPP_RP` = 60307500 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-837.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-8997750.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.083921' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '902.150750' AND `tbv_mon_stok`.`STO` = 30 AND `tbv_mon_stok`.`STO_RP` = 322500 AND CONCAT(`tbv_mon_stok`.`DSI`) = '63.689881' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 309 AND `tbv_mon_stok`.`TRN_PJG_HR` = 90 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 1080 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '5.8972112037' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000098	CABE KOYO KECIL 10'S PCK	21501	Barang RT - Returnable	10750	4298	46203500	6447	69305250	5610	60307500	-837.000000	-8997750.000000	0.083921	902.150750	30	322500	63.689881	1064	309	90	1080	5.8972112037	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000102 AND `tbv_mon_stok`.`DESK` = 'BOTAN MACKAREL KLG 425g' AND `tbv_mon_stok`.`CAT_COD` = '11005' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 35859 AND `tbv_mon_stok`.`PKM` = 3439 AND `tbv_mon_stok`.`PKM_RP` = 123319101 AND `tbv_mon_stok`.`PKM15` = 5159 AND `tbv_mon_stok`.`PKM15_RP` = 184996581 AND `tbv_mon_stok`.`LPP` = 6129 AND `tbv_mon_stok`.`LPP_RP` = 219779811 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '970.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '34801159.500000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.108122' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '3877.146798' AND `tbv_mon_stok`.`STO` = 69 AND `tbv_mon_stok`.`STO_RP` = 2474271 AND CONCAT(`tbv_mon_stok`.`DSI`) = '53.962833' AND `tbv_mon_stok`.`TK_MAIN` = 1058 AND `tbv_mon_stok`.`TK_OVER` = 550 AND `tbv_mon_stok`.`TRN_PJG_HR` = 90 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 450 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '11.9917406667' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000102	BOTAN MACKAREL KLG 425g	11005	Barang RT - Returnable	35859	3439	123319101	5159	184996581	6129	219779811	970.500000	34801159.500000	0.108122	3877.146798	69	2474271	53.962833	1058	550	90	450	11.9917406667	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000103 AND `tbv_mon_stok`.`DESK` = 'REGAL MARIE PCK 230g' AND `tbv_mon_stok`.`CAT_COD` = '11105' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 17480 AND `tbv_mon_stok`.`PKM` = 12540 AND `tbv_mon_stok`.`PKM_RP` = 219199200 AND `tbv_mon_stok`.`PKM15` = 18810 AND `tbv_mon_stok`.`PKM15_RP` = 328798800 AND `tbv_mon_stok`.`LPP` = 18299 AND `tbv_mon_stok`.`LPP_RP` = 319866520 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-511.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-8932280.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.263216' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '4601.015680' AND `tbv_mon_stok`.`STO` = 23 AND `tbv_mon_stok`.`STO_RP` = 402040 AND CONCAT(`tbv_mon_stok`.`DSI`) = '65.105824' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 336 AND `tbv_mon_stok`.`TRN_PJG_HR` = 90 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 390 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '16.6938010256' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000103	REGAL MARIE PCK 230g	11105	Barang RT - Returnable	17480	12540	219199200	18810	328798800	18299	319866520	-511.000000	-8932280.000000	0.263216	4601.015680	23	402040	65.105824	1070	336	90	390	16.6938010256	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000104 AND `tbv_mon_stok`.`DESK` = 'REGAL MARIE PCK 120g' AND `tbv_mon_stok`.`CAT_COD` = '11105' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 9120 AND `tbv_mon_stok`.`PKM` = 11962 AND `tbv_mon_stok`.`PKM_RP` = 109093440 AND `tbv_mon_stok`.`PKM15` = 17943 AND `tbv_mon_stok`.`PKM15_RP` = 163640160 AND `tbv_mon_stok`.`LPP` = 28774 AND `tbv_mon_stok`.`LPP_RP` = 262418880 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '10831.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '98778720.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.629552' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '5741.514240' AND `tbv_mon_stok`.`STO` = 11 AND `tbv_mon_stok`.`STO_RP` = 100320 AND CONCAT(`tbv_mon_stok`.`DSI`) = '43.079133' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 821 AND `tbv_mon_stok`.`TRN_PJG_HR` = 90 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 390 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '11.0459315385' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000104	REGAL MARIE PCK 120g	11105	Barang RT - Returnable	9120	11962	109093440	17943	163640160	28774	262418880	10831.000000	98778720.000000	0.629552	5741.514240	11	100320	43.079133	1070	821	90	390	11.0459315385	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000107 AND `tbv_mon_stok`.`DESK` = 'GREEN SANDS ORIGINAL LIME & APPLE KLG 330mL' AND `tbv_mon_stok`.`CAT_COD` = '10407' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 5939 AND `tbv_mon_stok`.`PKM` = 14073 AND `tbv_mon_stok`.`PKM_RP` = 83579547 AND `tbv_mon_stok`.`PKM15` = 21110 AND `tbv_mon_stok`.`PKM15_RP` = 125372290 AND `tbv_mon_stok`.`LPP` = 22771 AND `tbv_mon_stok`.`LPP_RP` = 135236969 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '1661.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '9867648.500000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.465081' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '2762.116059' AND `tbv_mon_stok`.`STO` = 30 AND `tbv_mon_stok`.`STO_RP` = 178170 AND CONCAT(`tbv_mon_stok`.`DSI`) = '46.394278' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 417 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '17.1830659259' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000107	GREEN SANDS ORIGINAL LIME & APPLE KLG 330mL	10407	Barang RT - Returnable	5939	14073	83579547	21110	125372290	22771	135236969	1661.500000	9867648.500000	0.465081	2762.116059	30	178170	46.394278	1070	417	30	270	17.1830659259	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000116 AND `tbv_mon_stok`.`DESK` = 'ABC SAMBAL BTL 335mL' AND `tbv_mon_stok`.`CAT_COD` = '10706' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 0 AND `tbv_mon_stok`.`PKM` = 2142 AND `tbv_mon_stok`.`PKM_RP` = 0 AND `tbv_mon_stok`.`PKM15` = 3213 AND `tbv_mon_stok`.`PKM15_RP` = 0 AND `tbv_mon_stok`.`LPP` = 24 AND `tbv_mon_stok`.`LPP_RP` = 0 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-3189.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.000130' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) = '183.992640' AND `tbv_mon_stok`.`TK_MAIN` = 1000 AND `tbv_mon_stok`.`TK_OVER` = 0 AND `tbv_mon_stok`.`TRN_PJG_HR` = 60 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 540 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '34.0727111111' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000116	ABC SAMBAL BTL 335mL	10706	Barang RT - Returnable	0	2142	0	3213	0	24	0	-3189.000000	0.000000	0.000130	0.000000	0	0	183.992640	1000	0	60	540	34.0727111111	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000128 AND `tbv_mon_stok`.`DESK` = 'CERES HAGELSLAG RICE CHOCO CLASSIC PCK 80g' AND `tbv_mon_stok`.`CAT_COD` = '10108' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 11336 AND `tbv_mon_stok`.`PKM` = 3912 AND `tbv_mon_stok`.`PKM_RP` = 44346432 AND `tbv_mon_stok`.`PKM15` = 5868 AND `tbv_mon_stok`.`PKM15_RP` = 66519648 AND `tbv_mon_stok`.`LPP` = 7942 AND `tbv_mon_stok`.`LPP_RP` = 90030512 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '2074.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '23510864.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.067871' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '769.385656' AND `tbv_mon_stok`.`STO` = 29 AND `tbv_mon_stok`.`STO_RP` = 328744 AND CONCAT(`tbv_mon_stok`.`DSI`) = '110.199799' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 624 AND `tbv_mon_stok`.`TRN_PJG_HR` = 60 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '40.8147403704' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000128	CERES HAGELSLAG RICE CHOCO CLASSIC PCK 80g	10108	Barang RT - Returnable	11336	3912	44346432	5868	66519648	7942	90030512	2074.000000	23510864.000000	0.067871	769.385656	29	328744	110.199799	1064	624	60	270	40.8147403704	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000129 AND `tbv_mon_stok`.`DESK` = 'CERES HAGELSLAG RICE CHOCO FESTIVE PCK 80g' AND `tbv_mon_stok`.`CAT_COD` = '10108' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 11336 AND `tbv_mon_stok`.`PKM` = 2456 AND `tbv_mon_stok`.`PKM_RP` = 27841216 AND `tbv_mon_stok`.`PKM15` = 3684 AND `tbv_mon_stok`.`PKM15_RP` = 41761824 AND `tbv_mon_stok`.`LPP` = 3403 AND `tbv_mon_stok`.`LPP_RP` = 38576408 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-281.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-3185416.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.025323' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '287.061528' AND `tbv_mon_stok`.`STO` = 128 AND `tbv_mon_stok`.`STO_RP` = 1451008 AND CONCAT(`tbv_mon_stok`.`DSI`) = '127.506530' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 354 AND `tbv_mon_stok`.`TRN_PJG_HR` = 60 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '47.2246407407' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000129	CERES HAGELSLAG RICE CHOCO FESTIVE PCK 80g	10108	Barang RT - Returnable	11336	2456	27841216	3684	41761824	3403	38576408	-281.000000	-3185416.000000	0.025323	287.061528	128	1451008	127.506530	1064	354	60	270	47.2246407407	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000132 AND `tbv_mon_stok`.`DESK` = 'MONDE BISCUIT BUTTER COOKIES KLG 454g' AND `tbv_mon_stok`.`CAT_COD` = '11106' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 61978 AND `tbv_mon_stok`.`PKM` = 16356 AND `tbv_mon_stok`.`PKM_RP` = 1013712168 AND `tbv_mon_stok`.`PKM15` = 24534 AND `tbv_mon_stok`.`PKM15_RP` = 1520568252 AND `tbv_mon_stok`.`LPP` = 1995 AND `tbv_mon_stok`.`LPP_RP` = 123646110 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-22539.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-1396922142.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.038907' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '2411.378046' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) = '50.055601' AND `tbv_mon_stok`.`TK_MAIN` = 1029 AND `tbv_mon_stok`.`TK_OVER` = 0 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '18.5391114815' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000132	MONDE BISCUIT BUTTER COOKIES KLG 454g	11106	Barang RT - Returnable	61978	16356	1013712168	24534	1520568252	1995	123646110	-22539.000000	-1396922142.000000	0.038907	2411.378046	0	0	50.055601	1029	0	30	270	18.5391114815	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000133 AND `tbv_mon_stok`.`DESK` = 'KHONG GUAN BISCUIT MINI ASSORTED KLG 650g' AND `tbv_mon_stok`.`CAT_COD` = '11101' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 49297 AND `tbv_mon_stok`.`PKM` = 9153 AND `tbv_mon_stok`.`PKM_RP` = 451215441 AND `tbv_mon_stok`.`PKM15` = 13730 AND `tbv_mon_stok`.`PKM15_RP` = 676847810 AND `tbv_mon_stok`.`LPP` = 4916 AND `tbv_mon_stok`.`LPP_RP` = 242344052 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-8813.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-434479109.500000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.087582' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '4317.529854' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) = '54.642874' AND `tbv_mon_stok`.`TK_MAIN` = 1029 AND `tbv_mon_stok`.`TK_OVER` = 82 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '20.2381014815' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000133	KHONG GUAN BISCUIT MINI ASSORTED KLG 650g	11101	Barang RT - Returnable	49297	9153	451215441	13730	676847810	4916	242344052	-8813.500000	-434479109.500000	0.087582	4317.529854	0	0	54.642874	1029	82	30	270	20.2381014815	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000135 AND `tbv_mon_stok`.`DESK` = 'PRONAS CORNED BEEF KLG 198g' AND `tbv_mon_stok`.`CAT_COD` = '11003' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 19974 AND `tbv_mon_stok`.`PKM` = 1214 AND `tbv_mon_stok`.`PKM_RP` = 24248436 AND `tbv_mon_stok`.`PKM15` = 1821 AND `tbv_mon_stok`.`PKM15_RP` = 36372654 AND `tbv_mon_stok`.`LPP` = 186 AND `tbv_mon_stok`.`LPP_RP` = 3715164 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-1635.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-32657490.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) IS NULL AND `tbv_mon_stok`.`TK_MAIN` = 610 AND `tbv_mon_stok`.`TK_OVER` = 18 AND `tbv_mon_stok`.`TRN_PJG_HR` = 120 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 540 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) IS NULL AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000135	PRONAS CORNED BEEF KLG 198g	11003	Barang RT - Returnable	19974	1214	24248436	1821	36372654	186	3715164	-1635.000000	-32657490.000000	0.000000	0.000000	0	0	NULL	610	18	120	540	NULL	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000143 AND `tbv_mon_stok`.`DESK` = 'SUN BUBUR SUSU (EKONOMIS) BERAS MERAH PCK 120g' AND `tbv_mon_stok`.`CAT_COD` = '10302' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 6269 AND `tbv_mon_stok`.`PKM` = 10736 AND `tbv_mon_stok`.`PKM_RP` = 67303984 AND `tbv_mon_stok`.`PKM15` = 16104 AND `tbv_mon_stok`.`PKM15_RP` = 100955976 AND `tbv_mon_stok`.`LPP` = 16698 AND `tbv_mon_stok`.`LPP_RP` = 104679762 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '594.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '3723786.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.200870' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '1259.254030' AND `tbv_mon_stok`.`STO` = 71 AND `tbv_mon_stok`.`STO_RP` = 445099 AND CONCAT(`tbv_mon_stok`.`DSI`) = '78.659050' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 398 AND `tbv_mon_stok`.`TRN_PJG_HR` = 60 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 540 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '14.5664907407' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000143	SUN BUBUR SUSU (EKONOMIS) BERAS MERAH PCK 120g	10302	Barang RT - Returnable	6269	10736	67303984	16104	100955976	16698	104679762	594.000000	3723786.000000	0.200870	1259.254030	71	445099	78.659050	1064	398	60	540	14.5664907407	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000146 AND `tbv_mon_stok`.`DESK` = 'SUN BUBUR SUSU (EKONOMIS) KACANG HIJAU PCK 120g' AND `tbv_mon_stok`.`CAT_COD` = '10302' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 6269 AND `tbv_mon_stok`.`PKM` = 8542 AND `tbv_mon_stok`.`PKM_RP` = 53549798 AND `tbv_mon_stok`.`PKM15` = 12813 AND `tbv_mon_stok`.`PKM15_RP` = 80324697 AND `tbv_mon_stok`.`LPP` = 10577 AND `tbv_mon_stok`.`LPP_RP` = 66307213 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-2236.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-14017484.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.118123' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '740.513087' AND `tbv_mon_stok`.`STO` = 53 AND `tbv_mon_stok`.`STO_RP` = 332257 AND CONCAT(`tbv_mon_stok`.`DSI`) = '84.876027' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 225 AND `tbv_mon_stok`.`TRN_PJG_HR` = 60 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 540 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '15.7177827778' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000146	SUN BUBUR SUSU (EKONOMIS) KACANG HIJAU PCK 120g	10302	Barang RT - Returnable	6269	8542	53549798	12813	80324697	10577	66307213	-2236.000000	-14017484.000000	0.118123	740.513087	53	332257	84.876027	1064	225	60	540	15.7177827778	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000159 AND `tbv_mon_stok`.`DESK` = 'VICKS INHALER OBAT FLU TUB' AND `tbv_mon_stok`.`CAT_COD` = '21504' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang Putus - Non returnable' AND `tbv_mon_stok`.`ACOST` = 15267 AND `tbv_mon_stok`.`PKM` = 5350 AND `tbv_mon_stok`.`PKM_RP` = 81678450 AND `tbv_mon_stok`.`PKM15` = 8025 AND `tbv_mon_stok`.`PKM15_RP` = 122517675 AND `tbv_mon_stok`.`LPP` = 5902 AND `tbv_mon_stok`.`LPP_RP` = 90105834 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-2123.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-32411841.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.083278' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '1271.405226' AND `tbv_mon_stok`.`STO` = 29 AND `tbv_mon_stok`.`STO_RP` = 442743 AND CONCAT(`tbv_mon_stok`.`DSI`) = '66.279347' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 211 AND `tbv_mon_stok`.`TRN_PJG_HR` = 120 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 360 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '18.4109297222' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000159	VICKS INHALER OBAT FLU TUB	21504	Barang Putus - Non returnable	15267	5350	81678450	8025	122517675	5902	90105834	-2123.000000	-32411841.000000	0.083278	1271.405226	29	442743	66.279347	1070	211	120	360	18.4109297222	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000172 AND `tbv_mon_stok`.`DESK` = 'KOPIKO CANDY PCK 105g' AND `tbv_mon_stok`.`CAT_COD` = '11204' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 6892 AND `tbv_mon_stok`.`PKM` = 6469 AND `tbv_mon_stok`.`PKM_RP` = 44584348 AND `tbv_mon_stok`.`PKM15` = 9704 AND `tbv_mon_stok`.`PKM15_RP` = 66879968 AND `tbv_mon_stok`.`LPP` = 9671 AND `tbv_mon_stok`.`LPP_RP` = 66652532 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-32.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '-223990.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.296938' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '2046.496696' AND `tbv_mon_stok`.`STO` = 149 AND `tbv_mon_stok`.`STO_RP` = 1026908 AND CONCAT(`tbv_mon_stok`.`DSI`) = '30.762540' AND `tbv_mon_stok`.`TK_MAIN` = 1070 AND `tbv_mon_stok`.`TK_OVER` = 512 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '11.3935333333' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000172	KOPIKO CANDY PCK 105g	11204	Barang RT - Returnable	6892	6469	44584348	9704	66879968	9671	66652532	-32.500000	-223990.000000	0.296938	2046.496696	149	1026908	30.762540	1070	512	30	270	11.3935333333	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000175 AND `tbv_mon_stok`.`DESK` = 'NISSIN WAFER CHOCOLATE PCK 110g' AND `tbv_mon_stok`.`CAT_COD` = '11102' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 5889 AND `tbv_mon_stok`.`PKM` = 7218 AND `tbv_mon_stok`.`PKM_RP` = 42506802 AND `tbv_mon_stok`.`PKM15` = 10827 AND `tbv_mon_stok`.`PKM15_RP` = 63760203 AND `tbv_mon_stok`.`LPP` = 15901 AND `tbv_mon_stok`.`LPP_RP` = 93640989 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '5074.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '29880786.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.252549' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '1487.261061' AND `tbv_mon_stok`.`STO` = 12 AND `tbv_mon_stok`.`STO_RP` = 70668 AND CONCAT(`tbv_mon_stok`.`DSI`) = '59.502339' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 672 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 270 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '22.0379033333' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000175	NISSIN WAFER CHOCOLATE PCK 110g	11102	Barang RT - Returnable	5889	7218	42506802	10827	63760203	15901	93640989	5074.000000	29880786.000000	0.252549	1487.261061	12	70668	59.502339	1064	672	30	270	22.0379033333	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000178 AND `tbv_mon_stok`.`DESK` = 'BIMOLI MINYAK GORENG BTL 2000mL' AND `tbv_mon_stok`.`CAT_COD` = '10601' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 0 AND `tbv_mon_stok`.`PKM` = 54 AND `tbv_mon_stok`.`PKM_RP` = 0 AND `tbv_mon_stok`.`PKM15` = 81 AND `tbv_mon_stok`.`PKM15_RP` = 0 AND `tbv_mon_stok`.`LPP` = 0 AND `tbv_mon_stok`.`LPP_RP` = 0 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-81.000000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 0 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) IS NULL AND `tbv_mon_stok`.`TK_MAIN` = 6 AND `tbv_mon_stok`.`TK_OVER` = 0 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 540 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) IS NULL AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000178	BIMOLI MINYAK GORENG BTL 2000mL	10601	Barang RT - Returnable	0	54	0	81	0	0	0	-81.000000	0.000000	0.000000	0.000000	0	0	NULL	6	0	30	540	NULL	DRY	2026-11-01
Edit	Copy	Delete DELETE FROM tbv_mon_stok WHERE `tbv_mon_stok`.`PRDCD` = 10000181 AND `tbv_mon_stok`.`DESK` = 'BIMOLI MINYAK GORENG DRG 5000mL' AND `tbv_mon_stok`.`CAT_COD` = '10601' AND `tbv_mon_stok`.`KRITERIA_ITEM` = 'Barang RT - Returnable' AND `tbv_mon_stok`.`ACOST` = 0 AND `tbv_mon_stok`.`PKM` = 7827 AND `tbv_mon_stok`.`PKM_RP` = 0 AND `tbv_mon_stok`.`PKM15` = 11741 AND `tbv_mon_stok`.`PKM15_RP` = 0 AND `tbv_mon_stok`.`LPP` = 1017 AND `tbv_mon_stok`.`LPP_RP` = 0 AND CONCAT(`tbv_mon_stok`.`OVER15`) = '-10723.500000' AND CONCAT(`tbv_mon_stok`.`OVER15_RP`) = '0.000000' AND CONCAT(`tbv_mon_stok`.`SPD`) = '0.162901' AND CONCAT(`tbv_mon_stok`.`SPD_RP`) = '0.000000' AND `tbv_mon_stok`.`STO` = 720 AND `tbv_mon_stok`.`STO_RP` = 0 AND CONCAT(`tbv_mon_stok`.`DSI`) = '6.242535' AND `tbv_mon_stok`.`TK_MAIN` = 1064 AND `tbv_mon_stok`.`TK_OVER` = 12 AND `tbv_mon_stok`.`TRN_PJG_HR` = 30 AND `tbv_mon_stok`.`MAX_DC_TRIM_HR` = 540 AND CONCAT(`tbv_mon_stok`.`PER_UMUR`) = '1.1560250000' AND `tbv_mon_stok`.`JENIS_PROD` = 'DRY' AND `tbv_mon_stok`.`TGL_HR` = '2026-11-01' LIMIT 1	10000181	BIMOLI MINYAK GORENG DRG 5000mL	10601	Barang RT - Returnable	0	7827	0	11741	0	1017	0	-10723.500000	0.000000	0.162901	0.000000	720	0	6.242535	1064	12	30	540	1.1560250000	DRY	2026-11-01

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view