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 `scuentasxpagar`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts _recno FCP_CODIGO FCP_FECHAEMISION FCP_CODIGOUNICO FCP_CODIGOUNICO2 FCP_NUMERO FCP_NUMERO2 FCP_TIPOTRANSACCION FCP_TIPOOPERACION FCP_DOCUMENTOORIGEN FCP_DOCUMENTOAFECTADO FCP_DESCRIPCIONMOV FCP_FECHAVENCIMIENTO FCP_FECHAPROXIMA FCP_MONTODOCUMENTO FCP_SALDODOCUMENTO FCP_SALDOMONEDAEXT FCP_ULTABONODCTO FCP_ULTFECHAABONO FCP_ULTABONOMTO FCP_AFECTACOMPRASMES FCP_AFECTALIBROCOMPRAS FCP_MTOCOMISION FCP_COSTOOPERACION FCP_ESPAGO FCP_ESCHEQUE FCP_NROVENDEDOR FCP_ESRETENCION FCP_USUARIO FCP_MONTORETENCION FCP_CODERETENCION FCP_BASERETENCION FCP_BASEIMPONIBLE FCP_BASEIMPONIBLE2 FCP_MULTIPLERETENCION FCP_MONTOMONEDAEXT FCP_FACTORCAMBIO FCP_IMPUESTO1 FCP_MTOIMPUESTO1 FCP_IMPUESTO1PORCENT FCP_IMPUESTO2 FCP_MTOIMPUESTO2 FCP_IMPUESTO2PORCENT FCP_ESCHEQUEDEVUELTO FCP_VIENEDE FCP_FORMAPAGO FCP_MONEDA FCP_FECHARECEPCION FCP_MARKPERIODO FCP_PAGOORIGINAL FCP_CONVERTED BASE_AUTOINCREMENT FCP_HORAEMISION FCP_CONTROL FCP_MONTOORIGINAL FCP_MONTOORIGINALEXT FCP_MACHINENAME FCP_ORDENPAGO FCP_CTOCOSTO FCP_FECHALIBRO FCP_SINCREDITOFISCAL FCP_VTANAPAGO FCP_MONEDACAMBIO FCP_ORIGENCAMBIO FCP_CODECAMBIO FCP_VUELTOORG FCP_FACTORREFERENCIA FCP_FACTORVUELTO FCP_FACTORVUELTOTIPO FCP_ADELANTOXCAMBIO FCP_FACTORREFERENCIA2 FCP_MULTIVUELTO FCP_BASEIGTF
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 1
1 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 2
2 G200015969 2023-10-19 00:00:00 879 0 RG8-HE-1321 NULL 1 0 NULL NULL Doc : RG8-HE-1321 2023-10-19 00:00:00 NULL 5428.85 4680.04 0 NULL NULL NULL 1 1 NULL 5428.85 0 NULL NULL 1 12 748.81 NULL 0 4680.04 0 NULL 0 1 16 748.81 1 8 0 1 NULL 3 [BLOB blk=2 len=1680] 1 1899-12-30 NULL NULL NULL 879 14:13:44 00-00539666 5428.85 0 NULL NULL NULL 2023-10-19 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 3
3 G200015969 2023-10-19 00:00:00 880 879 RG8-HE-1321 RG8-HE-1321 4 0 NULL NULL Doc : RG8-HE-1321 2023-10-19 00:00:00 NULL 748.81 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 12 748.81 NULL 4680.04 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=7 len=1680] 1 1899-12-30 NULL NULL NULL 880 14:13:44 NULL 748.81 0 NULL NULL NULL 2023-10-19 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 4
4 J000033927 2023-11-20 00:00:00 105 0 06616464 NULL 1 0 NULL NULL Doc : 06616464 2023-11-21 00:00:00 NULL 41843.1 37583.35 0 NULL NULL NULL 1 1 NULL 41843.1 0 NULL NULL 1 2 4259.75 NULL 0 35497.87 0 NULL 0 1 16 5679.66 1 0 0 1 NULL 3 [BLOB blk=12 len=1680] 1 1899-12-30 NULL NULL NULL 105 08:28:57 00-00068916 41843.1 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 5
5 J000033927 2023-11-20 00:00:00 106 105 06616464 06616464 4 0 NULL NULL Doc : 06616464 2023-11-20 00:00:00 NULL 4259.75 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 4259.75 NULL 36163.44 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=17 len=1680] 1 1899-12-30 NULL NULL NULL 106 08:28:57 NULL 4259.75 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 6
6 J000033927 2023-11-20 00:00:00 107 0 06616465 NULL 1 0 NULL NULL Doc : 06616465 2023-11-21 00:00:00 NULL 56286.1 50556.03 0 NULL NULL NULL 1 1 NULL 56286.1 0 NULL NULL 1 2 5730.07 NULL 0 47750.55 0 NULL 0 1 16 7640.09 1 0 0 1 NULL 3 [BLOB blk=22 len=1680] 1 1899-12-30 NULL NULL NULL 107 08:30:05 00-00068917 56286.1 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 7
7 J000033927 2023-11-20 00:00:00 108 107 06616465 06616465 4 0 NULL NULL Doc : 06616465 2023-11-20 00:00:00 NULL 5730.07 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 5730.07 NULL 48646.01 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=27 len=1680] 1 1899-12-30 NULL NULL NULL 108 08:30:05 NULL 5730.07 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 8
8 J000033927 2023-11-20 00:00:00 109 0 06616466 NULL 1 0 NULL NULL Doc : 06616466 2023-11-21 00:00:00 NULL 45374.64 40755.36 0 NULL NULL NULL 1 1 NULL 45374.64 0 NULL NULL 1 2 4619.28 NULL 0 38493.98 0 NULL 0 1 16 6159.04 1 0 0 1 NULL 3 [BLOB blk=32 len=1680] 1 1899-12-30 NULL NULL NULL 109 08:31:24 00-00068918 45374.64 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 9
9 J000033927 2023-11-20 00:00:00 110 109 06616466 06616466 4 0 NULL NULL Doc : 06616466 2023-11-20 00:00:00 NULL 4619.28 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 4619.28 NULL 39215.6 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=37 len=1680] 1 1899-12-30 NULL NULL NULL 110 08:31:24 NULL 4619.28 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 10
10 J000033927 2023-11-20 00:00:00 127 0 06616467 NULL 1 0 NULL NULL Doc : 06616467 2023-11-21 00:00:00 NULL 42252.79 37951.32 0 NULL NULL NULL 1 1 NULL 42252.79 0 NULL NULL 1 2 4301.47 NULL 0 35845.55 0 NULL 0 1 16 5735.29 1 0 0 1 NULL 3 [BLOB blk=42 len=1680] 1 1899-12-30 NULL NULL NULL 127 09:11:35 00-00068919 42252.79 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 11
11 J000033927 2023-11-20 00:00:00 128 127 06616467 06616467 4 0 NULL NULL Doc : 06616467 2023-11-20 00:00:00 NULL 4301.47 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 4301.47 NULL 36517.5 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=47 len=1680] 1 1899-12-30 NULL NULL NULL 128 09:11:35 NULL 4301.47 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 12
12 J000033927 2023-11-20 00:00:00 129 0 06616468 NULL 1 0 NULL NULL Doc : 06616468 2023-11-21 00:00:00 NULL 116616.47 104744.61 0 NULL NULL NULL 1 1 NULL 116616.47 0 NULL NULL 1 2 11871.86 NULL 0 98932.18 0 NULL 0 1 16 15829.15 1 0 0 1 NULL 3 [BLOB blk=52 len=1680] 1 1899-12-30 NULL NULL NULL 129 09:12:50 00-00068920 116616.47 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 13
13 J000033927 2023-11-20 00:00:00 130 129 06616468 06616468 4 0 NULL NULL Doc : 06616468 2023-11-20 00:00:00 NULL 11871.86 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 11871.86 NULL 100787.32 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=57 len=1680] 1 1899-12-30 NULL NULL NULL 130 09:12:50 NULL 11871.86 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 14
14 J000033927 2023-11-20 00:00:00 133 0 06616469 NULL 1 0 NULL NULL Doc : 06616469 2023-11-21 00:00:00 NULL 43334.43 38922.87 0 NULL NULL NULL 1 1 NULL 43334.43 0 NULL NULL 1 2 4411.56 NULL 0 36763.01 0 NULL 0 1 16 5882.08 1 0 0 1 NULL 3 [BLOB blk=62 len=1680] 1 1899-12-30 NULL NULL NULL 133 09:14:21 00-00068921 43334.43 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 15
15 J000033927 2023-11-20 00:00:00 134 133 06616469 06616469 4 0 NULL NULL Doc : 06616469 2023-11-20 00:00:00 NULL 4411.56 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 4411.56 NULL 37452.35 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=67 len=1680] 1 1899-12-30 NULL NULL NULL 134 09:14:21 NULL 4411.56 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 16
16 J000033927 2023-11-20 00:00:00 141 0 06616470 NULL 1 0 NULL NULL Doc : 06616470 2023-11-21 00:00:00 NULL 48425.06 43495.25 0 NULL NULL NULL 1 1 NULL 48425.06 0 NULL NULL 1 2 4929.81 NULL 0 41081.75 0 NULL 0 1 16 6573.08 1 0 0 1 NULL 3 [BLOB blk=72 len=1680] 1 1899-12-30 NULL NULL NULL 141 09:18:04 00-00068922 48425.06 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 17
17 J000033927 2023-11-20 00:00:00 142 141 06616470 06616470 4 0 NULL NULL Doc : 06616470 2023-11-20 00:00:00 NULL 4929.81 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 4929.81 NULL 41851.98 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=77 len=1680] 1 1899-12-30 NULL NULL NULL 142 09:18:04 NULL 4929.81 0 NULL NULL NULL 2023-11-21 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 18
18 J000033927 2023-11-24 00:00:00 346 0 06619423 NULL 1 0 NULL NULL Doc : 06619423 2023-11-27 00:00:00 NULL 10819.11 9767.88 0 NULL NULL NULL 1 1 NULL 10819.11 0 NULL NULL 1 2 1051.23 NULL 0 8760.28 0 NULL 0 1 16 1401.64 1 8 0 1 NULL 3 [BLOB blk=82 len=1680] 1 1899-12-30 NULL NULL NULL 346 09:59:52 00-00074225 10819.11 0 NULL NULL NULL 2023-11-27 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 19
19 J000033927 2023-11-24 00:00:00 347 346 06619423 06619423 4 0 NULL NULL Doc : 06619423 2023-11-24 00:00:00 NULL 1051.23 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 1051.23 NULL 9417.47 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=87 len=1680] 1 1899-12-30 NULL NULL NULL 347 09:59:52 NULL 1051.23 0 NULL NULL NULL 2023-11-27 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 20
20 J000033927 2023-11-25 00:00:00 344 0 06620105 NULL 1 0 NULL NULL Doc : 06620105 2023-11-27 00:00:00 NULL 107080.79 96196.06 0 NULL NULL NULL 1 1 NULL 107080.79 0 NULL NULL 1 2 10884.73 NULL 0 90706.09 0 NULL 0 1 16 14512.97 1 8 0 1 NULL 3 [BLOB blk=92 len=1680] 1 1899-12-30 NULL NULL NULL 344 09:58:24 00-00075166 107080.79 0 NULL NULL NULL 2023-11-27 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 21
21 J000033927 2023-11-25 00:00:00 345 344 06620105 06620105 4 0 NULL NULL Doc : 06620105 2023-11-25 00:00:00 NULL 10884.73 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 10884.73 NULL 92567.82 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=97 len=1680] 1 1899-12-30 NULL NULL NULL 345 09:58:24 NULL 10884.73 0 NULL NULL NULL 2023-11-27 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 22
22 J000033927 2023-11-29 00:00:00 523 0 06622351 NULL 1 0 NULL NULL Doc : 06622351 2023-11-30 00:00:00 NULL 43190.97 38862.85 0 NULL NULL NULL 1 1 NULL 43190.97 0 NULL NULL 1 2 4328.12 NULL 0 36067.7 0 NULL 0 1 16 5770.83 1 8 0 1 NULL 3 [BLOB blk=102 len=1680] 1 1899-12-30 NULL NULL NULL 523 13:45:29 00-00079331 43190.97 0 NULL NULL NULL 2023-11-30 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 23
23 J000033927 2023-11-29 00:00:00 524 523 06622351 06622351 4 0 NULL NULL Doc : 06622351 2023-11-29 00:00:00 NULL 4328.12 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 4328.12 NULL 37420.14 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=107 len=1680] 1 1899-12-30 NULL NULL NULL 524 13:45:29 NULL 4328.12 0 NULL NULL NULL 2023-11-30 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 24
24 J000033927 2023-11-29 00:00:00 525 0 06622352 NULL 1 0 NULL NULL Doc : 06622352 2023-11-30 00:00:00 NULL 2260.9 2041.22 0 NULL NULL NULL 1 1 NULL 2260.9 0 NULL NULL 1 2 219.68 NULL 0 1830.69 0 NULL 0 1 16 292.91 1 8 0 1 NULL 3 [BLOB blk=112 len=1680] 1 1899-12-30 NULL NULL NULL 525 13:46:10 00-00079332 2260.9 0 NULL NULL NULL 2023-11-30 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM scuentasxpagar WHERE `scuentasxpagar`.`_recno` = 25
25 J000033927 2023-11-29 00:00:00 526 525 06622352 06622352 4 0 NULL NULL Doc : 06622352 2023-11-29 00:00:00 NULL 219.68 0 0 NULL NULL NULL 0 0 NULL 0 1 NULL NULL 1 2 219.68 NULL 1967.99 0 0 NULL 0 1 0 0 0 0 0 0 NULL 3 [BLOB blk=117 len=1680] 1 1899-12-30 NULL NULL NULL 526 13:46:10 NULL 219.68 0 NULL NULL NULL 2023-11-30 00:00:00 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 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