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 :
Do a "query by example" (wildcard: "%")
Column Type Collation Operator Value
_recno int(11)
FCP_CODIGO longtext utf8mb4_general_ci
FCP_FECHAEMISION longtext utf8mb4_general_ci
FCP_CODIGOUNICO bigint(20)
FCP_CODIGOUNICO2 bigint(20)
FCP_NUMERO longtext utf8mb4_general_ci
FCP_NUMERO2 longtext utf8mb4_general_ci
FCP_TIPOTRANSACCION bigint(20)
FCP_TIPOOPERACION longtext utf8mb4_general_ci
FCP_DOCUMENTOORIGEN longtext utf8mb4_general_ci
FCP_DOCUMENTOAFECTADO longtext utf8mb4_general_ci
FCP_DESCRIPCIONMOV longtext utf8mb4_general_ci
FCP_FECHAVENCIMIENTO longtext utf8mb4_general_ci
FCP_FECHAPROXIMA longtext utf8mb4_general_ci
FCP_MONTODOCUMENTO double
FCP_SALDODOCUMENTO double
FCP_SALDOMONEDAEXT double
FCP_ULTABONODCTO longtext utf8mb4_general_ci
FCP_ULTFECHAABONO longtext utf8mb4_general_ci
FCP_ULTABONOMTO double
FCP_AFECTACOMPRASMES bigint(20)
FCP_AFECTALIBROCOMPRAS bigint(20)
FCP_MTOCOMISION double
FCP_COSTOOPERACION double
FCP_ESPAGO bigint(20)
FCP_ESCHEQUE bigint(20)
FCP_NROVENDEDOR longtext utf8mb4_general_ci
FCP_ESRETENCION bigint(20)
FCP_USUARIO bigint(20)
FCP_MONTORETENCION double
FCP_CODERETENCION longtext utf8mb4_general_ci
FCP_BASERETENCION double
FCP_BASEIMPONIBLE double
FCP_BASEIMPONIBLE2 double
FCP_MULTIPLERETENCION bigint(20)
FCP_MONTOMONEDAEXT double
FCP_FACTORCAMBIO double
FCP_IMPUESTO1 double
FCP_MTOIMPUESTO1 double
FCP_IMPUESTO1PORCENT bigint(20)
FCP_IMPUESTO2 double
FCP_MTOIMPUESTO2 double
FCP_IMPUESTO2PORCENT bigint(20)
FCP_ESCHEQUEDEVUELTO bigint(20)
FCP_VIENEDE bigint(20)
FCP_FORMAPAGO longtext utf8mb4_general_ci
FCP_MONEDA bigint(20)
FCP_FECHARECEPCION longtext utf8mb4_general_ci
FCP_MARKPERIODO bigint(20)
FCP_PAGOORIGINAL double
FCP_CONVERTED bigint(20)
BASE_AUTOINCREMENT bigint(20)
FCP_CONTROL longtext utf8mb4_general_ci
FCP_DESCRIPCION longtext utf8mb4_general_ci
FCP_RIF longtext utf8mb4_general_ci
FCP_NIT longtext utf8mb4_general_ci
FCP_TELEFONO longtext utf8mb4_general_ci
FCP_DIRECCION longtext utf8mb4_general_ci
FCP_NUMERORETENCION longtext utf8mb4_general_ci
FCP_HORAEMISION longtext utf8mb4_general_ci
FCP_FECHALIBRO longtext utf8mb4_general_ci
FCP_CTOCOSTO longtext utf8mb4_general_ci
FCP_SUSTRAENDO double
FCP_REFERENCIA longtext utf8mb4_general_ci
FCP_FECHAPAGO longtext utf8mb4_general_ci
FCP_ENTERADO bigint(20)
FCP_VTANAPAGO bigint(20)
Display order: