Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `tbv_nrb_dc`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts WIL KD_TOKO NAMA_TOKO INIT_AM INIT_AS TGL_NRB NO_NRB ITEM_TK QTY_TK GROSS_TK KETERANGAN GUDANG NO_BPB TGL_BPB HDR_TGL_INV ITEM_DC QTY_DC GROSS_DC REF3 BRD_KETER
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T1V9' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'FRANS KAISEIPO' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'AYO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 539 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 14 AND `tbv_nrb_dc`.`GROSS_TK` = 28 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T1V95392026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T1V9 FRANS KAISEIPO WHI AYO 2026-11-01 539 1 14 28 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T1V95392026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T224' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'FUNDAR SAKELA' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WNO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 616 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 8 AND `tbv_nrb_dc`.`GROSS_TK` = 16 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2246162026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T224 FUNDAR SAKELA WHI WNO 2026-11-01 616 1 8 16 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T2246162026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T224' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'FUNDAR SAKELA' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WNO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 617 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 2 AND `tbv_nrb_dc`.`GROSS_TK` = 4 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2246172026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T224 FUNDAR SAKELA WHI WNO 2026-11-01 617 1 2 4 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T2246172026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T224' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'FUNDAR SAKELA' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WNO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 618 AND `tbv_nrb_dc`.`ITEM_TK` = 4 AND `tbv_nrb_dc`.`QTY_TK` = 14 AND `tbv_nrb_dc`.`GROSS_TK` = 257786 AND `tbv_nrb_dc`.`KETERANGAN` = '03040000 RUSAK PABRIK' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2246182026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T224 FUNDAR SAKELA WHI WNO 2026-11-01 618 4 14 257786 03040000 RUSAK PABRIK G236 NULL NULL NULL NULL NULL NULL T2246182026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T2EX' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'POROS MAKBALIM' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 492 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 14 AND `tbv_nrb_dc`.`GROSS_TK` = 28 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2EX4922026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T2EX POROS MAKBALIM WHI BGS 2026-11-01 492 1 14 28 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T2EX4922026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T2EX' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'POROS MAKBALIM' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 494 AND `tbv_nrb_dc`.`ITEM_TK` = 9 AND `tbv_nrb_dc`.`QTY_TK` = 9 AND `tbv_nrb_dc`.`GROSS_TK` = 154116 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2EX4942026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T2EX POROS MAKBALIM WHI BGS 2026-11-01 494 9 9 154116 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T2EX4942026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T2EX' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'POROS MAKBALIM' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 495 AND `tbv_nrb_dc`.`ITEM_TK` = 2 AND `tbv_nrb_dc`.`QTY_TK` = 3 AND `tbv_nrb_dc`.`GROSS_TK` = 16563 AND `tbv_nrb_dc`.`KETERANGAN` = '03090000 KEMASAN' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2EX4952026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T2EX POROS MAKBALIM WHI BGS 2026-11-01 495 2 3 16563 03090000 KEMASAN G236 NULL NULL NULL NULL NULL NULL T2EX4952026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T2EX' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'POROS MAKBALIM' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 496 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 4 AND `tbv_nrb_dc`.`GROSS_TK` = 17816 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2EX4962026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T2EX POROS MAKBALIM WHI BGS 2026-11-01 496 1 4 17816 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T2EX4962026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T2EX' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'POROS MAKBALIM' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 497 AND `tbv_nrb_dc`.`ITEM_TK` = 5 AND `tbv_nrb_dc`.`QTY_TK` = 10 AND `tbv_nrb_dc`.`GROSS_TK` = 109363 AND `tbv_nrb_dc`.`KETERANGAN` = '04070101 REGULER' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T2EX4972026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T2EX POROS MAKBALIM WHI BGS 2026-11-01 497 5 10 109363 04070101 REGULER G236 NULL NULL NULL NULL NULL NULL T2EX4972026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T3PP' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI RUKO B-D' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WIN' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 886 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 1 AND `tbv_nrb_dc`.`GROSS_TK` = 14979 AND `tbv_nrb_dc`.`KETERANGAN` = '04030000 PERUBAHAN KATEGORI' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T3PP8862026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T3PP AHMAD YANI RUKO B-D WHI WIN 2026-11-01 886 1 1 14979 04030000 PERUBAHAN KATEGORI G236 NULL NULL NULL NULL NULL NULL T3PP8862026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T3PP' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI RUKO B-D' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WIN' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 887 AND `tbv_nrb_dc`.`ITEM_TK` = 2 AND `tbv_nrb_dc`.`QTY_TK` = 8 AND `tbv_nrb_dc`.`GROSS_TK` = 51412 AND `tbv_nrb_dc`.`KETERANGAN` = '03050000 PERISHABLE' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T3PP8872026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T3PP AHMAD YANI RUKO B-D WHI WIN 2026-11-01 887 2 8 51412 03050000 PERISHABLE G236 NULL NULL NULL NULL NULL NULL T3PP8872026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T3PP' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI RUKO B-D' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WIN' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 888 AND `tbv_nrb_dc`.`ITEM_TK` = 2 AND `tbv_nrb_dc`.`QTY_TK` = 4 AND `tbv_nrb_dc`.`GROSS_TK` = 35008 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T3PP8882026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T3PP AHMAD YANI RUKO B-D WHI WIN 2026-11-01 888 2 4 35008 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T3PP8882026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T3PP' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI RUKO B-D' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WIN' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 889 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 1 AND `tbv_nrb_dc`.`GROSS_TK` = 34179 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T3PP8892026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T3PP AHMAD YANI RUKO B-D WHI WIN 2026-11-01 889 1 1 34179 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T3PP8892026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T3PP' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI RUKO B-D' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WIN' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 890 AND `tbv_nrb_dc`.`ITEM_TK` = 7 AND `tbv_nrb_dc`.`QTY_TK` = 14 AND `tbv_nrb_dc`.`GROSS_TK` = 71413 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T3PP8902026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T3PP AHMAD YANI RUKO B-D WHI WIN 2026-11-01 890 7 14 71413 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T3PP8902026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T3PP' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI RUKO B-D' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WIN' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 891 AND `tbv_nrb_dc`.`ITEM_TK` = 3 AND `tbv_nrb_dc`.`QTY_TK` = 3 AND `tbv_nrb_dc`.`GROSS_TK` = 27289 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T3PP8912026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T3PP AHMAD YANI RUKO B-D WHI WIN 2026-11-01 891 3 3 27289 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T3PP8912026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T4VV' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AM SANGAJI' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'JML' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 694 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 12 AND `tbv_nrb_dc`.`GROSS_TK` = 24 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T4VV6942026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T4VV AM SANGAJI WHI JML 2026-11-01 694 1 12 24 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T4VV6942026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T4ZW' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'BASUKI RAHMAT' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WNO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 330 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 16 AND `tbv_nrb_dc`.`GROSS_TK` = 32 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T4ZW3302026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T4ZW BASUKI RAHMAT WHI WNO 2026-11-01 330 1 16 32 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T4ZW3302026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T4ZW' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'BASUKI RAHMAT' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'WNO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 331 AND `tbv_nrb_dc`.`ITEM_TK` = 7 AND `tbv_nrb_dc`.`QTY_TK` = 43 AND `tbv_nrb_dc`.`GROSS_TK` = 220068 AND `tbv_nrb_dc`.`KETERANGAN` = '04070101 REGULER' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T4ZW3312026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T4ZW BASUKI RAHMAT WHI WNO 2026-11-01 331 7 43 220068 04070101 REGULER G236 NULL NULL NULL NULL NULL NULL T4ZW3312026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T6RD' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'BASUKI RAHMAT KM 7 NO. 9' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'AYO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 387 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 11 AND `tbv_nrb_dc`.`GROSS_TK` = 22 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T6RD3872026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T6RD BASUKI RAHMAT KM 7 NO. 9 WHI AYO 2026-11-01 387 1 11 22 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T6RD3872026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T7TW' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'BUNCIS MALAWELA' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 497 AND `tbv_nrb_dc`.`ITEM_TK` = 8 AND `tbv_nrb_dc`.`QTY_TK` = 11 AND `tbv_nrb_dc`.`GROSS_TK` = 99137 AND `tbv_nrb_dc`.`KETERANGAN` = '03100000 DIGIGIT TIKUS DAN SERANGGA' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T7TW4972026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T7TW BUNCIS MALAWELA WHI BGS 2026-11-01 497 8 11 99137 03100000 DIGIGIT TIKUS DAN SERANGGA G236 NULL NULL NULL NULL NULL NULL T7TW4972026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T7TW' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'BUNCIS MALAWELA' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 498 AND `tbv_nrb_dc`.`ITEM_TK` = 4 AND `tbv_nrb_dc`.`QTY_TK` = 5 AND `tbv_nrb_dc`.`GROSS_TK` = 82269 AND `tbv_nrb_dc`.`KETERANGAN` = '03090000 KEMASAN' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T7TW4982026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T7TW BUNCIS MALAWELA WHI BGS 2026-11-01 498 4 5 82269 03090000 KEMASAN G236 NULL NULL NULL NULL NULL NULL T7TW4982026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T7ZK' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'POROS MAKBUSUN' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'BGS' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 614 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 12 AND `tbv_nrb_dc`.`GROSS_TK` = 24 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T7ZK6142026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T7ZK POROS MAKBUSUN WHI BGS 2026-11-01 614 1 12 24 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T7ZK6142026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T84M' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'AHMAD YANI 41' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'AYO' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 786 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 9 AND `tbv_nrb_dc`.`GROSS_TK` = 18 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T84M7862026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T84M AHMAD YANI 41 WHI AYO 2026-11-01 786 1 9 18 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T84M7862026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T86S' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'RAYA AM SANGAJI' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'JML' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 488 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 11 AND `tbv_nrb_dc`.`GROSS_TK` = 22 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T86S4882026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T86S RAYA AM SANGAJI WHI JML 2026-11-01 488 1 11 22 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T86S4882026-11-01 INTRANSIT
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_nrb_dc WHERE `tbv_nrb_dc`.`WIL` = 'SON' AND `tbv_nrb_dc`.`KD_TOKO` = 'T9KC' AND `tbv_nrb_dc`.`NAMA_TOKO` = 'KLAMALU' AND `tbv_nrb_dc`.`INIT_AM` = 'WHI' AND `tbv_nrb_dc`.`INIT_AS` = 'MHA' AND `tbv_nrb_dc`.`TGL_NRB` = '2026-11-01' AND `tbv_nrb_dc`.`NO_NRB` = 549 AND `tbv_nrb_dc`.`ITEM_TK` = 1 AND `tbv_nrb_dc`.`QTY_TK` = 11 AND `tbv_nrb_dc`.`GROSS_TK` = 22 AND `tbv_nrb_dc`.`KETERANGAN` = '04120000 SARANA_K' AND `tbv_nrb_dc`.`GUDANG` = 'G236' AND `tbv_nrb_dc`.`NO_BPB` IS NULL AND `tbv_nrb_dc`.`TGL_BPB` IS NULL AND `tbv_nrb_dc`.`HDR_TGL_INV` IS NULL AND CONCAT(`tbv_nrb_dc`.`ITEM_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`QTY_DC`) IS NULL AND CONCAT(`tbv_nrb_dc`.`GROSS_DC`) IS NULL AND `tbv_nrb_dc`.`REF3` = 'T9KC5492026-11-01' AND `tbv_nrb_dc`.`BRD_KETER` = 'INTRANSIT' LIMIT 1
SON T9KC KLAMALU WHI MHA 2026-11-01 549 1 11 22 04120000 SARANA_K G236 NULL NULL NULL NULL NULL NULL T9KC5492026-11-01 INTRANSIT
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query