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 `stransbanco`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts _recno FTB_BANCO FTB_TIPO FTB_FECHA FTB_STATUS FTB_FECHALIBERACION FTB_STATUSLIBERACION FTB_DOCUMENTO FTB_MONTO FTB_FACTORORIGINAL FTB_IMPUESTO FTB_BENEFICIARIO FTB_CODEBENEFICIARIO FTB_ORIGENBENEFICIARIO FTB_CONCEPTO FTB_CODECONCEPTO FTB_MEMODETALLE FTB_NROCOMPROBANTE FTB_ESDEBITOBANCARIO FTB_ESCHEQUEDEVUELTO FTB_FECHACONCILIACION FTB_NUMEROCONCILIACION FTB_SALDOANTERIOR FTB_AUTOINCREMENTORIGEN BASE_AUTOINCREMENT FTB_MONEDAORIGINAL FTB_CONTABILIZADO FTB_USER FTB_HORAOPERACION FTB_CLASIFICACION FTB_CTOCOSTO FTB_TIPOENDOSO FTB_SUCURSALORIGEN
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 1
1 0102-0645-6300-0018-9976 3 2023-09-30 00:00:00 X 2023-09-30 00:00:00 0 INICIO 12.45 1 0 MOVIMIENTO DE APERTURA NULL 0 MOVIMIENTO DE APERTURA DE CUENTA NULL NULL NULL NULL NULL 2023-09-30 NULL NULL NULL 1 1 NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 2
2 0108-0029-36-0100468865 3 1899-12-30 00:00:00 X 1899-12-30 00:00:00 0 INICIO 150500.23 1 0 MOVIMIENTO DE APERTURA NULL 0 MOVIMIENTO DE APERTURA DE CUENTA NULL NULL NULL NULL NULL 1899-12-30 NULL NULL NULL 3 1 NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 3
3 0108-0029-3601-0046-8865 3 2023-09-30 00:00:00 X 2023-09-30 00:00:00 0 INICIO 150500.23 1 0 MOVIMIENTO DE APERTURA NULL 0 MOVIMIENTO DE APERTURA DE CUENTA NULL NULL NULL NULL NULL 2023-09-30 NULL NULL NULL 6 1 NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 4
4 0134-0363-5336-3130-6986 1 2023-10-06 00:00:00 X 2023-10-06 00:00:00 0 00000867 187.65 1 NULL NULL NULL 0 Débito bancario, documento #325442 Monto : 9382,5 NULL CACHAPERA DAME OTRA 325442 1 NULL 2023-10-31 160623954 788827 1074 1075 1 1 3 07:17:50 26 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 5
5 0134-0363-5336-3130-6986 1 2023-10-06 00:00:00 X 2023-10-06 00:00:00 0 325442 9382.5 1 187.65 NULL NULL 0 CACHAPERA DAME OTRA NULL CACHAPERA DAME OTRA 00000866 NULL 0 2023-10-31 160623954 788827 0 1074 1 1 3 07:17:50 26 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 6
6 0134-0363-5336-3130-6986 2 2023-10-06 00:00:00 X 2023-10-06 00:00:00 0 034915 22935 1 0 NULL NULL 0 DISTRIBUCIONES R S, C.A PAGO FAC:00005248 NULL DISTRIBUCIONES R S, C.A PAGO FAC:00005248 00000047 NULL 0 2023-10-31 160623954 765892 0 1073 1 1 3 07:15:57 26 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 7
7 0134-0363-5336-3130-6986 2 2023-10-31 00:00:00 X 2023-10-31 00:00:00 0 251640 14843.87 1 0 NULL NULL 0 HAOSEN WU, C.A PAGOXAdelanto NULL HAOSEN WU, C.A PAGOXAdelanto 00000096 NULL 0 2023-10-31 160623954 710205.26 0 1324 1 1 3 16:02:40 26 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 8
8 0134-0363-5336-3130-6986 3 2023-09-30 00:00:00 X 2023-09-30 00:00:00 0 INICIO 84606.3 1 0 MOVIMIENTO DE APERTURA NULL 0 MOVIMIENTO DE APERTURA DE CUENTA NULL NULL NULL NULL NULL 2023-09-30 NULL NULL NULL 15 1 NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 9
9 0134-0363-5336-3130-6986 3 2023-10-04 00:00:00 X 2023-10-04 00:00:00 0 000002 136691.2 1 0 NULL NULL 0 PAGOS RECHAZADOS POR EL BANCO - TRNASPORTE MAFER NULL PAGOS RECHAZADOS POR EL BANCO - TRNASPORTE MAFER 00000017 NULL 0 2023-10-31 160623954 591690 0 1066 1 1 2 11:33:45 1 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 10
10 0134-0363-5336-3130-6986 3 2023-10-04 00:00:00 X 2023-10-04 00:00:00 0 762593 103.98 1 0 NULL NULL 0 COMERCIAL HERMOSA, PAGO  4810 NULL COMERCIAL HERMOSA, PAGO  4810 00000018 NULL 0 2023-10-31 160623954 728381.2 0 1067 1 1 2 11:57:07 1 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 11
11 0134-0363-5336-3130-6986 2 2023-10-31 00:00:00 X 2023-10-31 00:00:00 0 643925 11065.95 1 0 NULL NULL 0 COMERCIAL CHINATOWN 2019, C.A PAGOXAdelanto NULL COMERCIAL CHINATOWN 2019, C.A PAGOXAdelanto 00000097 NULL 0 2023-10-31 160623954 726980.23 0 1407 1 1 2 11:27:42 26 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 12
12 0163-0903-6490-3300-6791 3 2023-07-31 00:00:00 X 2023-07-31 00:00:00 0 INICIO 33686.86 1 0 MOVIMIENTO DE APERTURA NULL 0 MOVIMIENTO DE APERTURA DE CUENTA NULL NULL NULL NULL NULL 2023-07-31 NULL NULL NULL 5 1 NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 13
13 0191-0106-1921-0002-0338 1 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 021002 3098.7 1 61.97 NULL NULL 0 TM - PEDRO LOPEZ VIATICOS CCS NULL TM - PEDRO LOPEZ VIATICOS CCS 00000001 NULL 0 2023-10-31 1257785542 239045.54 0 7 1 1 3 14:19:47 25 01001 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 14
14 0191-0106-1921-0002-0338 1 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 00000002 61.97 1 NULL NULL NULL 0 Débito bancario, documento #021002 Monto : 3098,7 NULL TM - PEDRO LOPEZ VIATICOS CCS 021002 1 NULL 2023-10-31 1257785542 239045.54 7 8 1 1 3 14:19:47 25 01001 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 15
15 0191-0106-1921-0002-0338 1 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 102355 103290 1 2065.8 NULL NULL 0 XOUBA CONTRATISTA NULL XOUBA CONTRATISTA 00000003 NULL 0 2023-10-31 1257785542 235884.87 0 12 1 1 3 14:25:59 26 01001 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 16
16 0191-0106-1921-0002-0338 1 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 00000004 2065.8 1 NULL NULL NULL 0 Débito bancario, documento #102355 Monto : 103290 NULL XOUBA CONTRATISTA 102355 1 NULL 2023-10-31 1257785542 235884.87 12 13 1 1 3 14:25:59 26 01001 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 17
17 0191-0106-1921-0002-0338 3 2023-09-30 00:00:00 X 2023-09-30 00:00:00 0 INICIO 239045.54 1 0 MOVIMIENTO DE APERTURA NULL 0 MOVIMIENTO DE APERTURA DE CUENTA NULL NULL NULL NULL NULL 2023-09-30 NULL NULL NULL 2 1 NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 18
18 0191-0106-1921-0002-0338 1 2023-11-01 00:00:00 X 2023-11-01 00:00:00 0 500002 32989.75 1 659.8 NULL NULL 0 XOUBA - TRANSPORTES NULL XOUBA - TRANSPORTES 00001023 NULL 0 2023-11-30 1668411660 -1145752.55 0 1340 1 1 3 10:08:26 26 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 19
19 0134-0363-5336-3130-6986 2 2023-10-27 00:00:00 X 2023-10-27 00:00:00 0 634076 44917.8 1 0 NULL NULL 0 INVERSIONES DE TODITOS PAGOXAdelanto NULL INVERSIONES DE TODITOS PAGOXAdelanto 00000095 NULL 0 2023-10-31 160623954 665287.46 0 1322 1 1 3 13:18:39 26 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 20
20 0191-0106-1921-0002-0338 2 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 152027 15491.43 1 0 NULL NULL 0 VIVERES EL FUTURO, C.A FAC:00005212 NULL VIVERES EL FUTURO, C.A FAC:00005212 00000001 NULL 0 2023-10-31 1257785542 130529.07 0 22 1 1 3 15:13:27 0 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 21
21 0191-0106-1921-0002-0338 2 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 545668 37179.43 1 0 NULL NULL 0 SUN MARKET, C.A PAGO FAC:00005185 NULL SUN MARKET, C.A PAGO FAC:00005185 00000002 NULL 0 2023-10-31 1257785542 146020.5 0 24 1 1 3 15:22:24 0 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 22
22 0191-0106-1921-0002-0338 2 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 347877 154914.3 1 0 NULL NULL 0 FUTURO DISTRIBUCIONES C,A PAGO FAC:00005211 NULL FUTURO DISTRIBUCIONES C,A PAGO FAC:00005211 00000003 NULL 0 2023-10-31 1257785542 183199.93 0 26 1 1 3 15:25:16 0 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 23
23 0191-0106-1921-0002-0338 1 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 021004 7228.2 1 144.56 NULL NULL 0 TM - VIATICOS ADICIONAL NULL TM - VIATICOS ADICIONAL 00000005 NULL 0 2023-10-31 1257785542 338114.23 0 27 1 1 3 15:25:21 0 NULL 1 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 24
24 0191-0106-1921-0002-0338 1 2023-10-02 00:00:00 X 2023-10-02 00:00:00 0 00000006 144.56 1 NULL NULL NULL 0 Débito bancario, documento #021004 Monto : 7228,2 NULL TM - VIATICOS ADICIONAL 021004 1 NULL 2023-10-31 1257785542 338114.23 27 28 1 1 3 15:25:21 0 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM stransbanco WHERE `stransbanco`.`_recno` = 25
25 0191-0106-1921-0002-0338 1 2023-10-03 00:00:00 X 2023-10-03 00:00:00 0 131001 3964.05 1 79.28 NULL NULL 0 YORVIS GONZALEZ N/C 1310012 CONTRATISTA SEM 39 NULL YORVIS GONZALEZ N/C 1310012 CONTRATISTA SEM 39 00000007 NULL 0 2023-10-31 1257785542 330741.47 0 29 1 1 3 15:29:03 0 NULL 1 NULL
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