Recent
Favorites
  • There are no favorite tables.

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: get_data_from_bc »Table: pts_header
Page-related settingsClick 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (16000 total, Query took 0.0210 seconds.)
SELECT * FROM `pts_header`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsodata_etagNoTransfer_from_CodeTransfer_to_CodeDirect_TransferIn_Transit_CodeTransfer_Order_NoTransfer_Order_DatePosting_DateShortcut_Dimension_1_CodeShortcut_Dimension_2_CodeProd_Order_NoDemand_Order_NoWarnaNoteExternal_Document_NoShipment_DateShipment_Method_CodeShipping_Agent_CodeShipping_Agent_Service_CodeReceipt_DateTransfer_from_NameTransfer_from_Name_2Transfer_from_AddressTransfer_from_Address_2Transfer_from_CityTransfer_from_CountyTransfer_from_Post_CodeTrsf_from_Country_Region_CodeTransfer_from_ContactTransfer_to_NameTransfer_to_Name_2Transfer_to_AddressTransfer_to_Address_2Transfer_to_CityTransfer_to_CountyTransfer_to_Post_CodeTrsf_to_Country_Region_CodeTransfer_to_ContactTransaction_TypeTransaction_SpecificationTransport_MethodAreaEntry_Exit_PointPartner_VAT_ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0008\'
W/"JzIwOzExMjgyNTUyNzY4NTE5MDQzMjU1MTswMDsn" AA/SJ/TO/23/10/0008 WH-PCT WH-ALW-AST 0 WH-TRANSIT TO/PCT/23/10/002 2023-10-03 2023-10-03 K. 272 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ASTRAL WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0009\'
W/"JzIwOzE2MjE4MjA4MTQyMjk0ODM2NTE5MTswMDsn" AA/SJ/TO/23/10/0009 WH-PCT WH-ALW-AST 0 WH-TRANSIT TO/PCT/23/10/003 2023-10-03 2023-10-03 K. 70 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ASTRAL WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0010\'
W/"JzE5OzUwOTM2MjIwNDAxNTYyNDM2MjExOzAwOyc=" AA/SJ/TO/23/10/0010 WH-PCT WH-ALW-PFP 0 WH-TRANSIT TO/PCT/23/10/004 2023-10-03 2023-10-03 K. 70 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA POLARISA INTERIOR WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0011\'
W/"JzE5OzcwMjM1MTU3NjU5ODg4NjEwNjUxOzAwOyc=" AA/SJ/TO/23/10/0011 WH-PCT WH-ALW-DEL 0 WH-TRANSIT TO/PCT/23/10/005 2023-10-03 2023-10-03 K. 925 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA HRB DELFT MAKASSAR WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0012\'
W/"JzE5OzE1Njg0MjExMjMxNDgyNzM3MzUxOzAwOyc=" AA/SJ/TO/23/10/0012 WH-PCT WH-ALW-PFP 0 WH-TRANSIT TO/PCT/23/10/006 2023-10-03 2023-10-03 K. 070 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA POLARISA INTERIOR WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0013\'
W/"JzE5OzI3ODc1NTc5NTg3MjU3MDcxODIxOzAwOyc=" AA/SJ/TO/23/10/0013 WH-PCT WH-ALW-RSD 0 WH-TRANSIT TO/PCT/23/10/007 2023-10-03 2023-10-03 K. 070 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA RESIDENTIAL WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0014\'
W/"JzIwOzE0MzE2NDM3OTMzNzcxMTg1NTU0MTswMDsn" AA/SJ/TO/23/10/0014 WH-PCT WH-ALW-ABO 0 WH-TRANSIT TO/PCT/23/10/008 2023-10-03 2023-10-03 K. 70 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ASTRAL BRAVO WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0015\'
W/"JzIwOzExMDQ3NTU2NjI1OTcyNTg2NDYzMTswMDsn" AA/SJ/TO/23/10/0015 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/009 2023-10-03 2023-10-03 K. 329 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0016\'
W/"JzIwOzEyNTY1NTU5MzMxODI1MTI4MjU0MTswMDsn" AA/SJ/TO/23/10/0016 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/010 2023-10-03 2023-10-03 K. 55 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0017\'
W/"JzE5OzI4OTg1OTI1MDQwMTk2MjI0OTkxOzAwOyc=" AA/SJ/TO/23/10/0017 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/011 2023-10-03 2023-10-03 K. 1060 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0018\'
W/"JzIwOzEyODk4NTIwNDc1OTA0OTYwNDczMTswMDsn" AA/SJ/TO/23/10/0018 WH-PCT WH-ALW-ABO 0 WH-TRANSIT TO/PCT/23/10/012 2023-10-03 2023-10-03 K. 02 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ASTRAL BRAVO WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0019\'
W/"JzIwOzEzNTI1NjgxNDEzMjAzMTM5ODcwMTswMDsn" AA/SJ/TO/23/10/0019 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/013 2023-10-03 2023-10-03 K. 249 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0021\'
W/"JzE5OzU2MjM0NDMwMDc2MTkxODI0NTMxOzAwOyc=" AA/SJ/TO/23/10/0021 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/015 2023-10-03 2023-10-03 K. 249 2023-10-03 2023-10-03 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0022\'
W/"JzIwOzEzMzQ5Mjk2NjQ3Njg0MzE5MjQzMTswMDsn" AA/SJ/TO/23/10/0022 WH-ALU-MF WH-PCT 0 WH-TRANSIT TO/ALU/23/10/0013 2023-10-03 2023-10-03 2023-10-03 2023-10-03 WH ALUMINIUM MF WS PRODUKSI POWDER COATING WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0023\'
W/"JzE5OzQ0MjU1Nzg0NTY1NTYzMjM1NTUxOzAwOyc=" AA/SJ/TO/23/10/0023 WH-ALU-MF WH-PCT 0 WH-TRANSIT TO/ALU/23/10/0004 2023-10-03 2023-10-03 2023-10-03 2023-10-02 WH ALUMINIUM MF WS PRODUKSI POWDER COATING WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0024\'
W/"JzE5OzQxNzE1MDYxODE1ODgxNDk2MjkxOzAwOyc=" AA/SJ/TO/23/10/0024 FG-MAX ST-M10-CBB 0 WH-TRANSIT TO/HO/MAX/23/10/002 2023-10-02 2023-10-02 KIRIM KE MITRA 10 CIBUBUR PO CB 1402474 2023-10-02 DIKIRIM WS BUDI B9531UAR 2023-10-02 WH FG ALPHAMAX WS STORE MITRA 10 CIBUBUR JL. ALTERNATIF CIBUBUR NO.KM, RW.4, NAGRAK, KEC. J... BEKASI BOGOR 17435 ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0025\'
W/"JzIwOzEzNTg5ODU0MDIxMDcwNjk5ODg1MTswMDsn" AA/SJ/TO/23/10/0025 FG-MAX ST-M10-CBB 0 WH-TRANSIT TO/HO/MAX/23/10/004 2023-10-03 2023-10-03 KIRIM KE MITRA 10 CIBUBUR PO CB 1403375 2023-10-03 DIKIRIM WS MARNO B9914UAL 2023-10-06 WH FG ALPHAMAX WS STORE MITRA 10 CIBUBUR JL. ALTERNATIF CIBUBUR NO.KM, RW.4, NAGRAK, KEC. J... BEKASI BOGOR 17435 ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0026\'
W/"JzIwOzEwMTA0MDc3OTcxMDE4NjYzMDQ0MTswMDsn" AA/SJ/TO/23/10/0026 FG-MAX ST-M10-BGR 0 WH-TRANSIT TO/HO/MAX/23/09/004 2023-10-03 2023-10-03 CO 28.09.2023 2023-10-03 DIKIRIM WS MARNO B9914UAL 2023-09-30 WH FG ALPHAMAX WS STORE MITRA 10 BOGOR JL. BARU - BOGOR, RT.04/RW.09, KEDUNGBADAK, KEC. T... BOGOR BOGOR 16164 ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0027\'
W/"JzE5OzgzOTY2NzY1NjU2Mzg4ODgyOTUxOzAwOyc=" AA/SJ/TO/23/10/0027 FG-MAX ST-M10-CBB 0 WH-TRANSIT TO/HO/MAX/23/10/016 2023-10-02 2023-10-02 STOK 02-10-23 KIRIM KE MITRA 10 CIBUBUR PO STOK 02-10-2023 2023-10-02 DIKIRIM WS MARNO B9914UAL 2023-10-06 WH FG ALPHAMAX WS STORE MITRA 10 CIBUBUR JL. ALTERNATIF CIBUBUR NO.KM, RW.4, NAGRAK, KEC. J... BEKASI BOGOR 17435 ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0028\'
W/"JzIwOzE3NTI2NDc1NDY1NTkwMDIxODIxMTswMDsn" AA/SJ/TO/23/10/0028 FG-MAX ST-SAB 0 WH-TRANSIT TO/HO/MAX/23/10/019 2023-10-02 2023-10-02 KIRIM KE SINAR ABADI BOGOR PO-HO/2310/35688 2023-10-04 DIKIRIM WS BUDI B9531UAR 2023-10-02 WH FG ALPHAMAX WS STORE SINAR ABADI BOGOR JL. PAHLAWAN SINDANG RAYA NO.175, RT01/RW06, BONDO... BOGOR JAWA BARAT 16131 ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0029\'
W/"JzIwOzE0MjY5NTc2MDIwMDg5MDI3MDM5MTswMDsn" AA/SJ/TO/23/10/0029 FG-MAX ST-M10-CBG 0 WH-TRANSIT TO/HO/MAX/23/10/030 2023-10-03 2023-10-03 KIRIM KE MITRA 10 CIBINONG PO CG 111820 2023-10-04 DIKIRIM WS BUDI B9531UAR 2023-10-04 WH FG ALPHAMAX WS STORE MITRA 10 CIBINONG JL. RAYA JAKARTA BOGOR - KM 41.5, CIBINONG, BOGOR BOGOR BOGOR 16918 ID
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0030\'
W/"JzIwOzE1MzQxMjQ1MzU1NTcxNzcyNTQ3MTswMDsn" AA/SJ/TO/23/10/0030 WH-ALW-PKC PROD-PKC 0 WH-TRANSIT TO/ALU/23/10/0011 2023-10-04 2023-10-04 2023-10-04 2023-10-03 WH ALU WARNA POLARISA KITCHEN WS PRODUKSI POLARISA KITCHEN WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0031\'
W/"JzE5OzEzNzE3ODUxMzg2OTQ2OTU3NTcxOzAwOyc=" AA/SJ/TO/23/10/0031 WH-ALU-MF PROD-HATP 0 WH-TRANSIT TO/ALU/23/10/0001 2023-10-02 2023-10-02 2023-10-02 2023-10-02 WH ALUMINIUM MF WS PRODUKSI HRB ANTASARI PLACE WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0032\'
W/"JzE5Ozg3MDQ4MTkyMDkxNDM3NjU4MTAxOzAwOyc=" AA/SJ/TO/23/10/0032 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/016 2023-10-04 2023-10-04 K. 249 2023-10-04 2023-10-04 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
Edit EditCopy CopyDelete Delete
DELETE FROM `pts_header` WHERE `pts_header`.`No` = \'AA/SJ/TO/23/10/0033\'
W/"JzE5OzUyMjg2NDE3NDY5MzM0NzE4MzMxOzAwOyc=" AA/SJ/TO/23/10/0033 WH-PCT WH-ALW-MAX 0 WH-TRANSIT TO/PCT/23/10/017 2023-10-04 2023-10-04 K. 925 2023-10-04 2023-10-04 PRODUKSI POWDER COATING WS WH ALU WARNA ALPHAMAX WS
With selected: With selected:

|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query